Prev: Jump To URL issue
Next: Email subject line @ExecutionTime
From: Connie on 26 Jan 2010 21:30
I have a report against Analysis Services (all in 2005) which uses the
back_color I defined in the cube for the report's textbox BackgroundColor. It
works fine for detail rows but on grouped rows it is using the color
belonging to the first record instead of the color belonging to the
aggregated values for that level of grouping.
Due to the nature of our location hierarchy I have set up a table group for
each level of the hierarchy and a group level row of data for the aggregated
values and this seems to be the reason that the background color is working
incorrectly. For each group in the hierarchy I have defined the following for
a sample column:
Textbox Value: Aggregate(Fields!AvgSales.Value) – works perfectly, returns
the aggregated values *from the cube*
Textbox BackgroundColor: Fields!AvgSales.BackgroundColor – does not work for
groups, returns the first value in the group (again, this is perfect at the
location level, which is the lowest level)
Is it possible to reference the background color from cube's aggregated
values for each group instead of the first value from the group?

 | 
Pages: 1
Prev: Jump To URL issue
Next: Email subject line @ExecutionTime