calendar report - is it possible to do at all?

rbuser

Hi guys,

I've been using and enyoing RB since version 4. Now I've got a chalenging
task and I'm not sure if I can implement this using RB.

What is required:
Calendar-type report. Every page will consists of a month calendar with
cells starting from 1 to daysinamonth. Days of a week will go into a header
sections so it always be 7 columns. I will have a DB connected. The
simplified version of table structure as follows:

Task Description
Assigned To
DateDue

So, if I have task with due falling in month interval I need to fill the
cell with TaskDescription+AssignedTo. Situation when more than 1 tasks due
on the same day is possible.

I appreciate any input.

With kind regards,
Dmitry

nicocizik

Hi Dmitry,

ReportBuilder does not have any built-in features to handle a report like
this. My first suggestion would be to take a look at the Calendar option of
TeeChart and be sure it can't be used in your case. If not, you will need
to find a way to define which dates fall in each column detail and perhaps
during the first pass, step through each detail band and change its format
based on some pre-processing that will need to be done with your data.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

thanks for your reply.
TeeChart's TCalendarSeries is not capable of displaying any other
information apart from day.
The worst thing is that day is centered in the cell and there is no way to
allign it.

So, I'm checking your second idea.

Thanks,
Dmitry

rbuser

Hi Nico,

I can confirm it is doable !
How to implement it:
1) set ppReport.Columns = 7, traverse direction from left to right
2) create stored procedure which generates calendar data - master
I needed to create some extra rows for tailing in order it displays dates
starting from monday
3) create detail dataset which links with master by date column
4) create subreport in detail band and link detail dataset with it

Thanks !

Just needed to some mucking around with Calendar dataset (I generate it in
stored procedure) and

nicocizik

Hi Dmitry,

Excellent! Glad you got it working.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com