frustrating challenge with ForceNewPage

M

meratz

I have a group of data which I want separated in a report by their
corresponding category which are letters A-F. Here is the tricky part,
I want all the categories to print on the same page except for category
B and F which I want separated on their own pages. I also wanted each
group to have is own header. Sounds simple, but I can't get it to do
this. I tried ForceNewPage in several different ways, but still can't
get it to work. Any assistance would be greatly appreciated.
 
M

Marshall Barton

meratz said:
I have a group of data which I want separated in a report by their
corresponding category which are letters A-F. Here is the tricky part,
I want all the categories to print on the same page except for category
B and F which I want separated on their own pages. I also wanted each
group to have is own header. Sounds simple, but I can't get it to do
this. I tried ForceNewPage in several different ways, but still can't
get it to work.
Click to expand...


You need another level of grouping above the category
grouping. Use a calculated field in the report's record
source query to provide the value for the new grouping.
Maybe something like:

PgGrp: Switch(Category="B",1, Category="F",2, True,0)

That will have a value of 0 for the A,C,D,E categories, 1
for B and 2 for the F category.

Now you can use ForceNewPage for the PgGrp group header.
 
Top