subreport displaying error msg when no data to display Error Subreport could not be shown
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?
June 18th, 2012 4:49pm
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.
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2012 4:56pm
Hi Syed Qazafi Anjum, both parameters are set to allow null and blank values
June 18th, 2012 6:38pm
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
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2012 6:41pm
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
June 18th, 2012 6:59pm
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.
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2012 7:11pm
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
June 21st, 2012 7:26pm