RE: Reports works on one way but not the other
From: martin (anonmous_at_nospam.com)
Date: 11/10/04
- Next message: seadog14: "Grouped Line Graphs just don't seem to work"
- Previous message: Jean: "Date format wrong"
- In reply to: Jack: "Reports works on one way but not the other"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Nov 2004 13:35:08 -0800
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
"Jack" wrote:
> 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
- Next message: seadog14: "Grouped Line Graphs just don't seem to work"
- Previous message: Jean: "Date format wrong"
- In reply to: Jack: "Reports works on one way but not the other"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
