Seal Report Forum
»
Report Edition
»
Reports
»
How to create a Group By within a Group By
Rank: Member
Groups: Registered
Joined: 6/5/2014(UTC) Posts: 23  Location: Dublin Thanks: 1 times
|
Hi
I would like to create a report that has totals for Groups within Groups,
Please see an example below
Type Total
Biscuits 100
Digestive 50
Chocolate 30
Milk 10
Dark 20
Plain 20
Pink Waffer 20
Rich Tea 20
Hobb Nobbs 10
Chocolate 5
Plain 5
I know you add the Group By into the elements however if you add another field to that box it does a group by including both of those fields.
Can you give me an idea of how to go about the above.
Thanks,
Siobhan
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Hi, sorry but the question is not so clear for me, you may describe better your table and data and the result you want... You cannot have a group by inside another group by unless you write your own SQL and use it in the SealMasterTable. You can also read the posts concerning Analytics (in the Advanced Tricks and Tips section) and you will probably be able to achieve your goal. Edited by user Wednesday, August 6, 2014 8:09:11 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/5/2014(UTC) Posts: 23 Location: Dublin Thanks: 1 times
|
I know you think this is a self explanatory tool, however you really need to create a help document with screen shots.
Everything I go do is not straight forward...... It is very different from any other reporting tool and needs documentation with examples.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/5/2014(UTC) Posts: 23 Location: Dublin Thanks: 1 times
|
What I am really asking in this topic is how do I create a detail line below another detail line. sing the SQ
I know I create all my counts etc using SQL into either a view or the Seal master table. It the way I want the detailed displayed that I am having trouble with. To have a second detail line is very common in reporting I just don't see any documentation on how to use the elements to display this info.
The second detail line shows some additional information associated with the line above. Like in the example above where the report is showing The total Number of biscuits liked, then on the following detailed line shows detail of what are the types of biscuits like Digestive, Pink Waffer, however I want to show them on separate lines.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Hi, I understand your requirements and it is a common request to do Master-Detail in reporting, but unfortunately it is not really obvious do do that with Seal Report as the model returns only one DataTable from a single SQL statement.
You can have a kind of master-detail by using the Page elements, then you have a break per value where you can use the Column and Row to display the detail...
Otherwise it is planned in a future version, to have detail report you can run from another report element, but this feature is not available yet.
Eric.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/5/2014(UTC) Posts: 23 Location: Dublin Thanks: 1 times
|
Hi
I am happy to try the column and rows option. Can you give me a small example of how this works?
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
It is quite simple, just drag and drop your master elements only in the Page panel,
then use the normal Rows, Columns, Data panels for your detail tables,
you will then have a Page table followed by a Detail table for each different values of the page elements (CF the sample report 01-Simple List where you have the detail of the products for each category)
The main problem is that you cannot have aggregate (Sum, average, etc..) in the Page tables....
Eric
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
How to create a Group By within a Group By
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
