I am using Crystal Reports 2013
I have a main report with 5 groups. The data source for the main report is a SQL stored procedure. I have added 1 sub report that uses a different SQL stored procedure. Both stored procedures pass the same parameters to the reports.
I have linked the sub report on all the parameter in the stored procedures. I have placed the sub report in a group footer.
When I run the report I get the first main report with it's matching sub report on a page, just like I am after. Then I get the second page with the main report with the first record repeated with the second sub report results, 3rd page the same main report and the third sub report results. This continues until I run out of sub report results and then I get the second main report with the sub reports starting again.
Can someone point out where I have gone wrong? As you suspect I am a newbie and if this is answered somewhere and I just didn't find it, please just point me in that direction. I really appreciate any help I can get.