Skip to Content

A 200-record report with a subreport in the details section?

Hi, everybody

I use SAP Crystal Reports 2010 (stand alone version) to develop my reports which I then preview in SAP B1 (Preview External Crystal Reports File).

I am considering designing a report which may generate hundreds of rows (records).

Each row will give summary information about a particular Stock Item code.

To avoid cluttering the report, I'll place an on-demand subreport in the details section, so there will be hundreds of subreports.

When a subreport link is clicked at runtime, a subreport will pop up, giving more details for the selected item code)

My Question:

  • Is this idea feasible? Will the large number of subreports affect performance? I think this will not affect performance as the subreports are on-demand, and will only be processed if a link is selected. But I am not sure.
  • Is it possible to pass the item code parameter from Main Report to subreport?
  • If my idea is not feasible, are there alternatives to achieve the same aim?

Thanks

Leon

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 05, 2017 at 08:05 AM

    Everything you want to do is possible and as you say SubReports will not affect performance as they are on demand.

    When you link subreport you can link from a field in main report to a field or parameter in subreport. If you use field to field Crystal creates a dummy parameter which is used as a filter in SR select expert.

    Ian

    Add comment
    10|10000 characters needed characters exceeded