Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: How to have subreport data show after main report Post Reply Post New Topic
Author Message
Michele
Newbie
Newbie
Avatar

Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 6
Quote Michele Replybullet 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.
Accept that which is good
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9011
Quote DBlank Replybullet 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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1504
Quote kevlray Replybullet Posted: 30 Sep 2019 at 7:11am
If you want to have the sub-report show after the main report data, then I believe you should have the sub-report in the report footer section.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.078 seconds.