Reports works on one way but not the other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I got a report which runs from a form interface. The report is chosen from a
combo box among various reports. The report can be run individually from the
same screen if a case number is checked and the number is plugged in. The
other way to run the report is to run for all the cases for the whole year
say 04.
The report is tied to a query joined to six tables.

Now, when I run the report by case number it runs perfect giving all the
detailed content. However, when I am running the report for the whole set for
a year, the report gives errors in the details e.g. some items are duplicate,
some items are missing etc.
My question is why is this strange thing happening and how to troubleshoot
this situation for resolution. Thanks for any help/advise in
 
Are u running the same query for both reports? my simple suggestion is make a
copy of your top(the record source for the report) query run it side by side
for whole year and case number see that the resulting data has the same field
(column) names. Then check these field names with what is used your report.

HTH
Martin
 
Back
Top