Hi Chaim,

It seems to me that you're making things very complicated for yourself. Why don't you simply use two reports? Yes, you can do what you want with a single report but the effort hardly seems worth it.

For what it's worth, if you select your data into generically named fields, eg < Field1, Field2, Field3 & Count > you can then use these fields in the report and group by the first two fields in the report.

You're going to have to use a different SQL statement depending on which report you want to generate. If you're branching at this point anyway, why bother trying to shoe-horn different reports into a single FRX?

Regards,

Liam



>Perheps I didn't explain well:
>Here is example of my data (fields YEAR,PRIORITY,QUATER,COUNT Delimited):
>*************************************************************************
>2001,"Emergency","(1) - Firast quater",1797
>2001,"Regular","(1) - Firast quater",5136
>2001,"Slow","(1) - Firast quater",19393
>2001,"Emergency","(2) - Second quater",2119
>2001,"Regular","(2) - Second quater",4625
>2001,"Slow","(2) - Second quater",14935
>2001,"Emergency","(3) - Third quater",832
>2001,"Regular","(3) - Third quater",5798
>2001,"Slow","(3) - Third quater",294
>2001,"Emergency","(4) - Fourth quater",882
>2001,"Regular","(4) - Fourth quater",6672
>2001,"Slow","(4) - Fourth quater",16161
>2002,"Emergency","(1) - Firast quater",448
>2002,"Regular","(1) - Firast quater",2981
>2002,"Slow","(1) - Firast quater",4868
>*************************************************************************
>I have the data in cursor and I want to print it.
>Sometimes it's will be looks so:
>Field names:
>Priority****year****quater****count
>fields:
>Priority
>***********Year
>********************First quater 12156
>********************Second quater 12316
>
>and sometims it's will be looks so:
>Sometimes it's will be looks so:
>Field names:
>Year****quater****priority*****count
>fields:
>Year
>********first quater
>******************Emergency******65312
>*******************Slow**********93164
>I hope that it's enough clear!
>Chaim