SUBREPORTS REQUIRES REFRESH TO SHOW DATA FIRST TIME - MS RS2005
Posted on 2006-04-07
I am having a very strange problem with RS2005. I have a report and a subreport.
Both of them have three multivalue parameters. I have a chart on my
main report, when I click on a column I go to a subreport passing
parameters to the subreport using Join functions (to pass multivalue
parameters) like this:
in my data filed for the chart, right-click on the field, action ->
jump to subreport -> parameters. There for each parameter I say
The newline character is for the multivalue drop down.
I click on the column and see my subreport with all the parameters
passed. They are seen in dropdowns but the data is not there. If I
click "View Report" my data shows up. In other words, parameters are
being passed but the subreport requires refresh. I can not explain this
behavior. Can anbody help me?