January 14, 2015 at 10:16 am
Hello,
I created a parameter named @FundType with multiple values (ITA, OJT, SUS, YIN and WEX). I can select any values to run the report. It is showing up correctly. The problem is the grand total. For example if I select ITA, OJT, the report shows up ITA and OJT data only, however the grand total is added up for all five values.
If I select ITA, SUS, YIN and WEX, the grand total is added up for all five values too. I used filters like [Type] in @FundType, but it does not work.
Please help.
Thanks
January 14, 2015 at 11:14 am
Something is odd here. How are you creating your grand totals?
Can you post a report with dummy data, so we can recreate the problem?
I've just never heard of totals working like that. Are you using a single dataset?
January 14, 2015 at 2:07 pm
Is the parameter being used as a filter in the initial query, or is it only being used in the visibility properties of the report (so it shows only the rows for the values you select)? If the latter, I could see how your totals would still be for all values even if you were only selecting one or two.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply