Page Break based on detail's qty

[hungtran817]

Hi,
I'm trying to insert a page break after each individual qty.
For example, if my query pulls Item A with (5) qty and Item B with (2) qty. Even though, my query returns (2) records, I want to insert a page break after all (7) items. Any suggestion would be appreciated. Using CR 9.0.

Thanks,
Hung

 

[Madawc]

If you right-click on a section and choose Format Section you get various choices, including 'new page after'. Is that what you're after?

Crystal likes to control page breaks itself, so it's not easy to force it after a given number of lines on a page. It can be done, if this is what you want, using variables and re-setting in the page header.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[hungtran817]

Hi Madawc,
Thanks for the quick response.

It's the variable formula that I'm having trouble with. At the moment, I'm trying a formula to concatenate the item number with each incrument number so I could get (7) different records. After that I hope I could just use the 'new page after'. Think that would work?

Hung

 

[lbass]

faq767-3227 might be helpful.

-LB