Keeping Length of the details section fixed

  • Thread starter Thread starter Shashank Date
  • Start date Start date
S

Shashank Date

I am using Access 2002 on Win XP (Home).

I am creating an Invoice report which has to be printed on preprinted
stationery. The report is grouped using the "Sorting and Grouping" button.
There is a group header, a detail section with multiple detail lines, and a
group footer with PageBreak (so that each group starts a new page).

The group footer has =Sum([AMT_DUE]) value which needs to be printed
at a specific location in AMOUNT DUE box towards the right hand bottom
part of the preprinted stationery. My problem is that the formula keeps
changing it's place depending how many line items I have on the Invoice.
If there is only one item, then it prints way above the AMOUNT DUE box.
And if there are more than ten items it prints on the next page somewhere in
the middle.

Is there a way to control this printing so that the sum is printed on the
last
page (if there are multiple pages) at exactly a specific location?

Any help will be highly appreciated.
Thanks,
-- Shashank
 
You can remove the detail records from your report and place them in a
subreport. Place the subreport in your main report and set its height to the
exact height you need for your preprinted stationary.
 
Duane Hookom said:
You can remove the detail records from your report and place them in a
subreport. Place the subreport in your main report and set its height to the
exact height you need for your preprinted stationary.
Click to expand...

I got a solution to my problem on MSDN (KB119655).
Thanks for the tip anyway.

-- Shashank
 
Back
Top