Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating Calendar in Crystal Reports

Creating Calendar in Crystal Reports

Creating Calendar in Crystal Reports

I am trying to create a calendar in Crystal reports 8.5.  i am looking to show a meeting name under the date in falls upon.  i have drawn a calendar grid using the line control.  the calendar1sthalf function does not provide what i need.  anyone have any ideas?

RE: Creating Calendar in Crystal Reports

There is no easy way, but there are several techniques you can use depending on what you need to do:

Will your calendar show an entire month or just a week?
How many records will be reported on one calendar?
What do you want to print for each day?

You can use a cross-tab to do a rough calendar if you use the row as weekly, and the column as the formula: DayOfWeek({datefield})

This requires that there be at least one record for every week to generate the row.

Or you could hard code 31 conditions (one for each day of the month) and place them in your grid.

Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

RE: Creating Calendar in Crystal Reports

Bryan: My advice would be to use Calendar Creator v7 to do this and import the resultant calendar into your Crystal Report as either an OLE object or an HTML file dependent upon your eventual use. Believe me it's much easier than trying to create it in CR

David C. Monks
Accredited Crystal Decisions Enterprise Partner

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close