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

Dynamic Report Headings

Trevor Best

I have a report with 2 data sets, the main dataset has a load of dates in it (called Date1, Date2, Date3, etc) and I have another dataset that has some headings (columns named Task1, Task2, Task3, etc).
 
I want to be able to set the headings for Date1, Date2, etc to be the values in the other dataset.
 
I've tried using some javascript but I don't know which event to place the code or how to address the other dataset.

Find more posts tagged with

Comments

micajblock

sample data and version of BIRT will be helpful in building a sample.

Trevor Best

I think the version is iHub 3 F-Type - I only downloaded it 2 days ago.
 
mainDataset would look like:
Package, Date1, Date2, Date3
P001, 01/01/14, 01/02/14. 03/02/14
P002, 01/01/14, 06/01/14. 13/01/14
 
metaDataset:
Task1, Task2, Task3
Issue Req, Issue RFQ, Issue PO
 
The metadata will always only have 1 row in it

micajblock

See attached design. The trick is:
<ol><li>create a global array in the beforeFactory</li>
<li>override the fetch of the meta data set to populate the array</li>
<li>have a table with the meta data but set visibility to hidden (that way the query gets executed but the table is not displayed)</li>
<li>Use the array in the main table.</li>
</ol> 
Hope this helps.

Trevor Best

Thanks, that worked