How can I create a dialog that prompts a user for a date range?

[corbitt]

We are confused.

We are trying to create a Crystal Reports 8.5 report that, when opened, will display a dialog box requesting a date range. Data, based on the date range entered, will be pulled from a particular field.

Any help is appreciated.

Thank you,

Jeremy

 

[IdoMillet]

Just create the data parameter with a "Range" option.

Then set the record seelction formula to something like:
--------------------------------------------
{order_date} IN {?your_range_date_parameter}
--------------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

This is a cross post, it was already answered...

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[corbitt]

I'm sorry for the "cross-post." I wasn't sure which category to use. I'm still having problems...I'll post in a second.

Thank you,

Jeremy

 

[synapsevampire]

No worries, corbitt.

Ido: It's a CE issue, and the database is Informix.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[SirSmoother]

I would create 2 parameters: dtstart, dtend (or a single dat range parameter called dtrange). Then, in the Select Expert, add the following: {table.field} In dtstart to dtend.

 

[corbitt]

It works!

Our mistake:

We were editing the SQL directly.

Solution:

We used select expert.

Thank you,

Jeremy