[Webinar] Streamline your web hosting managementRegister Today


Crystal Reports - Subreport shows up multiple times under details section of main report

Posted on 2008-01-28
Medium Priority
Last Modified: 2010-04-21
Hi Experts,

Can anyone tell me how to supress (or what I am doing wrong) in regards to inserting a subreport?  When I simply insert a subreport without any criteria being used the output looks fine within the main report.  When I use a criteria + the link functionality, a new page appear for each record found on the main report.

Thank for any help you can offer.
Question by:byd2k
  • 2
  • 2

Accepted Solution

mfsamuel earned 200 total points
ID: 20763190
If it is in the detail portion it will appear everytime the detail secion is called.  You can move it to the header/footer, or make sure the detail only returns a single row.
LVL 101

Expert Comment

ID: 20763944
Agree.  What is the purpose of the subreport?


Author Comment

ID: 20771128
Thank you both for your replies.

The subreports are used to tally up certain types of donations.  What I was thinking of doing was to create the main report which prompts the user for a date range.  That date range is then used in every subreport which each suberport has its own criteria (type of donation).  That count is then passed back to the main report.

The only item I'm looking to display on the main report is the count of each sub report.

For example:
Main Report
01/01/07 to 01/31/07
Type of Donation:   Total:
W ='s 5
R =' 3


Is there a better way to do this?  I supposed I could supress all of the details and only print sums, but I've been learning a lot just working on this minor report.  By the way, to create the initial report which gave me the idea to do this...  I ended up simply using the same date range, but changed the criteria and exported the data 9 times.

Thanks again for any help,

Assisted Solution

mfsamuel earned 200 total points
ID: 20771228
Supressing the details and just showing the totals is a much better way to do this.  

Alternatively you can write an SQL query that does a count and only returns the totals.  This would process server side and save time.

Author Closing Comment

ID: 31425745
Thank you all for your help.  


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

612 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