Skip to Content
avatar image
Former Member

Dynamic and Prompted Dates in Central Management Console/BI Launchpad

Hi,

I'm not sure if this is the right forum for this discussion, so please let me know if I should move it.

The reports where I work are currently with an Oracle database, using SQL Commands or stored procedures and temp tables, run through a custom Internet interface or scheduled through Central Management Console or BI Launchpad.

The reports in question that I'm being asked about are desired to have both dynamic and user-entered date parameters.

When they are scheduled on a recurring basis, the user wants to put in a formula or sysdate (see attached) so that can be used to complete the date parameters, BUT if the report is run ad-hoc or through the Internet interface, the user can still enter the date parameters and have it run to those specifications.

Is this possible?  I would normally have two reports - one that runs the desired date range and set that one to recurring and one for ad-hoc with date parameters.

Would anyone happen to know how to do this?  If it's possible?  A work-around?

Thank you,

Erin

SysDate.jpg (14.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 02, 2015 at 08:08 PM

    Which version of BusinessObjects/Crystal Reports Server are you using?  Which version of Crystal?

    There is probably a way to do this, but it's dependent on the version you're using.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded