adding page breaks and 1 different page if condition 1

[Alcar]

given a number of fields, if on of these fields or formulas results in a true condition I need to add a page to the report in the middle of records.

person A (page 1)
field 1 false
field 2 true
field 3 false (this is the field I'm checking)

person B (page 2)
field 1 false
field 2 false
field 3 true

Added page (page 3)
field 4
field 5
field 6

person C (page 4)
field 1 false
field 2 true
field 3 false

and so on...

I am not yet aware of a way to add this page to the report. If you do, I would love some hints.

Thanks in advance.

 

[Naith]

I'm guessing the report is built like:

GrpHdr: PersonA
Detail A: Field1
Detail B: Field2
Detail C: Field3
GrpFtr:

In which case, you could insert a section below GrpFtr, and conditionally suppress it on:

Field3 = False

Also conditionally set New Page Before and After on:

Field3 = True

If you want to have another set of details in the group, you could insert a subreport in the new section.

Naith

 

[Alcar]

I might have my report grouped the wrong way. Here is how it's formed:

Report Header
Page header
Details
person
field 1
field 2
field 3
Report Footer
Page Footer

for every person I need the detail page, for those that have the field 3 triggered, they need an extra page.

I was doing this:

Report Header
Page header
Details a
person
field 1
field 2
field 3
[color: red]Details b
field 4 (these are not DB fields)
field 5 (these are not DB fields)
field 6 (these are not DB fields)
[/color]
Report Footer
Page Footer

I have a formula that checks the field so I added these formulas:

Suppress:
@CheckField3 = false

page new before:
@CheckField3 = true

page new after:
@checkField3 = true

but it still prints out the page...

 

[Naith]

Designate exclusive detail sections to at least your first 3 fields, and put your last 3 fields in Detail D, or Detail D, E, F.

Then use the principle in my previous post.

Naith

 

[Alcar]

works like a charm =) thanks!