[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Ordinary Positioning vs Array Positioning




Hello all...

Is the following sample report possible in SQR by simply using clever 
positioning techniques? If so, cool. If not, are arrays the best the way to go? 
If so, where do I start? Do I create a separate array for each season? Each 
team? Each set of stats? Or a funky combination?

NOTE: All amounts are calculated in their own separate procedures then passed 
into each corresponding varaible.

Have all the queries/totals ready to go, but this interesting horizontal format 
rather than vertical is what has me a bit puzzled. Add to that the layout of 
the second set of data to be placed directly underneath the first set has me 
even more puzzled.

In the meantime, I'm gonna attempt to figure this out using some
positioning methods.

Any help would be greatly appreciated.

< *** YOU MAY WANT TO PRINT THIS EMAIL OUT IN LANDSCAPE MODE TO UNDERSTAND 
LAYOUT FULLY *** >

  
*****************************************************

               2003 Season                2002 Season                2001 Season
NBA Team       Assists    Opp Assists     Assists    Opp Assists     Assists   
Opp Assists    Total Assists    Total Opp Assists
&Team           #03ass      #03oppass      #02ass      #02oppass      #01ass    
 #01oppass         #ass_tot          #oppass_tot  

Grand Total #03ass_tot  #03oppass_tot  #02ass_tot  #02oppass_tot  #01ass_tot 
#01oppass_tot      #ass_tot_gr       #oppass_tot_gr

! --- 4 blank lines

  2003 Season                2002 Season                2001 Season
NBA Team Steals     Opp Steals      Steals     Opp Steals      Steals    Opp 
Steals     Total Steals     Total Opp Steals
&Team           #03ste      #03oppste      #02ste      #02oppste      #01ste    
 #01oppste         #ste_tot          #oppste_tot  

Grand Total #03ste_tot  #03oppste_tot  #02ste_tot  #02oppste_tot  #01ste_tot 
#01oppste_tot      #ste_tot_gr       #oppste_tot_gr


*****************************************************

Thanks,
Darrel


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

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