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
Developing Analytics Applications
Creating one grid per data row with a dynamic number of columns?
Migrateduser
<p>Hello,<br />
<br />
I am trying to migrate a PDF report from one project to another. The old project uses iText 1.3. The new project uses Eclipse BIRT 2.4. I am new to BIRT so I apologize in advance if my use of terminology is off.<br />
<br />
The format of the old report looks like a small table per row from the database query. I was thinking that I might be able to put a grid per datarow in the XML .rpt file and pass the contents of the grid as datarow parameters. I have the skeleton for this converted report set up as a ScriptedDataSetEventAdapter, based on the format of the other BIRT report in the project.</p><p> </p><p>However, there is a wrinkle in this problem. The small table can have a variable number of rows. Let's say my report is a list of shoes.:</p><p> </p><p>Datarow 1:</p><p>[font="'courier new', courier, monospace;"] Inventory per size[/font]</p><p>[font="'courier new', courier, monospace;"]Item 123. Lovely Oxfords. 7 8 9 10 [/font]</p><p>[font="'courier new', courier, monospace;"] 1 2 2 0[/font]</p><p> </p><p>Datarow 2:</p><p> [font="'courier new', courier, monospace;"]Inventory per size[/font]</p><p>[font="'courier new', courier, monospace;"]Item 456 European Clogs 37 38 39 40 41[/font]</p><p>[font="'courier new', courier, monospace;"] 1 3 3 2 1[/font]</p><p> </p><p>[font="arial, helvetica, sans-serif;"]As you can see, the number of the "size" columns as well as the titles of these columns can be totally different depending on the row. I'd like to reuse the data retrieval code from the old report, and I have this data available as Java POJOs, built from a database query. Is it possible for me to dynamically build a BIRT grid for each datarow and pass it to the report? Is this a good approach to take to this problem?[/font]</p><p> </p><p>[font="arial, helvetica, sans-serif;"]Thanks for any insight.[/font]</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet