I need help formatting a report in BIRT. I have attached a word document of how I want a report to look like in BIRT. Basically its two columns but what I really need help with is the output of my data. Here is my query,
select '*' + b.asset_tag + '*' as Asset_Id
from ae_a_asset_e as b
where status_code = 'active'
and multitenant_id = '1'
Basically how do I format a report in BIRT with two columns outputting the same data attribute and outputting across all of the table cells? (See attached word document)
You could add a computed column to the dataset that counts the rownumber and then add a grid that contains the same table in two columns and then add a filter to filter on the row number. See the attached example that does three columns.
Jason thanks a lot that worked. Just in case I'm asked to change the format of the report. Can the you still do the same thing except take out the numbers?
For example, your example you had
1.Product Code--Quantity--Orderlinenumber 2. Product Code--Quantity--Orderlinenumber
3.Product Code--Quantity--Orderlinenumber 4. Product Code--Quantity--Orderlinenumber
Is there a way to format it without the numbers in front of the attributes?