Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 6
Topic: How to have subreport data show after main report Posted: 23 Sep 2019 at 9:12am
I have a main crystal report (2008) with data in details a with page header:
Page Header: id last first mi date1 date2
details a: id last first mi date1 date2
I added details b to insert the subreport:
details b: <subreport name> ...has similar data/titles; uses param from main report
When I preview my report, I'm seeing one person (row) per page, and I cancel the preview after it gets to 1000 pages.
Before I added the subreport I had maybe 8 pages of data, with the full page filling up with rows, with maybe a total of 50 per page I'm guessing.
I'm trying to figure out how to get the main report data to show on it's 8 pages or so, and then in the following page (or after the end of main data), show the subreport data. Subreport data is only a few rows total.
I'm not really sure how to do groups. I tried adding a group to my main report, and order by id, but couldn't figure out how to get a group2 with the details b data. I'm not sure if that would fix it or not. Right now my report shows
page header
group header 1 (hidden)
group header 2 (not sure how to move it so it has detailsb)
details a <data>
details b <subreport>
group footer 2
group footer 1
I tried googling the issue but can't find a solution or similar problem.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 27 Sep 2019 at 10:03am
putting a sub report on a detail section means that the entire sub report is going to run (and display) the entire sub report for every row of data you have in your data set. so if you had say 10,000 rows of sales your subreport is trying to run 10,000 times.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum