Multiple Pages Print Based on Sub Rpeort

[tommcmaster]

Hi,
I have a report I have been ammending at work which produces the various costs and expenses on a particular job which we are contracting out. To geing with the user selects a job from a list and this passes the job's unique ID to the report. My boss has asked me to create a sub-report to be included at the base of this main report which, based on the job ID number, displays a list of all internal tasks for that job. I have managed to get the report looking the way I want and it produces all the correct data...the problem is when I try and print it. Suppose we have 3 internal tasks listed for job 0001. That means we have a sub report at the base of the main report with 3 entries displayed. When I print the report I am given 3 copies. If there were 2 internal tasks I'd get 2 copies and so on. I have checked margins and all are well within limits. Also, no blank pages are printed...just an exact same copy of the overall report based on the number of entries in the sub-report. Any ideas?
Thanks
Tom McMaster

 

[fumei]

1. Are you doing this by code? If so, please repost in the VBA forum. And post code.

2. What do you mean by "base of the report"? Do you mean at the endof the report?

3. The ID is selected, and based on the ID, "displays" the internal tasks. Do you mean the information is text in the document? Not quite getting "displays".

4. Those internal tasks related to the ID - are they held in a separate data file?

5.

If there were 2 internal tasks I'd get 2 copies and so on. I have checked margins and all are well within limits.

Please explain why margins.

6. No blank pages are printed. Huh? What blank pages? Are there supposed to be blank pages that you want printed?

Ideas:

The ID number must pick up some sort of count of the tasks per ID. You use that count as a print parameter.

Gerry

 

[mkrausnick]

Or one of the 5 MS Access forums if you're doing this in Access.

Mike Krausnick
Dublin, California

 

[tommcmaster]

1. I'm not doing this by code. It was all done using the tools and wizards in Access.

2."base of the report" - Simply meaning at the end of the report. It's a single page report (supposed to be) and there was white space at the end of the page.

3.The information is text in the document, yes.

4. The internal tasks are held in another table and are accessed using a query.

5. & 6. The reason I checked margins was because if I moved any tables or information outside print margins then I'd start getting blank pages coming off the printer.