0

Is it possible to use single dataset for multiple tables in a single reportdesign document. Whereas data has repeating transactions for particular table. If yes, then please let me know how to define xPath in dataset.

Sample Data xml:

How to map this books array to table1 and videos array to table2 in single reportdesign?

Gaurav Mittal
  • 1
  • Sample data xml : 1 2 3 – Gaurav Mittal Jul 08 '21 at 11:17
  • I rarely use XML datasete (only SQL), so I cannot help you with XPath for the exacty syntax, but I can tell you that this is of course possible. – hvb Jul 09 '21 at 07:11
  • I have tried to make the xpath as: library/*/* but through this only one table data fetches properly rest of the data comes as null or repeated . – Gaurav Mittal Jul 09 '21 at 09:03
  • You need to parametrize your dataset and supply a different value for the parameter in the dataset parameter binding for the two tables. – hvb Jul 10 '21 at 11:41
  • Can you please elaborate because as per my understanding it will create two datasets. – Gaurav Mittal Jul 11 '21 at 17:11

1 Answers1

0

There is a known limitation in Birt. Birt will only allow one table in the same report for each data set. any additional tables must be linked to different data sets. Never to the one and same data set.

frederick A evans
  • 1
  • 1