Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Having two or more grids one after another in Sub Report - Crystal Reports

votefavorite

I am having a crystal report with 2 sub-reports one below another. In one of the sub-report, I have 3 data sources, linked via 3 common properties, hence I have created a grouping based on the said properties. My issues is, I need to display 3 grids in total one below another (corresponding to 3 data sources) as in the image (in this example the grouping is based on CustomerID):

Please do let me know how to go about implementing the same as we cannot have nested sub reports.

Thanks, Sid

Tags:
Former Member
replied

Hi Siddharth,

Here's what you need to do :

1) I believe you've already created the 'Customer Details' part and that it displays correctly as in the example above.

Insert a Crosstab and place it on the Report Footer a section.

Use the ItemName field as the Row and the ItemQty field as the 'Summarized field'.

Go to the Crosstab Expert > Format the GridLines and remove the ones you don't need.

2) Insert another Crosstab on Report Footer b.

This time use the 'BackorderItemId' as Row and the BackorderQty field as the Summarized field.

Format the Gridlines as needed.

3) For the section headers, you can insert multiple Report Footers between these crosstabs and place a text object above them.

Hope this helps.

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question