Solved

Crystal Reports Sub Report

Posted on 2016-07-29
4
95 Views
Last Modified: 2016-07-30
I am trying to build a report in Crystal that uses a subreport. How do I place the subreport such that it doesn't repeat in the main report? If I place the sub report in the footer of the main report it doesn't repeat, but I need to insert yet another subreport, is there a way I can place them so they don't repeat?
0
Comment
Question by:John Mahoney
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Assisted Solution

by:Eric C
Eric C earned 125 total points
ID: 41735181
When you say 'Main Report' do you mean the 'Details' section?

If you want to place another subreport at the bottom (group footer, page footer, report footer), add another 'Footer' section. You can have multiple detail sections, group sections, headers and footers.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 125 total points
ID: 41735420
You can have more than one subreport in a section.  You just have to make sure they will fit.

mlmcc
0
 
LVL 35

Accepted Solution

by:
James0628 earned 250 total points
ID: 41735698
To add to what they posted ...

 You _can_ have more than one subreport in the same section, but CR doesn't try to keep them separate, so they may overlap (it depends on the size of the subreports, how you place them, etc.).

 You can avoid that by putting each subreport in a separate section.  You can have multiple report footer (group footer, etc.) sections.  Just right-click in the area to the left of the desired section and click "Insert section below".  Once you've created a new section like that, you can use drag and drop to change their order (eg. if you want the new section to be above the old one).

 Also, Eric mentioned the page footer, but, FYI, that's generally a bad place for a subreport.  CR handles the page footer differently from other sections, and it doesn't expand.  If the subreport doesn't fit, CR will just cut it off.

 James
1
 

Author Closing Comment

by:John Mahoney
ID: 41735827
Thank you all.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question