Skip to Content
avatar image
Former Member

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.

Thanks, Sid

Issue.png (6.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 05, 2016 at 05:09 AM

    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.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Thanks Abhilash for all the help.

      I was able to suppress the duplicated records using below formula:

      {Customer.CustomerID} = Previous({Customer.CustomerID}) AND RecordNumber > 1