Having two or more grids one after another in Sub Report - Crystal Reports
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.
Abhilash Kumar replied
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.