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

Scripting the report layout in BIRT 4.5

Istabrak · 2016-04-13T11:26:46+00:00

Greetings to all, I am using BIRT4.5 bundled with Eclipse. In one of the data sets I am working on, I have is a csv file with about 100 columns of numerical data. I have a requirement to group them and then aggregate them based on a certain condition. I tried dragging the Aggregate…

Istabrak

Greetings to all,
I am using BIRT4.5 bundled with Eclipse.
In one of the data sets I am working on, I have is a csv file with about 100 columns of numerical data.
I have a requirement to group them and then aggregate them based on a certain condition.
 
I tried dragging the Aggregate button from the Palette to the layout cell but with a large number of columns it does not seem to be an efficient approach.
Moreover, it is very difficult to work in the layout area when the number of columns is too large since the cells will be very small.
Is there a way to programmatically (or via a script) to define these aggregates and assign them to the respective cells?
Is there a way to cut and paste some of the layout elements or store the report layout design as a common resource?
 
Thx and BR

Find more posts tagged with

Comments

pricher

Hi,
 
You say you "have a requirement to group them and then aggregate them". What are "them"? Columns from your original data set? If so, aggregations will not help you since aggregations work on grouping by row, not column.
 
In any case, you can define Aggregations directly in the Table's Bindings without dropping an Aggregation component to the table. Then, to use an aggregation in your table, you drop a Data component in the table, cancel the New Data Binding window, right-click on the Data component your just dropped, and choose Change Data Column to assign the Aggregation.
 
Hope this helps,
 
P.

Istabrak

Hi Pierre,
Thanks a lot for the info.
Yes, you are right about the aggregation and grouping, I meant by "them" the rows.
I tried your method and it works great on the table if the number of columns is about 20 to 30.
However, if the number of columns in the table gets larger, then it would be difficult to drop a "Data" component into the desired table cell.
Is there another way of doing this part without having to do the drag-and-drop way?
I tried increasing the zoom level to 400% but the cells are still too small and do not allow me to drop the "Data" components.
 
Best regards

pricher

You can always use the report Outline to add an item to a cell, as shown here;

jfranken

Another option is to go to the Master Page tab. In the properties for "type", select "custom". Enter something like 100in for the width. That will make manipulating the cells easier. When you're done editing, you can change the type back to US Letter.

Istabrak

Greetings to all,
Thank you all for all the input.
 
One more question:
I will take me about 7 hrs to fill in the layout with the needed groups and aggregations.
I have 8 files with identical structures, is there a way to reuse this layout for all 8 input files or do I have to go thru the pain of
redoing the grouping and aggregations for each input file?
 
Best regards

pricher

Hi,
 
Your best strategy is probably to use a report library to store your table after you have created all the groups and aggregations. Then, you can use that "master" copy in other reports.
 
Here's a <a data-ipb='nomediaparse' href='

https://www.youtube.com/watch?v=HnSjj2N8xFc'>video tutorial</a> on using report libraries. I am sure you can also find other resources on the web to help you understand how to use report libraries.
 
Hope this helps,
 
P.