Hi,
We have a template report via batch with header (from obj1) and details (from obj 2):
first we want to loop all the records of obj1, and when finished we want to loop all the records or related records of first loop.
E.G.
<SalesOrderDataSet>
{!#LOOP_BEGIN.all#120228}
<SalesOrder diffgr:id="SalesOrder1" msdata:rowOrder="0" diffgr:hasChanges="inserted">
<SalesOrderID>{!ordern_ordernumber}</SalesOrderID>
<CompanyName>Companyname</CompanyName>
<CompanyAddress />
<CompanyPostal>CompanyPostal</CompanyPostal>
<CreateDate>CreateDate</CreateDate>
<LastModifiedDate>LastModifiedDate</LastModifiedDate>
<ShopName>ShopName</ShopName>
<InvoiceNumber>InvoiceNumber</InvoiceNumber>
<ApprovalNumber>ApprovalNumber</ApprovalNumber>
<ReferenceNumber>ReferenceNumber</ReferenceNumber>
<Comments>Some Comments</Comments>
<DateOfInvoice>DateOfInvoice</DateOfInvoice>
</SalesOrder>
{!#LOOP_END.all}
{!#LOOP_BEGIN.R295312#98006}
<SalesOrderLine diffgr:id="SalesOrderLine1" msdata:rowOrder="0" diffgr:hasChanges="inserted">
<SalesOrderLineID>838051</SalesOrderLineID>
<SalesOrderID>{!ordern_ordernumber}</SalesOrderID>
<ArticleName>wisselen wiel aan voertuig</ArticleName>
<Count>4.000</Count>
<SalesPrice>11.0250</SalesPrice>
<SalesAmount>44.1000</SalesAmount>
<SalesDiscount>10.0000</SalesDiscount>
<ArticleNumber>A4005</ArticleNumber>
</SalesOrderLine>
{!#LOOP_END.R295312}
</SalesOrderDataSet>
In my test the first loop works but the second loop is not executed.
Can anybody help me?
Regards Jorrit
Is this a Document Template report? Or is it HTML Template report?
If it is HTML Template report can you try pushing the second loop inside the first one?