Talk with the Author: Date Range Parameter

Print Page | Close Window

Date Range Parameter

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19281
Printed Date: 04 May 2024 at 2:19pm

Topic: Date Range Parameter

Posted By: oceanview
Subject: Date Range Parameter
Date Posted: 15 Mar 2013 at 2:00pm

In my table I have a date field named WorkDate(which stores every working date the employee work for the day). I need a date range parameter where the start date and end date may be the Future Date. So how to pass that parameter?

Replies:

Posted By: Gurbs
Date Posted: 01 Apr 2013 at 10:32pm

If you want the parameters to be variable, you'll have to create 2 parameters. Then, in your record selection, create a formula like

{table.WorkDate} in {?StartDate} to {?EndDate}

When you run the report, it will prompt a screen where you can enter the start and end date.

Print Page | Close Window