Populating a Report

[prao]

I have report which is not connected to any table or query. The data's must be populated dynamically from a table. For example, on the load or open event a script will be executed to populate the report fields. Is it possible, I try but I get an error. If not, how to populate the report fields with data using a VB procedure.

Thanks

 

[Chris RR]

One question: Why?

Typically, this is done by using a parameter query as the report source, or by using a filter. Is there a good reason that these methods won't work? Both methods dynamically create the report input.

 

[prao]

I am trying to build a Accounting Calendar for my company. This calendar will look something like this :

Jan - 4 Weeks, Feb - 4 Weeks, Mar - 5 Weeks
Apr - 4 Weeks, May - 4 Weeks, Jun - 5 Weeks and so on.

I have the above data in row form.

Ex: Columns in the table are Year, qtr, week,month, date and holiday
The data is stored in row form like this
------------------------------------
Year Qtr Week Month Date Holiday
------------------------------------
2001,1,1,1,1/1/2001,Yes
2001,1,1,1,1/2/2001,No
2001,1,1,1,1/3/2001,No
2001,1,1,1,1/4/2001,No
2001,1,1,1,1/5/2001,No
2001,1,1,1,1/6/2001,No
2001,1,1,1,1/7/2001,No and so on.

I need a report in column form like this

Month Qtr First Week Second Week
----- --- ------------- ------------------
Jan * 1 * 1 2 3 4 5 6 7 * 8 9 10 11 12 13 14 *

The * represent the field break (not used in the report).

For this I need to write a VB procedure to populate the report with data from the table.

This is my requirement. I think the question is clear.

Thanks for response.




[This message has been edited by prao (edited 04-27-2001).]