November 28, 2006 at 11:36 am
I have a report to create, where I need to be able to reference the contents of a Cell (textbox) from one table in an expression in a cell in another table. Does anyone know if this can be done? If so, whats the syntax?
My searches in MSDN / Google / etc haven't returned anything useful, if anyone has got results from any of these sources - what was your search?
Thanks in advance for the help.
November 28, 2006 at 3:46 pm
Simon,
Is this something like NetProfit = Sales - Costs? If so, can you use the style of expression like -> =Fields!Sales - Fields!Costs within the formula for the NetProfit cell?
Steve.
November 28, 2006 at 4:06 pm
Steve,
no it isnt. It's actually a Profit and Loss report. Due to formatting requirements, I have to include sub-total lines that dont fall into the Accounting hierarchy (broadly speaking the hierarchy is Group / Sub-Group / Category), in that I have to include Group-Level totals at the Sub-Group Level for a specific Sub-Group.
Group 1
SubGroup 1A
Totals for SubGroup 1A
SubGroup 1B
Totals for SubGroup 1B
Totals for Group 1
Group 2
SubGroup 2A
Totals for SubGroup 2A
SubGroup 2B
Totals for SubGroup 2B
Totals for SubGroups 2A + 2B *** This is the Group Level Total that falls outside the Account hierarchy
SubGroup 2C
Totals for SubGroup 2C
Totals for Group 2
Totals for Group 1 - Totals for Group 2
etc
In order to accomodate the Totaling requirements, I have added an artificial collection value into the SSAS cube data, such that Group 1 is collection 1, Group 2 (SubGroup 2A / 2B) is collection 2, Group 2 (SubGroup 2C) is collection 3 (etc), this obviously breaks the hierarchy in the Accounts dimension.
I have configured the report with multiple tables, and filtered the incoming data on the collection value for each table. As the Total values flow down the report, I am trying to avoid having to recalculate from scratch the Totals for each table, instead wanting to use the Totals calculated in the prior tables. I cant seem to find how to refer back to the previously calculated values. I have created the report with the code to recalculate every time the Totals are needed, but don't think this is a good solution due to the repeated calculations.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply