Designing preprinted form

rbuser

I am working on a project where we need to print a preprinted form and
hit the holes. I had originally designed this in another reporting tool
(not my choice!) but since doing so, this other reporting tool has many
limitations mainly it has bugs taking the bin and paper size properly.
This form will need to print out from both a master and detail tables
and I believe a sub report will be necessary for the detail records.
Because of the nature of this form, I will need to count the number of
records being printed on the current page and if it exceeds the line
count, I will need to do the following:
1) populate the remaining fields below on the form with a "N/A"
2) issue a page break to go to the next page.
3) Populate the fields before the beginning of detail section
with the same information as all other pages.

This is a retail contract form and we have to block out the financial
information below the detail on all pages except for the last page which
will have the calculated figures. What will the best way for me to
accomplish this? I have done many reports in Report Builder over the
years but this is the first that I've had to print on a preprinted form
so I would like some advice.

Thanks in Advance!

David Alge

nardmoseley

1.Populate the fields before the beginning of detail section
with the same information as all other pages.

Use either a Page Header or a Group Header configured to reprint the header
on subsequent pages.

2. Issue a page break to go to the next page.

Might be some options here - I do not fully understand.

To limit the number of detailbands printed on a page, set
DetailBand.PrintCount of the subreport.

or...

To print within a fixed area of the page use a subreport with PrintBehavior
set to pbFixed and TraverseAllData set to True

or...

To limit the vertical position on the page for a subreport, set
SubReport.StopPosition

All of the above will generate a page break.

3. Populate the remaining fields below on the form with a "N/A"

To determine whether a group is breaking, try checking the boolean property
TppGroup.Breaking. (To access a group object use the Report.Groups[] array)

You could build two layouts inside a Region or Subreport. One for the N/A
and for the real data fields. Then toggle the visibility.





--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com