Table of quantities by week-ending date should include weeks with zero
Table of quantities by week-ending date should include weeks with zero
(OP)
I am printing a report of quantities by week-ending date, using the ACROSS function. This is the code that prints the report:
This correctly prints the quantities for each week that has non-zero quantities. I am trying to get the report to print all weeks, even weeks with zero quantities.
Is there a way to put "dummy" records into the file with all week-ending dates within a selected range, so that all weeks will print?
Thanks!
CODE
BY STYLE_DESC AS ' '
ACROSS weekseqn NOPRINT
ACROSS Saturday AS ' '
ON TABLE SUMMARIZE AS ' '
ACROSS weekseqn NOPRINT
ACROSS Saturday AS ' '
ON TABLE SUMMARIZE AS ' '
This correctly prints the quantities for each week that has non-zero quantities. I am trying to get the report to print all weeks, even weeks with zero quantities.
Is there a way to put "dummy" records into the file with all week-ending dates within a selected range, so that all weeks will print?
Thanks!
RE: Table of quantities by week-ending date should include weeks with zero
Note: you may have to be registered to access this info.
RE: Table of quantities by week-ending date should include weeks with zero
IB is offering a webinar on this topic on 16 DEC 2010 presented by the renowned Noreen Redden. Check out the Virual User Forum on IB's Web site.