[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