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
Column Grouping
Migrateduser
<p>I was wondering if BIRT is capable of the following:</p><p> </p><p>I have a query: select * from PERSON where CITY='****'</p><p> </p><p>The person database table has the following columns: pk, name, date of birth, spouseName, spouseDateofBirth, city</p><p> </p><p>I want to return a cross table showing person's name and DOB as well as their spouse's name and DOB</p><p> </p><p>My requirement is for the report table to look like:</p><p> </p><p>__________________________________________________________________________________</p><p> Person | Person's 1's Spouse | Person2 | Person's 2's Spouse | etc....</p><p>
</p><p>Name |</p><p>Date of Birth |</p><p> </p><p>Essentially, I want to create the Person and Person's Spouse column for each person row in the dataset. You can think of it as a column grouping. </p><p> </p><p>I am thinking of using data cubes with cross tab. </p><p> </p><p> </p><p> </p><p> </p>
Find more posts tagged with
Comments
There are no comments yet