>I CREATE A REPORT WITH A PARTICULAR GROUP, MY USER WANTS SAME REPORT BUT EVERY EACH GROUP SHOULD BE ON A NEW PAGE. SO I HAVE TO CREATE A NEW REPORT WITH A USER WHICH WAS NOT POSSIBLE. I CAN DO BUT IT IS HARDCODED. I HAVE TO GO IN REPORTS AND GROUP AND HAVE TO CLICK START NEW PAGE CHECK BOX WHICH I DONT WANT BECAUSE I HAVE TO CREATE A NEW REPORT FOR THAT WHICH IS EXHAUSTING ME BECUASE THERE ARE MANY REPORTS WHICH I HAVE CREATED TWICE SO PLEASE HELP ME.
>
>THANK U

Let me understand if I understood correctly: you want two versions of the report: one with, one without grouping.

I think you can group on a field which, in one version of the report, has different values; in another version, you fill out the field always with the same value.

private plSeparatePages
plSeparatePages = ThisForm.ChkSeparatePages.Value
...
select ... into cursor TmpResult
if plSeparatePages
  select TmpResult.*, MyTable.GroupingField;
    from TmpResult join ...;
    into cursor TmpResult
else
  select TmpResult.*, 0 as GroupingField;
    from TmpResult;
    into cursor TmpResult
select

Regards, Hilmar.