report displays data for time range in a matrix report when there is no data for a specific time range then the error msg appears. I can change the visibility setting for this txtbox but then the borders disappear and this looks weird in the main report =iif (First(Fields!NHI.Value) is Nothing,True, False) before changing the visibility you can see there are borders After changing visibility no boarders. Is there a way I can keep the borders without displaying the error msg?

Hi There Can you please try to put your sub report parameter to accept null and blank value I hope this will resolve your problem Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Syed Qazafi Anjum, both parameters are set to allow null and blank values

Hi There Thanks for your posting again Have you run the report independently with null and blank values Does it display any error? Please update Many thanks Syed

Hi There One thing more can you please try when you are passing the paarmeter to sub report please put some thing like this =iif(Fields!AgeGroup.Value is nothing,0,Fields!AgeGroup.Value) This is value expression for your parameter inside Subreport properties when you passing parameter values to Sub Report Many thanks Syed

Hi Syed, the parameter values being passed to subreport always have a value. the subreport runs a query that returns another field value using the parameters as criteria. Sometimes this returns no value. I have tried a number of things but have so far only but changing visibility is the best I have found, don't think anything else is possible.

Hi There What is the data type of your parameter inside sub report ? is it same as you are passing from main report When you use a subreport: cast the variable to be passed with the correct type. As a result you just need ONE explicit cast Please try this one that might help Many thanks Syed