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

How to display repeating tag xml in BIRT

clubmed95 · 2015-08-20T09:17:31+00:00

Hi All, I have an XML datasource, and a tag in this XML which can repeat several times. For example, the tag Client is repeated below : TIGER SCOTT …

clubmed95

Hi All,
 
I have an XML datasource, and a tag in this XML which can repeat several times.
 
For example, the tag Client is repeated below :
 
<Clients>
 <Client> 
 <lastname>TIGER</lastname> 
 <firstname>SCOTT</firstname> 
</Client> 
<Client>
 <lastname>LION</lastname> 
 <firstname>BOB</firstname> 
</Client> 
... 
</Clients> 

How can I display this tag in BIRT in order to retrieve the 2 clients ?
 
Thank you by advance
 
ML

Find more posts tagged with

Comments

pricher

Hi,
 
In Row Mapping of the XML Data Set Editor, choose the Client tag in the XML Structure and click the arrow to bring it to the XML Element Selection:

clubmed95

Hi Pierre,
 
Many thanks for your quick answer, I will test it.
 
I have another question for you concerning Page Break management with XML Datasource.
 
How can we apply a Page Break with repeating tag ?
 
For exemple, in the XML example above, I need to apply :
 
- a first masterpage for the first client with a break page.
- a second masterpage for the second client with a break page.
 
Is it possible to do that ?
 
Thank You
 
ML

pricher

Hi,
 
Page break management doesn't come with the XML data source or the XML data set you create. It comes with the table you create.
 
Having said that, I am not totally clear on what you are trying to accomplish. Are you more concerned about page breaks or masterpages? You give a scenario for two users, but I presume you're going to have more than that, right? I think to answer you more correctly, we would need some sort of a mock up of the report you are trying to build.
 
Regards,
 
P.

clubmed95

Hi,
 
I have indeed more than 2 clients to display.
 
I have a master page to apply to the first page, and another masterpage for the other pages.
 
On my first page, I have a table with all my clients but if have a lot of clients, the display of them could be on 2 or 3 pages.
 
How can I do to display the masterpages ?
 
Thanks by advance.
 
ML

pricher

You cannot change the master page while the table is processing. However, you can use row count filtering to add two tables that are the same and put them on different master pages. For example table1, linked to First Master Page, could list the first 20 customers and table2, linked to Second Master Page, could list the rest.
 
Attached is an example based on Classic Models; it will work the same way with an XML data source. The steps are
 
1. Initialize variable rowCnt in the beforeFactory method of the report;
2. Add a computed column called rowNum to the dataset. The column will store the incremented value of rowCnt;
3. Add a 2-row grid and bind the grid to the data set
4. In the first row of the grid, add your table. Do not bind the table to the data set: it will takes its data from the grid. Add a filter to the table to limit the output to the number of rows you want on the first page. Here, I have put 20. In the Page Break property of the table, make the Page Break interval 20 and select First Master Page as the master page.
5. Copy and paste the table into row 2 of the grid. Modify the filter condition to show the remaining rows. In the Page Break property, select Second Master Page as the master page.
 
This should do it!
 
P.

clubmed95

Hi Pierre,
 
many thanks for your answer.
 
It is very kind.
 
Regards,
 
ML