Skip to Content
0
Former Member
Jun 03, 2009 at 09:27 AM

One query two different Group By

39 Views

In My parameter two option one and two.

if i select one, need to come this group by:-

GROUP BY

Name1,

Name2,

Country,

MCC || '/' | MNC

One Output:

Name1 - Name2 - Country - PNR

if i select two, need to come this group by

GROUP BY

Name1,

Country,

MCC || '/' | MNC

two output :

Name1 - Country - PNR

I have only one sql query But i have two different group by

Please advise me, m not using subreport option.

whether any formulas or any other options for group by.