Parameter Fields question

[MHann]

Hello,

I have 2 Parameters that came into my report from the database (BegDate & EndDate).
I want to set these dates to default to the current date. While I can create a new parameter set to current date I'm having trouble doing so with these existing parameters.
Any ideas?

Thank you.

 

[IanWaterman]

In parameter editor remove the default dates. When left blank crystal will populate with current date when report is run.

Ian

 

[lbass]

Ian,

Can you explain what version you are using? Are you assuming the parameters are from a stored procedure? I don't recall ever seeing this behavior, so am interested in what cases this might occur.

-LB

 

[MHann]

I'm using version XI. The paramters are forced into the report by an SAP Infoset. Leaving the date blank was not an option it can either be null or there has to be a date.

I was able to cheat it and put the dates as 12/31/9999. This will always pull the data I need. Only problem is it will pull any future data. But we never have data future data going out more than a few days.

It's not preferred but it works.

Thanks!

 

[lbass]

I'm not sure how you are currently using the parameters, but you can always build the currentdate option into the selection formula, like this, for example:

(
(
{?StartDate} = date(9999,12,31) and
{table.date} <= currentdate
) or
(
{?StartDate} <> date(9999,12,31) and
{table.date} >= {?StartDate}
)
)

-LB