Command Object vs Subreport:
- Report has a parameter (?Club) to select records for particular ClubID, but also needs to have total summary for the company.
- There are two options to get a summary: using command object or using a subreport. Both options return the same results, but what is the difference?
- Crystal Reports XI
- Crystal Reports 10
- Crystal Reports 2008
- Crystal Reports 2011
There are pros and cons in both options:
Command object may calculate the value on the database side and retrieve results only to the client, where the subreport needs to bring all records to the client and calculate the value.
Command object requires linking, otherwise it is not supported. If Command object linked using field with Null values, there could be missing data or wrong results. Subreport does not require links.
Subreport is more flexible solution as it gives all Crystal Reports design options where the Command Object only brings the data.