Solved

Crystal Reports Sub Report

Posted on 2016-07-29
4
85 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
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 34

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 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