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
Sorting by column within a Group
Migrateduser
if this posts twice, I apologize.
Hi all! I have a BIRT question that has had me stumped for a couple of days now. I'll try and describe the scenario as best I can.
I have my SQL which collects a listing of events and attendees. Every event has multiple attendees, each attendee has a different denotation or title, example; attendee 1 = Captain, attendee 2 = Private.
When I run my SQL I get all the events listed and all the attendees along with their titles for the event. The report needs to display the event once and the person how is denoted with a specific title, like Captain. If there is no one denoted as Captain, the event must still be listed. Here are two example rows.
Group Header Row: Date Location EventType EventSubtype
Detail Row: Attendee Name (if this attendee is denoted as Captain)
Because every event can have multiple attendees, the attendees are listed in a bridge table consisting of the primary key for the attendee and the event. My SQL returns all attendees and it will list an event multiple times. I put a group in BIRT on the event primary key and the attendees are in the detail row that will only be visible if the attendee is denoted as a Captain. The report now has to be sorted by the first column in the header, Date, ascending.
My question; I have the group forming based off of the primary key and each group will only have a detail row based on how many people are denoted as captain. How can I sort all the entries for a group based off of the date column in the group header row? If I have 30 entries for the event group, they need to be ascending based off of the date. I seriously appreciate any help that can be given and if you read this far, thanks!
Find more posts tagged with
Comments
There are no comments yet