Datetime with Parameters...

[endoflux]

I have a DateTime field in my database, and want to prompt users for a date range when running the report...however, it won't let me set the DateTime field = to a parameter!? How should I go about this?

 

[pkcdude]

make sure that your parameter have the right type selected.

 

[kenhamady]

Does it give you an error message? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[endoflux]

It tells me that a number, date, date-time, currency, or string is required here...

I've tired defining the parameter field as date-time, date, and string, to no avail...

 

[kenhamady]

First confirm the data type of the field as seen by CR.
(see faq149-732).

Where are you posting the formula?
What is the exact formula you are posting?
What settings are you using for the parameter? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[endoflux]

Hmmm...I just tried the same thing I've tried 10 times...only this time when I put the parameter field in the formula, I accidentally put the wrong field in. when it errored and told me "T date-time is required here" (I accidentally used another string parameter field), I deleted it and put in the correct parameter....

Even though it's the same fomula I've tried 10 times, it worked this round...<scratching head> <shrug> I guess that's the best I can do! As long as it works, I have no complaints...

Thanks!