Last post Nov 28, 2014 05:38 AM by Nishantg
Nov 27, 2014 05:13 AM|Nishantg|LINK
I have a main Report which is calling a subreport. Supreport is working fine by itself with same set of parameter value and also if I give hard coded value from main report it is working fine, problem starting when I am trying to set the parmeter value using
expression. I checked my expression by executing it in the other text box and value is coming fine. I tried using Drillthrough report by setting the param value using same expression and its working fine. Just wondering why it is not working for subreport.
Thanks in advance.
Nov 27, 2014 05:53 AM|shetesagar87|LINK
I also faced the same problem few days back hope it may help you.
There were 2 dataset that were binded to the report.The first dataset was of main report while one more dataset was binded to the Subreport. There was a null value coming from the main dataset which was making the problem in the binding of the subreport.
Though it may happen that you might be having some another issue.
For debugging process you can print all the dependable parameters on the report and investigate the issue.
Nov 27, 2014 06:35 AM|Nishantg|LINK
Thanks for your reply, but I already tried those things every expression is giving me correct data, and as I said in my post that the same expression is working if I am calling a drillthrough report and just not working for Subreport.
Nov 28, 2014 01:22 AM|Michelle Ge - MSFT|LINK
Now I'me not sure why it cannot work. But to pass a value from the group or row to the subreport, in the subreport value property, use a field expression for the field containing the value you want to pass to the subreport parameter.
I suggest you to check the steps to add a expression for SubReport, please refer to the link below to take all the steps:
Hope it's useful for you.
Nov 28, 2014 05:38 AM|Nishantg|LINK
Thanks for your reply,
I was also wondering and scratching my head that why its not working, but somehow I mange it to work. I have written the same expression in a text box and then pass the value from text box to the subreport and its working fine.