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; } } }

Example on Cross tab

rohitmali

Hi,

Can anybody provide me the example on Crosstab i.e. How to use it in reports through java code?

Find more posts tagged with

Comments

mwilliams

Can you explain more? Are you wanting to know how to create a crosstab using java? Or how to create a crosstab in the designer and then deploy the report using java? Let me know.

rohitmali

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97280" data-time="1330986592" data-date="05 March 2012 - 03:29 PM">
Can you explain more? Are you wanting to know how to create a crosstab using java? Or how to create a crosstab in the designer and then deploy the report using java? Let me know. </blockquote>
 
 
Thanks for reply, 
 
How to create a crosstab in the designer and then deploy the report using java? 
 
I need to create dynamic columns based on dates present. 
 
For e.g. Start Date: 01-Jan-2012 and End Date: 31-Jan-2012 
So I need to create 31 columns, the start date and end date may change as it is an user input.

mwilliams

To create a crosstab, you must first create a dataCube. Right click on Data Cubes in your data explorer and create a new cube. You'll put your date field and whatever field will define your rows (if any) into the dimensions area and whatever field will be the data field, in the measures area. Now, you can drag a crosstab out from the palette. Expand your newly created data cube and drag the measure field to the measure area, your row dimension to the row dimension area, and the column dimension to the column dimension area. Your crosstab is now complete.

The parameters that the user enters to limit the dataSet will also limit your crosstab. As for running the report using java code, what is your BIRT version?

rohitmali

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97319" data-time="1331048212" data-date="06 March 2012 - 08:36 AM">
To create a crosstab, you must first create a dataCube. Right click on Data Cubes in your data explorer and create a new cube. You'll put your date field and whatever field will define your rows (if any) into the dimensions area and whatever field will be the data field, in the measures area. Now, you can drag a crosstab out from the palette. Expand your newly created data cube and drag the measure field to the measure area, your row dimension to the row dimension area, and the column dimension to the column dimension area. Your crosstab is now complete. 
 
The parameters that the user enters to limit the dataSet will also limit your crosstab. As for running the report using java code, what is your BIRT version? </blockquote>
 
 
Thanks. I got it.