Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Default value in Prompt needs dynamic current date

The date prompt is an input parameter of the stored procedure which the Crystal report accesses through Java Data Source.

Our requirement is to display the Current Date as the default in the date prompt whenever the report is run.

Crystal only allows us to give a proper date in the Default Value (under Value Options) but does not let us set the default dynamically to the current date.

Please let me know if there is any work around to pass the current Date (Sysdate) dynamically to date prompt parameter

Thanks and Regards

Purna

Former Member
replied

There is one more workaround by inserting present report as subreport and create a formula like

@date

currentdate

link this formula with the command level paramter in the subreport by using change subreport links.

Regards,

Raghavendra

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question