April 24, 2009 at 11:38 am
My tablix looks like this:
year 1 year 2 year 3
sales 1 100 125 200
I want a static column at the end that determines the % change from YEAR 1 to year 3. When I add a static column at the end, I can get the value of year 3 because the value in ReportItem for the cell is always the last column. I tried adding another column in the group that kept a running total but I was able to add 0 to the running total if it wasn't the first column which gave me the value of the year 1 field in another ReportItem cell. At this point, I could reference the two ReportItems and get the correct values in the first and last column and it worked. However, as soon as I set the extra column group to invisible, it stopped accurately keeping track of the running total. Something about hiding the column causes problems.
Anyone have any suggestions? I don't want to change my sql.
May 8, 2009 at 2:45 pm
rsober (4/24/2009)
My tablix looks like this:year 1 year 2 year 3
sales 1 100 125 200
I want a static column at the end that determines the % change from YEAR 1 to year 3. When I add a static column at the end, I can get the value of year 3 because the value in ReportItem for the cell is always the last column. I tried adding another column in the group that kept a running total but I was able to add 0 to the running total if it wasn't the first column which gave me the value of the year 1 field in another ReportItem cell. At this point, I could reference the two ReportItems and get the correct values in the first and last column and it worked. However, as soon as I set the extra column group to invisible, it stopped accurately keeping track of the running total. Something about hiding the column causes problems.
Anyone have any suggestions? I don't want to change my sql.
You could tell MS to create a proper Reporting tool, otherwise as far as I know you can not.
You can only add Sub_Total, which is rather useless.
May 8, 2009 at 3:06 pm
I was able to solve this issue. I create a hidden column group that only contained the first year which I know from the parameter array. I then reference this reportitem in the column that calculates the % change
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy