BIP 10G - (Data Set|Group|Section)

Card Puncher Data Processing

About

A document may contain different type of grouping such as:

  • header level information,
  • lines,
  • shipments
  • and contacts.

This group may be:

  • present in the XML document as data source.
  • of created or redesign at run time.

Data Set

A data set is a group of data.

A document can contain:

  • multiple data set (from an XML document of from multiple data source)
  • whereas a database return a document with a single data set. In this last case, we say that the data set is flat.
<INVOICELIST>
	<G_VENDOR_NAME>
		<VENDOR_NAME>Nuts and Bolts Limited</VENDOR_NAME>
		<ADDRESS>1 El Camino Real, Redwood City, CA 94065</ADDRESS>
		<G_INVOICE_NUM>
			<SET_OF_BOOKS_ID>124</SET_OF_BOOKS_ID>
			<GL_DATE>10-NOV-07</GL_DATE>
			<NVL_I_DISCOUNT_AMOUNT_TAKEN_0>0</NVL_I_DISCOUNT_AMOUNT_TAKEN_0>
			<INV_TYPE>Standard</INV_TYPE>
			<INVOICE_NUM>981110</INVOICE_NUM>
			<INVOICE_DATE>10-NOV-07</INVOICE_DATE>
			<INVOICE_CURRENCY_CODE>EUR</INVOICE_CURRENCY_CODE>
			<ENT_AMT>122</ENT_AMT>
			<ACCTD_AMT>122</ACCTD_AMT>
			<VAT_CODE>VAT22%</VAT_CODE>
		</G_INVOICE_NUM>
		<G_INVOICE_NUM>
			<SET_OF_BOOKS_ID>124</SET_OF_BOOKS_ID>
			<GL_DATE>28-MAY-07</GL_DATE>
			<NVL_I_DISCOUNT_AMOUNT_TAKEN_0>.41</NVL_I_DISCOUNT_AMOUNT_TAKEN_0>
			<INV_TYPE>Standard</INV_TYPE>
			<INVOICE_NUM>100000</INVOICE_NUM>
			<INVOICE_DATE>28-MAY-07</INVOICE_DATE>
			<INVOICE_CURRENCY_CODE>FIM</INVOICE_CURRENCY_CODE>
			<ENT_AMT>122</ENT_AMT>
			<ACCTD_AMT>20.33</ACCTD_AMT>
			<VAT_CODE>VAT22%</VAT_CODE>
		</G_INVOICE_NUM>
     </G_VENDOR_NAME>
     <G_VENDOR_NAME>
       .................
     </G_VENDOR_NAME>
</INVOICELIST>

From a database, you can create a data source with multiple data set with the data template functionality to be able to create for instance a multiple master detail report.

Section

A repeating section (as a table) is a design group created with:

  • Word form fields
  • and (for-each) processing instructions.

To create section, the Template Builder can generate the following for-each instructions:

  • for-each For a multiple data set source
  • for-each-group: For a single data set source or to change grouping at runtime

Word form fields properties:

Bip Loop Properties

where:

  • the For-each section allows you to select a data set. If the data set is flat, you will get only one repeatable element. In cases with multiple data sources or hierarchical XML you can choose the data set.
  • the group drop box allow you to create for-each-group instruction.

for-each

For a group element in the XML Hierarchy File

<?for-each:XML group element tag name?>
My Section
<?end for-each?>

for-each-group

The RTF template supports the XSL 2.0 for-each-group standard that allows to regroup XML data into hierarchies that are not present in the original data.

At Runtime

<?for-each-group:ROW;./YEAR?>
   <?sort:YEAR?>
   <?YEAR?>
   <?for-each-group:current-group();./MONTH?>
      <?for-each:current-group()?>
        <?INDUSTRY?>
        <?SALES?>
      <?end for-each?>
   <?end for-each-group?>
<?end for-each-group?>

At runtime, you can see the group in the fo file from the diagnostic log of from the export options of the BI Desktop tool.

If you are creating nested groups (inserting a loop or group inside of another loop in the template), the For Each field is not updateable because it is already defined by the preexisting outer loop. The For Each field will display “Group Item” to inform you that an outer group is already defined.

Selecting a group by element will actually regroup the data into a new hierarchy based on the group by element.

The function, ‘for-each-group’ permit to regroup the data at runtime. The group created then cannot be referred on design time.

Bip Multiple Section From One Data Set

Functionality

Repeating Group

Before selecting the Repeating Group functionality, you have to select the block of text that you want to repeat.

Bip Create Group

Configuration

Bip Desktop Options Build

Documentation / Reference





Discover More
Card Puncher Data Processing
BIP - Formatting

See The RTF standard includes a command that enables you to “keep a paragraph with the next paragraph.” This command prevents a page break between the paragraph for which it is enabled and the...
Card Puncher Data Processing
BIP - XML (Document|Data|File)

BIP - XML (Document|Data|File)
Bip Data Template 10g
BIP 10G - Multiple Master Details Report with data template

BIP can create a master detail report from a flat data source (such as a database) with the standard functionality but when you want to create a multiple master detail report, you have to use the data...



Share this page:
Follow us:
Task Runner