I have reports which all rely on one query. The query looks something like this:
Now, I have four separate reports. ReportA is filtered to bring back all lines that VolumeA <> 0. ReportB is filtered to bring back all lines that VolumeB <> 0. ReportC and ReportD are the same way.
However, the filter just does not seem to work for ReportC as it brings back every single line. When I check the properties... ReportC's filter is gone! So I type it back in, and the report works fine. I save it and reopen it in design view to make sure the filter is still there (which it is).
However, when I try to rerun ReportC... Once again the filter disappears and I have to retype it back in.
What is going on?
Code:
ID VolumeA VolumeB VolumeC VolumeDNow, I have four separate reports. ReportA is filtered to bring back all lines that VolumeA <> 0. ReportB is filtered to bring back all lines that VolumeB <> 0. ReportC and ReportD are the same way.
However, the filter just does not seem to work for ReportC as it brings back every single line. When I check the properties... ReportC's filter is gone! So I type it back in, and the report works fine. I save it and reopen it in design view to make sure the filter is still there (which it is).
However, when I try to rerun ReportC... Once again the filter disappears and I have to retype it back in.
What is going on?
