1)If in this question we want to deal with null in MSTR

report than we have some display property in report data

option which we can change according to the replacement of

null values.

DATA>>REPORT DATA OPTION>>DISPLAY>>NULL VALUES

2)if we want to deal with sql geration of report than there

is an option of VLDB property according to you requirment u

can deal with sql query of report.