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

Multiple reports depending on parameter

Dhanya

All,

In my report, I have the following requirement.

I have a custom Work item called object. The hierarchy where this fits is as below
Iteration1 (Maintenance) - > Iteration 2 (Waves - Wave1, Wave2 etc) --> contains many many Objects.

Inside each object I have a field called 'Planned for' which indicates which wave it is part of.
The report is designed for each object. (I take it in .xls and then to .txt)I have restricted user from selecting many objects at a time using display type for the object as Combo. So that user can select only one object.

But the user might need to get independent .xls files for all the objects belonging to a wave.
So if he selects the 'Planned for' as Wave1, then he should get different .xls for each of the objects under that.

What will be the solution? It is not a simple page break.

Thanks
Dhanya

Find more posts tagged with

Comments

mwilliams

So, you want a separate report to be ran for each object under the wave rather than just separating them to different pages? If so, you'd probably have to edit the XLS emitter to create a new file for each different group, or something like that. Or, you could possibly do your parameters external to BIRT and actually run the report for each individual object in the selected "wave", so that each one runs separately.

Dhanya

Hi Michael,

I don't have much information on Xls emitter. But I can search.

I will come back if I need further help..

Thank you
Dhanya

Dhanya

<blockquote class='ipsBlockquote' data-author="'Dhanya'" data-cid="77956" data-time="1307106602" data-date="03 June 2011 - 06:10 AM">
Hi Michael, 
 
I don't have much information on Xls emitter. But I can search. 
 
I will come back if I need further help..

Thank you 
Dhanya </blockquote>
 
Hi Michael, 
 
I need your help in editing the XL emitter. 
How can I start with this topic? 
Please let me know. 
 
Thanks 
Dhanya

mwilliams

I have not edited the XLS emitter, so I don't know what all you'll have to do for this, but you'll just need to grab the plugin for the XLS emitter from the plugins folder and unjar it. After you edit it, you'll have to re-jar it and replace the old emitter. I'm not sure what all is going to have to be done. Writing a java program to run the report for separate values to get the separate reports might end up being easier.

kallem

Download Birt sources. In the plugins folder there is org.eclipse.birt.report.engine.emitter.prototype.excel packet where you can find Excel emitter files.

Dhanya

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80630" data-time="1311733583" data-date="26 July 2011 - 07:26 PM">
I have not edited the XLS emitter, so I don't know what all you'll have to do for this, but you'll just need to grab the plugin for the XLS emitter from the plugins folder and unjar it. After you edit it, you'll have to re-jar it and replace the old emitter. I'm not sure what all is going to have to be done. Writing a java program to run the report for separate values to get the separate reports might end up being easier. </blockquote>
 
Hi Michael, 
 
If I am to choose between the two devils, I will got for the Java programming. 
But I do not have a clear picture of how to do this. 
For the example Iteration1 (Maintenance) - > Iteration 2 (Waves - Wave1, Wave2 etc) --> contains many many Objects, 
For each of the object I need to say, 'go and give the report' but how do i make the object give the report... can u give me an example of a Java program accessing these? 
 
Thanks 
Dhanya

mwilliams

Not sure if I'm understanding correctly, but you would probably have to have a report or reports designed that would work with the objects within your wave object. In your Java, you'd have to call the BIRT engine to run the needed report with the parameters required to run the report only for the current object. So, you'd loop through your object of objects, running a report for each. This is how I'm looking at it anyways, with my current understanding. Let me know.