Dynamic grouping/outline in Spreadsheet designer
Posted 02 March 2012 - 03:46 PM
Let's say I have dataset with two columns (the first represented by a letter and the second a number):
column_1 | column_2
A | 1
A | 2
A | 3
B | 1
B | 2
B | 3
C | 1
C | 2
C | 3
What i want the report to do is group/outline each unique value in column_1 with a subtotal line and have it expand to show all the details.
IE on the report it would look like
+ A 6
+ B 6
- C 6
Now i've figured out how to do that with a static number of groups, IE when the dataset always returns the same number/type of rows I want to group by (if there's always 3 different group by's columns then i just create 3 data ranges and can fill it out appropriately "decrease detail outline" on each of the three columns). However, I have no idea how to do this when my dataset will return a varrying number of results (based on parameters passed to it at runtime). I have no idea how to do this in BIRT spreadsheet designer, but i'm sure there has to be a way/trick, seems fairly standard.
I basically need to put a "metaphorical" foreach loop somewhere to build a similar datarange for each unique/group value in column_1. lol, i don't know.
Sorry if I didn't do a good job explaining my situation. I appreciate everyones time, and hope someone can help me out with this problem!
I never posted back how to do this (a long time ago), in case anyone else ever comes across this thread wondering.. Just create your base/most detailed level row group, on the grouping tabs on the right of the data set, highlight it and the row above it, right click and say "create parent". right click on that parent and then say group, and assign it to some other column from your dataset. Fairly straight forward just didnt find it documented before.