[sqr-users] On-breaks Problem - I think

["Miller, Danika" <MillerD2@ndu.edu>]

My run control page asks if the report should be run by either A, B, C, D,
or E.  A&B share the same select statement (diff. where clause), and C, D, &
E share the same select statement (diff. where clause).

 

And there's a radio button asking how the report should be grouped: either
by country or start date.

 

There are many possible variances in running this report:  

                        A - Group by country

                        A - Group by start date

                        B - Group by country

                        B - Group by start date

                        C, D, E - etc.

 

Would I have to have a different select statement for each and every
possible combination? 

For example, 

if A and country             do select 1  with an on-break on country

if A and start date          do select 2  with an on-break on start date

if B and country             do select 3  with an on-break on country

if B and start date          do select 4  with an on-break on start date

 

 

Any ideas??????????

 

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users