cancel
Showing results for 
Search instead for 
Did you mean: 

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

leon_laikan
Participant

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

leon_laikan
Participant
0 Kudos

Hi, Ian

Thanks a lot for your reply.

It has helped to clear my doubts.

Best Regards,

Leon

Answers (0)