nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Column Grouping

mastermine11

I was wondering if BIRT is capable of the following: I have a query: select * from PERSON where CITY='****' The person database table has the following columns: pk, name, date of birth, spouseName, spouseDateofBirth, city I want to return a cross table showing person's name and DOB as well as their spouse's name and DOB My requirement is for the report table to look like: __________________________________________________________________________________ Person | Person's 1's Spouse | Person2 | Person's 2's Spouse | etc....

Name |Date of Birth | 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. I am thinking of using data cubes with cross tab.

Find more posts tagged with

Comments

micajblock

Or you can use a list with display set to inline. Here is one example, it should give you an idea. <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list</a>

mastermine11

I don't think making a list inline would work in my situation. The problem is not because the report gets too long vertically, and I want to split the results into multiple columns. The problem is: for every dataset row, I want to create a [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Person and Person's 's Spouse column. So, if I have 5 rows in my dataset, I want 5 sets of [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Person and Person's's Spouse's columns. I do not know how many dataset rows get return initially, so I can't hardcode the number of columns before hand. I only know how many rows I get after I run my query. [/color]

micajblock

Can you attach a CSV with sample data and the version of BIRT you are using?

mastermine11

Sure thing. 
 
I am using BIRT 4.3. I have attached my CSV file. This forum does not permit me to upload files with CSV extension, so I changed it to txt. You can run the query: [color=#000000;][font="helvetica, arial, sans-serif;"]select * from PERSON where city='NYC'[/color][/font] 
 
My goal is for the report to appear as: 
[color=#000000;][font="helvetica, arial, sans-serif;"]__________________________________________________________________________________[/color][/font] 
Person | Person1's Spouse | Person2 | Person2's Spouse | Person3 | Person3's Spouse

Name | joey jane mark leila bob bobina 
Date of Birth | 19770222 19790303 19831103 19850710 19761222 19750524

micajblock

Will this work? P.S. I changed the CSV file so that the dates are in yyyy-mm-dd format so BIRT can read them in as dates.

Hans_vd

I took a different approach, using a crosstab.Take a look at this post to see the steps I took to create the report: <a data-ipb='nomediaparse' href='http://enterprisesmartapps.wordpress.com/2013/09/20/mulitple-detail-rows-in-a-birt-crosstab/'>http://enterprisesmartapps.wordpress.com/2013/09/20/mulitple-detail-rows-in-a-birt-crosstab/</a> mblock, I tested you report too, it works and looks somewhat easier than my solution. For some reason I can't upload any files to this forum...

mastermine11

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120564" data-time="1379678466"><div>Will this work? P.S. I changed the CSV file so that the dates are in yyyy-mm-dd format so BIRT can read them in as dates.</div></blockquote> Thanks mblock. It works great. It seems the magic happened when you made the detail grid in the list's display to inline. How were you able to auto resize the person and spouse column? <blockquote class="ipsBlockquote" data-author="Hans_vd" data-cid="120566" data-time="1379686280"><div>I took a different approach, using a crosstab.Take a look at this post to see the steps I took to create the report: <a data-ipb='nomediaparse' href='http://enterprisesmartapps.wordpress.com/2013/09/20/mulitple-detail-rows-in-a-birt-crosstab/'>http://enterprisesmartapps.wordpress.com/2013/09/20/mulitple-detail-rows-in-a-birt-crosstab/</a> mblock, I tested you report too, it works and looks somewhat easier than my solution. For some reason I can't upload any files to this forum...</div></blockquote> I will have to look into this solution a little bit later.

micajblock

<blockquote class="ipsBlockquote" data-author="mastermine11" data-cid="120568" data-time="1379695483"><div>How were you able to auto resize the person and spouse column? </div></blockquote>It is not auto resize. It is fixed to 1 inch.