Calendar reports

[CrArC]

I would like to create a calendar report but I am having some issues; I cannot change the captions of the labels within the subreports (I have subreports representing each day in a month) as visual basic says "object does not support this property or method".

Basically I planned to manually enter data into the report by reading it from the tables under visual basic and using VB to change the contents of the subreports myself. The function of the report is to show a calendar view of a month showing how much pay has been earned on each day.

I think I can do it if I could just figure out how to iteratively modify the contents of all the subreports.

The idea in pseudocode:

For x = 1st to 31st
rpt = Reports!rptNurseFees.Controls("SR" & CStr(x)).Report
frm.label1.Caption = x  'Day number
Next

Next

Any ideas??

 

[CrArC]

I seem to have found a way around this problem by creating a host of queries, one for each subreport. The reports are linked by a child and master field to the relevant record in the parent report (so they only display the data for that record as there are multiple records for the same days in the table) and 'pointers' are used, representing the day that each of the queries must select data for. As long as I tag each record in the table they read from with the correct pointer (will be done in VB) the subreports will display the relevant record for that day! This alternative is cumbersome but I suppose effective compared to fiddling with VB to populate the report manually.