J
justinschmidt
I am having an unusual problem that I cannot figure out. I have a
report which can either be run for 1 project, or for all projects. When
it is run for all projects, each project will print out on a unique
page (the output would look exactly the same as if I ran the 1 project
report over and over for every job).
This report contains a number of subreports, which run off queries. The
gist of the report is
-The main body of the report contains this week's production.
-3 subreports will query the database, and display the previous 3
week's production
-Production is shown for about 35 different items per week
Now, when I run the 1 project report, everything runs fine, and all the
fields propegate as they should. See a screen shot here
http://img290.imageshack.us/img290/8606/reportproblems2wj1.jpg
This report works by running a query on my 'Report Printer' form that
sets the criteria for the project to be whichever project is selected
on the form.
When I run the All Projects report, for some reason all of the
subreport's data does not show up. See the screen shot here
http://img102.imageshack.us/img102/9837/reportproblems1bb1.jpg
Many of the fields show up as zero's, instead of showing up showing the
correct production as is shown in the 1 project report. This report
works by eliminating the project selection box from the 'Report
Printer' screen, thereby giving a null value for the project criteria,
and thus reporting all records for all projects.
The thing that is puzzling me is that some data does show up. It's not
like the whole subreport blows up, because as you can see from the
screen shots, the first 4 lines of data actually report correctly. When
I look at the query after I run the report, all of the necessary data
is linking correctly. Somehow, it just doesn't make it to the report
though.
My only theory is that the report is running too fast for the
subreports, so before all the data can propegate in the subreports, the
main report has already moved on to the next project and so it just
zero's out everything it didn't get to. Make sense?
Anyone have any clues as to what is happening?
report which can either be run for 1 project, or for all projects. When
it is run for all projects, each project will print out on a unique
page (the output would look exactly the same as if I ran the 1 project
report over and over for every job).
This report contains a number of subreports, which run off queries. The
gist of the report is
-The main body of the report contains this week's production.
-3 subreports will query the database, and display the previous 3
week's production
-Production is shown for about 35 different items per week
Now, when I run the 1 project report, everything runs fine, and all the
fields propegate as they should. See a screen shot here
http://img290.imageshack.us/img290/8606/reportproblems2wj1.jpg
This report works by running a query on my 'Report Printer' form that
sets the criteria for the project to be whichever project is selected
on the form.
When I run the All Projects report, for some reason all of the
subreport's data does not show up. See the screen shot here
http://img102.imageshack.us/img102/9837/reportproblems1bb1.jpg
Many of the fields show up as zero's, instead of showing up showing the
correct production as is shown in the 1 project report. This report
works by eliminating the project selection box from the 'Report
Printer' screen, thereby giving a null value for the project criteria,
and thus reporting all records for all projects.
The thing that is puzzling me is that some data does show up. It's not
like the whole subreport blows up, because as you can see from the
screen shots, the first 4 lines of data actually report correctly. When
I look at the query after I run the report, all of the necessary data
is linking correctly. Somehow, it just doesn't make it to the report
though.
My only theory is that the report is running too fast for the
subreports, so before all the data can propegate in the subreports, the
main report has already moved on to the next project and so it just
zero's out everything it didn't get to. Make sense?
Anyone have any clues as to what is happening?