Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calandar in grid form

Status
Not open for further replies.

ecsrs

Technical User
Apr 22, 2002
35
US
I would like to produce a calandar spreadsheet. In the left column I need to place reords from a table in our database and the rows across the top are the days of the week of a particular month. The actual cells produced are left blank, it is used as an attendance sheet check-off list. I am currently doing this in excel, but I would save myself some time if I could do this in CR. Does anyone have any suggestions?
 
Base your report on your data table with the field you want in the left column. Leave space for 5 or 7 blank columns. You can use vertical lines as dividers. You can head your columns with text blocks ("Sunday", Monday", ...) or if you want MM/dd/yy dates, use a parameter to specify the beginning date and formulas to calculate the remaining dates as StartDate + 1, etc.
 
Thanks, it sounds easy enough...I'll try it this afternoon!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top