Calender Report

[Guest]

I'm trying to create a calender report (will look like a
calender) using http://www.invisibleinc.com/divFiles.cfm?
divDivID=4. I've run into a couple of issues. I THOUGHT
I had everything set up the same as the file from
invisible inc but when I preview the report I have
duplicate data running through the report - it seems to be
repeating the same weeks over and over again. The second
issue I have is that I need to break the dates on seperate
pages for each month. I will also have dates running into
the next year so I cannot just break on month alone (i.e.
the week of Jan 1 this year included M-Wed in 2003 and T-
Fri were 2004. Has anyone run into this before? Thanks.

 

[Duane Hookom]

Hi anonymous,
I created the original report so have a little knowledge of it. If you have
repeating weeks, check the record source of your main report. It should
contain a single record for each week. I expect your query returns several
records per week.

After you fix this, reply back in this thread if you have additional
questions.

 

[Guest]

Hi, I straightened out the duplicate data - thanks for
that one. I still have issues though - the weeks are not
in order by date (week of 6/21 comes before week of 5/21
even though it's the same year). The other part of the
issue is that I need a page break by month and if it's at
the beginning or end of the year and the week is running
in two seperate years (i.e. the first half of the week of
1/1 was dec. 2003 and the other half was jan 2004) I
would also need to break by year. Thanks in advance for
any advice.

 

[Duane Hookom]

Your weekof calculation must be a valid date and the report must use this
WeekOf field in the sorting and grouping dialog. I you also want to separate
out by month, add a month field to the query the report is based on. Group
on this month and then the WeekOf field and set the report to break after
the month group.