Report duplicates for every record...

[JesseBurton]

Hi All,




I am working on creating a database with reports/etc. I have attached the sample database I am working on.


The issue I'm having is that when the "Ch13Plan" report runs (which is a multi-page report I haven't even finished yet) it creates a copy of the report for every record instead of just a single copy of the report for the client name the form links it to. Eg. If I run the report (which is currently 3 pages long) for "Test1 Client1" it creates 20 copies of the report as there are 20 records for Test1 Client1, if I run it for "Test2 Client2" it creates a report 18 pages long (6 copies of the report) because Test2 Client2 has 6 records... It doesn't do this for the "POCLetter" report though???


I have been searching and looking at forums all day and can't figure anything out. I mean I haven't even added any sub-reports yet, because they have always caused even more problems.


Many many thanks for any assistance.


TestSample.zip

[JesseBurton]

So I've figured out that the report is creating a new detail section for each record in the Record Source, which is why it gets duplicated... So when I remove the record source from the report and attempt to get the fields to pull directly from the query (e.g. [PreConfPlanQuery]![ClientName], etc.) I get a #Name? error on all of those fields.

Is there a way to pull the fields from the query without putting that into the Record Source for the Report so that I don't get the Detail section duplicated for each record?

Thanks so much for any help!!!

[pbaldy]

Why not just remove the claims table from the report's source query? You don't appear to use any of the fields from it.

[JesseBurton]

Thanks sooo much! I took that out and used a sub report to add the claims info in farther down in the report (that part hadn't been added yet)

I think things are working for now! THANKS AGAIN!!!

:-)

[pbaldy]

Happy to help and welcome to the site by the way!