Formula within a Parameter? 1

[PAULCALLAGHAN]

I'm using CR XI.

I would like to create a formula for dates that is based on the current date.

For example, I want starting and ending dates based on the last full calendar year.

@start_date = Date(Year(CurrentDate)-1,1,1)
@end_date = Date(Year(CurrentDate)-1,12,31)

However, I would like to use these as default parameters and give the user the ability to over-ride them.

Is this possible? If not, can someone please provide me with ideas/hints?

 

[synapsevampire]

Users...

So are the users using Crystal Reports Server, or?

Please post specifics, we need to know what software is being used by the users, not what you are developing in.

This might be what you need:

http://support.businessobjects.com/library/kbase/articles/c2017204.asp

-k

 

[PAULCALLAGHAN]

Thank you Syn for the prompt reply! You pose a very good question. I apologize for not providing this piece of information.

The users at my company use DataLink Viewer, an excellent product. I'm not sure how this is relevant though.

The kb article you gave is good but not quite applicable to my situation. It mentions a fix to parameters that are not properly keeping the last values used.

I want to use consistently calculated default values for my parameters yet still provide the user with the option to enter different values at anytime.

 

[lbass]

I don't know of a way to display default dates based on a formula like yours, but you could enter defaults of "9999-09-09" for the start and end date parameters, and then in the record selection formula use:

(
if {?start} <> date(9999,09,09) then
{table.date} >= {?start} else
if {?start = date(9999,09,09) then
{table.date} >= date(year(currentdate)-1,1,1)
) and
(
if {?end} <> date(9999,09,09) then
{table.date} <= {?end} else
if {?end} = date(9999,09,09) then
{table.date} <= date(year(currentdate)-1,12,31)
)

You could enter prompt text notifying the user that if they do not select a date range, the report will automatically run for the last full year.

-LB

 

[synapsevampire]

Speak with the folks at Datalink.

-k