Summary pages on Reports Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jai_Friday - 12 Mar 2008 10:12 GMT

Good morning,

I have a question to pose which I hope someone could assist me with,

I currently have a report running that Groups records together by the week
of a year (A week function that works out the week of a year by from a date)

All works fine , however I wish to create a first page summary that just
shows totals for the week

e.g

Week 11 = 200
Week 12 = 340
Week 13 = 300

but because the report could vary in a range of weeks each time it is run
there is no fixed point to sum by , the only consistancy is there will always
be 3 weeks in the report

I could use if week equal xx then sum number if the weeks were always fixed,

Could I use a min to max function to use to bind the summary down?

Reply to this Message

Evi - 12 Mar 2008 10:44 GMT

Use a subreport. You can either base this on a Totals Query or make it a
copy of your main report and delete Details section, whichever gives the
effect you desire.
In Design View, slide it from the Database Window into your Week Number
Header and link it to the Main Report by WeekNumber by opening the
Properties box, clicking on your Subreport and putting the name of your
WeekNumber field next to Link Master Fields, Link Child Fields.
Is this the effect you want?
Evi

> Good morning,
>
[quoted text clipped - 19 lines]
>
> Could I use a min to max function to use to bind the summary down?

Reply to this Message

Jai_Friday - 12 Mar 2008 11:14 GMT

Cheers EVI ,

God I feel dumb ;)

> Use a subreport. You can either base this on a Totals Query or make it a
> copy of your main report and delete Details section, whichever gives the
[quoted text clipped - 31 lines]
> >
> > Could I use a min to max function to use to bind the summary down?

Reply to this Message

Evi - 12 Mar 2008 11:35 GMT

Please don't. I can think of all the times I've spent days (even weeks)
working on elaborate solutions to a problem when there was a really simple
one available. And besides, there will be other readers of the newsgroup who
really don't know how to set up a subreport (or even that subreports exist)
and who will want to do just what you wanted to do.

Some years ago, I spent ages hunting for the way to make those lines to
appear when you print out an Excel Spreadsheet. Imagine looking up 'lines in
Spreadsheet' on Google! Someone in a newsgroup kindly told me they were
called grid lines and how to switch them on! (Oh dear! I'm starting to sound
like Grandpa Simpson!)
Evi

> Cheers EVI ,
>
[quoted text clipped - 35 lines]
> > >
> > > Could I use a min to max function to use to bind the summary down?

Reply to this Message