Hello,
I am currently working on designing a report that is used to display statistics about projects but I am having trouble with designing the report correctly when it needs to display data about multiple projects.
The layout of the report is as follows.
1 page (a3 size) with two panels to divide the page. Each panel has a databand with the same datasource connected to it and the exact same set of filters.
Top half of the page (Panel1) shows grouped statistics(projectname,activityname,total time per activity, estimated time per activity, difference and a few more) on project -> activity level.
Grouping occurs on ProjectID and activityname.
Bottom half of the page (Panel2) shows grouped statistics(projectname,activityname,username, time user has spent on activity) on project -> Activity -> user level. After this panel a new page gets created so that each project starts on a new page.
Grouping occurs on ProjectID and activityname and user.
This works perfectly if there are only a few users and all the data fits on 1 page. But if there are a lot of users the data continues on a second page. But because of the panels the data does not move in sync and the top half does not correspond anymore with the bottom half of the page.
I tried it without using panels but then the data is not cutoff on a page when it is a different project and it just continues with everything.
What I would like is a way to group the data on projectID and output it on the page and only start with the next projectid (in both panels) if there are no more rows from the previous projectid in either panel.
I realise this is probably not the best description of my problem. I can send a copy of the mrt file and test reports to an e-mailadress if necessary. I cannot post it here because it contains sensitive data. A skype session is also an option if required.
Regards,
Eize
Edit:
I tried a different approach without panels and just grouping it with groupheaders. This displays it better but I still have the same issue where I can not get the software to break after a ProjectID. It just continues to show everything right after each other. Only when limiting it to 1 project does it works the way I intended.
Use one databand for different groupheaders on same page
Re: Use one databand for different groupheaders on same page
Hello, Eize.
It hard to say something when we don't see your report and what you need to get.
Our first suggestion is about the panels. You should NOT put them on the report page exactly. There should be any band.
For instance, a Data Band with Count Data property set to 1. The bands are placed on the rendered page dynamically. This could solve some your issues.
If you need to break the page for each new group, you should try the New Page Before or New Page After properties.
If you still need our help, please, send us your report template with sample data and more detailed description what you need to get.
Thank you.
It hard to say something when we don't see your report and what you need to get.
Our first suggestion is about the panels. You should NOT put them on the report page exactly. There should be any band.
For instance, a Data Band with Count Data property set to 1. The bands are placed on the rendered page dynamically. This could solve some your issues.
If you need to break the page for each new group, you should try the New Page Before or New Page After properties.
If you still need our help, please, send us your report template with sample data and more detailed description what you need to get.
Thank you.