I must be missing the obvious...

I have to group on a particular field. But i want to conditionally pagebreak on that field. So if i already have the grouping band, how does

>IIF(oneperpage='Y',yourgroupingfield,'') (along w/ the "start each group on a new page")

keep my grouping but start a new page?

thanks...




>>Using one FRX, how do you conditionally pagebreak on a report grouping based on user input?
>>
>>(start each group on a new page)
>
>1) Create a variable outside of your report (oneperpage)
>2) Create a datagrouping in your report on:
>
>IIF(oneperpage='Y',yourgroupingfield,'')
>
>3) Make sure that that groups "Start each group on a new page" checkbox is checked.
>
>Your oneperpage variable can be any type you want, so change what you check for to match. We use a combo box in an option selection form to allow the user to change the value to "Yes" or "No", hence the check for 'Y' above.