Dates as Input Parameter

[simpelli]

I have several reports that require begin date/time and end date/time as parameters. No big deal here.

My problem is that the client wants the DEFAULT values to display as:

FROM:
CurrentDate (again no problem), 12:01AM
TO
CurrentDate 11:59PM

How can I set the time as specified? They want it to be 1 parameter for each each. (FROM DateTime and TO DateTime)

Not FROM Date FROM Time and TO date TO Time

Any Suggestions?

-SI

 

[synapsevampire]

I don't think that this is possible without using external code.

Default values for parameters are a BIG weakness in CR, you also can't set them to a current table value (dynamic parameters in general).

You may be able to use a third party viewer to accomplish this, such as Ido Millet's DataLinkViewer:

http://www.milletsoftware.com/DataLink_Viewer.htm

You might also check Ken Hamady's site:

http://www.kenhamady.com/bookmarks.html

-k

 

[simpelli]

Thanks....I was afraid of that.

-SI