>>I have a report that has a group. Sometimes I will need to print each group on a new page and sometimes not. Is there a way to handle this other than haveing two frx's?
>>
>>Thanks
>>
>>Pat
>
>What is condition, under which you have to print on new page? Basically, you should create a Group by this condition, which you will allways start on the new page. Give us more info, please, to provide a more definite answer.
I think what Nadya is getting at is to put the logic of whether you want a page break into the SELECT. For example:
SELECT p.city, p.zip, p.name, transform(p.zip)+p.city as groupflag, ;
c.calldatetime, c.length ;
FROM person p INNER JOIN call c on c.personid=p.personid ;
ORDER BY 1, 2, 4 ;
INTO CURSOR myReport
Now in the report definition, create a group on GROUPFLAG and a group on CITY inside the GROUPFLAG group. Don't put any fields in the GROUPFLAG group but check off the page break option.
Now when you run the report, the group header for CITY will print every time the CITY changes. And times when the CITY and ZIP change you will get a page break.
- Keith