Could Not Create Aggregation Based On Data in Nested Tables

mmah

I am currently trying to create a few aggregate fields based on certain data fields that exists via nested tables. For example, data fields Field 1, Field 2, Field 3 comes from a nested table that is the fourth layer (table 4) (in other words, table 2 is nested in a cell of table 1, table 3 is nested from a cell in table 2, table 4 is nested from a cell in table 3).

The aggregation is to be placed at the main table (table 1) and to make things worst, I need to show the total based on the 5 groups I've established, starting with the last group to top. (e.g, total by risk class, then total by sub class, total by department, etc)

I did try doing this but I get error exceptions when i try previewing the report.

I'm not sure whether if it is not possible to do this or whether I need to introduce something new to the report that I could have missed out earlier.

Please advise on this. Thanks.

mwilliams

Hi mmah,

You've probably already found a solution to your issues, but a couple things that could be tried in this situation for anyone else with the same question would be to join the dataSets together that are used in these tables and just use grouping within the table to separate out the different "levels". Or you could use your own variables and do your computations in script and display your final values in the very outer table using a text box, dynamic text box, or data element.