In Crystal Reports, what is the correct way of linking a parament subreport to the main report so the subreport does not run separately for each row of the main report?
The subquery (called paragon on the screenshot) is placed in a Group Header and it's linked to the main report with two parameters:
The main report returns about 300 records and watching it run, I can see that the subreport is run separately for every returned record which takes a fair bit of time.
If I run the SQL, which looks something like, directly say from PowerPivot,
with cte (select membership_info
from server1)
select appointment_info, cte.membership_info
from server 2
it only takes a few seconds to run. Unfortunately, because of REASONS (completely beyond my control) the query has to be run and formatted using Crystal Reports and it's scheduled to be run at regular intervals.
is there a better way of linking the report to the subreport, so the subreport executes only once?