BI Publisher - Ability to group on two different data sets

Msmith

Summary

BI Publisher - Ability to group on two different data sets

Content

I am currently working on making a customer Invoice. The goal is to have one invoice per document number, and each invoice contains multilple line numbers. Also we would like the invoice to be able to work with multple document numbers at once. So for example we would like to be able to run 4 invoices, each with 4 different document numbers each with multiple line numbers. I have done something like this in the past, however this issue this time is that the document number and the line number are in different data sets. When I go to group the document numbers to show one document number per page, it only shows the first line number. Similiarly when I go to group the line numbers, it shows multiple line numbers but online the first document number.

Here is the document number group:

here is the line number group:

With this current configuration, only one line number is showing per multiple document numbers.

Venkat Thota - BIP

can you try this link

https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources

can you upload xml and rtf document?

Brajesh Shukla-95078

Can you try for-each@section for Invoice then for each for invoice line, so your template design sample will be

<?for-each@section:DocumentGroup?>

        

      <for-each: linegroup>    your line table  <?end for-each?>

<?end for-each?>