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

Cross Tab Report

legend.ram

Hi,

Please help me to create a report with dynamic columns and rows. date in column area and Unit is row area.

The parameters are from date and to date as mandatory and Unit type as optional.

My tsv will have Date, Count, Unit data in every row. I tried to create report using CrossTab, but I am unable to calculate and insert variance( (Current_Column_Count-Previous_Column_Count)/Previous_Column_Count ) in the report.

Please refer the attachment for report data and report output format.

I am using birt 2.5.1 runtime.

Thanks in Advance...

Regards,
Ram

Find more posts tagged with

Comments

mwilliams

Hi Ram,

You want the Variance to definitely be below the value? Or can it be next to it?

legend.ram

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66347" data-time="1278949320" data-date="12 July 2010 - 08:42 AM">
Hi Ram, 
 
You want the Variance to definitely be below the value? Or can it be next to it? </blockquote>
 
Hi mwilliams, 
 
Thanks for your reply... I want variance to the definite below value... 
For example, Please look at the below one. 
 
Jan-10 Feb-10 Mar-10 
Unit1 100 120 110 
Variance No_Variance 20.00% -8.33% 
 
for Jan-10 no data available for previous month so variance not defined 
for feb-10 variance is calculated on jan-10 data... 
 
Regards, 
Ram

mwilliams

Take a look at this example. There is script in the initialize method of the report, the onCreate of the measure element, and in the dynamic text box below the measure element. You'll have to do a little more to handle multiple "units", but this should get you started. Let me know if you have questions.

legend.ram

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66383" data-time="1279038685" data-date="13 July 2010 - 09:31 AM">
Take a look at this example. There is script in the initialize method of the report, the onCreate of the measure element, and in the dynamic text box below the measure element. You'll have to do a little more to handle multiple "units", but this should get you started. Let me know if you have questions. </blockquote>
Thanks Allot... I handled for multitple units

.. Now its working fine...

mwilliams

Great to hear! Let us know whenever you have questions!