Topic: default value for parameter Posted: 23 Apr 2014 at 7:45am
Hi,
Does anyone else have a problem with setting up default values for parameters? I used it in different reports and for some reason it will not put the default value in the parameter field.
I'm trying to pull up a report with data between an interval of dates, an I need them to be something like this:
From date: 04/21/14 00:00:00 AM
To Date: 04/21/14 12:59:00 PM
So I need the default hour for the "To Date" parameter to be 12:59:00 PM and I put that in the default value field in the edit parameter window and it just won't do it..
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 23 Apr 2014 at 9:21am
it seems that crystal wont let you putt just part of the datetime parameter in default values. you could do a date parameter then create a formula like DATETIME({?To Date} +" "+ "12:59:00 PM") then just use that formula as your parameter
Joined: 05 Feb 2014
Online Status: Offline
Posts: 85
Posted: 23 Apr 2014 at 9:50am
Wouldn't from date 04/21/14 00:00:00 AM to date 04/21/14 12:59:00 PM be the same as from date 04/21/14 to date 04/22/14? Why do you need the hours and minutes and seconds?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum