Re: Week Number in Fujitsu cobol

In article <KaEkg.43471$iF6.33049@pd7tw2no>,
James J. Gavan <jgavandeletethis@xxxxxxx> wrote:
Rick Smith wrote:
<docdwarf@xxxxxxxxx> wrote in message news:e6uccn$iq$1@xxxxxxxxxxxxxxxxxxxx

In article <newscache$ns4y0j$4r5$1@xxxxxxxxxxxxxxxxxxxxxx>,
Euromercante <nospam_eurogest@xxxxxxxxxxxxxxx> wrote:

I only want to make a report, totalizing amounts and values for week Nr.

That's nice... but answering a few questions might help others to help you
with this...

... questions like 'how often will this report be run?' and 'What is the
anticipated transaction volume?' and 'Is it for a single installation or
should it be parameterised so as to be able to run for multiple bases,
that is, is it for a single 'store' or will it be for a series of 'stores'
in a group, a series of groups in a division, etc?'

All of these are factors to be considered in your design.


Additional questions include:

How is a week defined; that is, what is the start day?

How is the first week of a year determined?

To which one could further add, are you using a conventional calendar
year starting at January 01, or perhaps a company fiscal year starting
say on 1st April, and what if 1st January or 1st April falls on a Friday
or a Saturday - what does your first week consist of ?

Hmmmmm... this might be seen as a subset of 'Is it for a single
installation or should it be parameterised so as to be able to run for
multiple bases, that is, is it for a single 'store' or will it be for a
series of 'stores' in a group, a series of groups in a division, etc?'';
if there is more than one installation on which reporting is required then
it might be concluded - especially in These Modern Times of Globalised
Corporations - that different installations run on different calendars...
a calendar used in London (eg, 16 Jun 2006) might not be the same as one
used in Jerusalem (20 Sivan 5766) might not be the same as one used in
Jeddah (Jumada-al-Oola 1427).

But... this may all be a bit of premature pirouetting, dancing before some
simple crawling-rules are established. I'd be interested in seeing how
the questions of run-frequency and data-volume are answered, first.

DD

.

Relevant Pages

  • Re: Week Number in Fujitsu cobol
    ... questions like 'how often will this report be run?' ... is it for a single 'store' or will it be for a series of 'stores' ... To which one could further add, are you using a conventional calendar year starting at January 01, or perhaps a company fiscal year starting say on 1st April, and what if 1st January or 1st April falls on a Friday or a Saturday - what does your first week consist of? ... installation or should it be parameterised so as to be able to run for ...
    (comp.lang.cobol)
  • A good Java installation package can make things much easier
    ... Following the configuration habit of Java, ... the installation deployment of report designer ...
    (microsoft.public.sqlserver.olap)
  • RE: varying expressions in tables
    ... control where i use dlookup with the criteria that > the previous id ... Dim holdPlace As Integer ... change from store to store. ... one report is a detail report ...
    (microsoft.public.access.modulesdaovba)
  • Re: Im amazed...
    ... store in question; he was nowhere around when JJ came into the store, ... Not with the PBG cops or with the PBSO you didn't. ... Public records. ... How's that police report coming? ...
    (comp.sys.mac.system)
  • Re: Jet database engine issue
    ... Here is ome past infomation posted by MVP Allen Browne: ... been traced back to installation of the network printer. ... If there is a problem with the printer, the report will not ... regional setting from your current setting from the drop-down list. ...
    (microsoft.public.access.forms)