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

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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Agree.  What is the purpose of the subreport?

byd2kAuthor Commented:
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,
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.
byd2kAuthor Commented:
Thank you all for your help.  

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.