Force New Page

[Haji]

Hi,

I have a report based on a query that has five fields.
They are CustomerName, TreatmentName, ProductName,
Quantity and Cost. The query has several different
companies. Each company may have several different
treatments. I want to create a report that forces a new
page after each treatment name.

I have placed both the CustomerName and the ProductName
in the report header section. ProductName, Quantity and
Cost all appear in the details section of the report.
The ProductName is also in the details section as an
invisible field. I want the report to list the Company
Name and the Treatment Name at the top where the report
header is, then the products with quantities and cost in
the detail section, then I want to force a new page when
the next treatment name appears.

Can anyone help?

Thanks,

Haji

 

[Guest]

Hi,

There is a force new page properties for any grouping, if you make a
grouping based on treatment, in that section of the report you can set the
force newpage property to "after section" that way anytime the grouping is
completed it will put a new page afterwards,


Hope this helps.

 

[Haji]

Tamiyra,

Thanks for your help. I did group this based on
Treatment Name. There is a Treatment Name Header in my
report. This is followed by a Details section that lists
the ProductName, Quantity and Cost. I selected Force New
Page from the TreatmentName Header. What this did
though, is create the first page which only has the
treatment name, followed by four different pages that
each list the four products in my report. Only one
product name appears per report. I must be doing
something wrong with my grouping. I want the treatment
name to appear followed by the four products then a new
page for a different treatment. Can you think of what I
am doing wrong?

Thanks,

Haji

 

[Guest]

By what I can gather,
your report

will have at the top of a page a treatment name
then list multiple prodname quantity and costs in the detail section?
If you want the page break after the detail is done printing then you would
wanna display the treatment name footer and force the new page after the
footer because then it will print the detail section before it forces the new
page. Even if you have nothing in the footer you can still include it and
make it force a new page after the section.

Sorry It hard for me to understand without seeing but I hope this helps.

 

[Haji]

Tamiyra,

I think I got it thanks for your help. One thing that
would be nice would be to have the report header appear
at the top of each page of my report. It isn't critical
but it would be nice.

Thanks,

Haji

 

[Guest]

To have the header on every page, go to the properties of the header that
you wanna see on every page, and there is a property called repeat section,
this should do what you want if you set the value to yes.