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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply