Clarification on Subreports 1

[skaestner]

First off I am using CR08 connected to a MySQL db.

My question is simply this, in using sub-reports passing parameters to the sub-report, the Parent(main report) has to execute first before the sub-report correct?

If this is true then the report would stop if the Parent was null or would it continue to the sub-report?

The reason I ask is that the report I am creating has values in the sub-report which is linked to the Parent by using the Change SubReport Links. If I run just the sub-reports by themselves with the same parameter I get the desired results. But if the parameter is null in the Parent then nothing returns. Am I missing something?

 

[lbass]

Subreports behave like tables that are left joined to the main report, so there could be no value in the sub, but a value in the main report, but if there is no value in the linking field for the main report, there can be no result in the sub. In this case, you should consider making the sub your main report and the main report tables should be in the sub instead.

-LB