Subreport Causes Multiple copies of report to print how can I stop!

[Guest_imported]

I have a Form Letter report designed that is an "Inspection Form". Our Fire Inspectors want to print this and take to businesses to do the inspection. There is a subreport which contains all of the contact people name and numbers. The report looks great and is working wonderfully except for one problem. The subreport causes multiple copies of the original to print out. How can I limit the print to show only one copy of the report and subreport? Help!!!! This is kicking me in the rear end....

 

[SmpTraining]

I've never heard of a subreport causing muliple copies of the main report to run. Try saving the report under a new name and removing the sub-report. Does it then run OK?

Steve Phillips, Crystal Consultant

 

[Guest_imported]

Okay I will try to be more clear, and have discovered something odd. The "form Letter" report without the subreport is designed to pull information from an "Inspections" database with all pertinent business information in the top and a generic letter at the bottom, the center was where I stored the subreport. I followed your advice and removed the subreport and I still get multiple copies of the original report even though I know for a fact there is only one record in the database. So apparently I was wrong in saying it was the subreport causing the multiple copies. How do I limit the report to showing/printing only one copy? Eeeekkkk

 

[SmpTraining]

You are expecting to have one record per Inspection but there is obviously something in the tables that results in more than one recordset for each "Inspections" entry.

To find out what's causing this, ask yourself what other tables are you using. One of them has multiple entries per Inspection record.

If you find you do not need these tables, remove them and the problem should be fixed. If you want further help analysing this, start by listing all the tables you use in the report and how they link (also whether they are ODBC, SQL, Access etc).

If you DO need them, create a group based on the Insections table and move all your Inspections business information into the group header (and/or footer) sections. Then suppress the details section.

Adding a group will ensure you have an area that gets displayed only once per inspection. Steve Phillips, Crystal Consultant

 

[Guest_imported]

Thanks Steve! Your second solution of grouping and moving the entire report to the group header was exactly what I needed, silly I never even thought of it! Whoooo Hoo a usable Crystal Report is on the way to Compiling/Distributing today, the day before a holiday (on a day when I am notorious for not getting a thing done) Thanks so much!