Diary report Help!

  • Thread starter Thread starter Derek Brown
  • Start date Start date
D

Derek Brown

Hi all

I have a report that prints a diary of events. It makes available blank
space for days with no entries, that have just the days date heading. To do
this I have had to create 31 subreports(one for each month day) that filter
each days diary events and then put them all on one main report. It all
works great and supplies everything that I want except it takes 30 to 60
seconds to process and display.

There must be another way. Can I just emphasise that the problem with
sorting all the events into one report is that I cannot create a blank space
with just the date heading for days that have no records. I need this so
that the client can print a report take it out of the office and hand write
any new diary entries into the blank spaces.

Any genius out there?
 
If you make sure that you have a blank event for each date you have in your
report, (ie, put in the date, with no time or event name), you can then get
away with a report that has one subreport in the detail field, tied to the
event date in the detail field.

Then make your detail field as big as you want it to be (extra blank space)
for the client.

Hope this is clear enough. I experimented, and got it to work. You should
be able to add those blank events with a query, but I didn't try to get
fancy.
 
Hi r. howell Thank you.

If you could give me the vaguest direction of how to make a query produce
blank records I would be very grateful. This realy would solve a months
effort so far!
 
Hi

Your responce has put me on the right track Or at learst a better one.
Thanks to your suggestion I created a table with a query and appended to
that table a list of 31days that are calculated by the start day of any
month + 1 to 31. I now have a table that has all of the appointments plus
one for every day just in case there are no appointments for that day. By
then hiding and filtering out the useless dates I have exacltly what I want.

Cheers!
 
Hi "R. Howell"

Just thought that you may be interested in the ideal solution from Duane
Hookam:
--------------------------------------------------------------------------------
Create a table [tblNums] with a single numeric field [Num]. Then add
records with values 1 - 31. Use this table in your report's record source in
a way that would create all the dates of the month. Then plop one subreport
in the detail section of your report and it will print 31 times.

You can add a text box in the detail section that combines the month and
year with the [Num] field to produce a date value. Use this text box and the
date field from your subreport as the Link Master/Child properties.
 
Back
Top