Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Multiple Table Display Sequence
Migrateduser
<p>Hello experts, I've been looking for BIRT report help and Google told me this forum is the way to go. Hope the experts here could kindly provide some assistance.</p><p> </p><p>I am making a report that consists of four tables, using 4 data sets, with the structure below:</p><p> </p><p></p><p>[Table 2. Meter reading]</p><p>[Table 3. Safety Check 1</p><p>Safety Check 2</p><p>Safety Check 3</p><p>.</p><p>.</p><p>.</p><p>Safety Check 10]</p><p>[Table 4. Responsible Persons]</p><p> </p><p>So far, if I print a single report, the display is excellent. Everything is neatly placed. However, in case if user selects multiple items to generate the report (3 different "Sites" in the example), the report will be screwed up like this:</p><p>[Site A Table 1.]</p><p>[Site B Table 1.]</p><p>[Site C Table 1.]</p><p>[Site A Table 2.]</p><p>[Site B Table 2.]</p><p>[Site C Table 2.]</p><p>[Site A Table 3.]</p><p>.</p><p>.</p><p>.</p><p>[Site B Table 4.]</p><p>[Site C Table 4.]</p><p>That does not represent a logical order to the users. In other words, I don't want it to group by Tables, they have to be grouped by "Sites". I've been am searching for a method to deal with that, but I don't know the keywords to search on this.</p><p> </p><p>What I really want to achieve is like:</p><p>[Site A Table 1.]</p><p>[Site A Table 2.]</p><p>[Site A Table 3.]</p><p>[Site A Table 4.]</p><p>[Site B Table 1.]</p><p>.</p><p>.</p><p>[Site C Table 3.]</p><p>[Site C Table 4.]</p><p>So that when user prints out the reports, they can distribute the reports to the store managers of different sites.</p><p> </p><p>Would it be the case that I must re-write the SQL into one query? </p><p>Any help would be greatly appreciated.</p><p> </p><p>Thanks in advance.</p>
Find more posts tagged with
Comments
There are no comments yet