Hello all,
I am trying to utilize a group variable in an SSRS report as documented here: https://msdn.microsoft.com/en-us/library/dd255208(v=sql.105).aspx
We have a report that contains two groupings in the tablix, and one group is a parent of the other. In the parent group I defined a variable called "AggCatFourMonth" which I want to use to divide a summation in a field in the child group. The idea is that the report reader wants to know the percentage of the category total a particular value is. So for example if the main detail group has lines that resolve to 20, 30 and 40, I want to know what percentage 20 is of the aggregate (90). Here's an example of the tablix to give you a better idea of what I am talking about:
Basically we want to divide the "Detail Breakout" by the "Parent Aggregation" field. According to the link I posted above, we should be able to accomplish this by setting a variable in the Variables section of the group properties and that variable will then be available to the group and any child groups. You can set the variable in the group properties window as seen here:
The expression for the AggCatFourMonth variables is identical to the summation of the details lines in the parent group. Since the child group should be able to see this variable in scope, I should be able to use it to figure out the percentage.
However when I build the report project when I attempt to reference the group variable I get the following error:
Value is invalid. InvalidIdentifier
I have managed to track this down to the my call to the group variable because I commented out the value of field expression and made it just the variable. However it is not a scope issue because the variable doesn't work anywhere (in the aggregate row I divide the aggregate by the variable--they should be the same so I should get 100%.)
Is it possible to use these group variables with a Dynamics SSRS report? The alternatives to getting this value are painful to say the least, so if I can get the easy way to work, I would really like to do that instead.
