If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Best way to transform prompt variables to call a procedure stores

Started by Gouxosor, 19 May 2015 12:21:48 PM

Previous topic - Next topic

Gouxosor

Hello.

I need to transform some reports with dynamic dates. This reports are a simple call to a stored proceture from the prompt (With FromDate and ToDate parameters).

If i add a prompt parameter like current week, how can i transform the call to the stored procedure to something like this:

If week is selected then:

{exec MyStoreProc

    #Prompt('current_week_first_day', date)#,
    #Prompt('current_week_last_day', date)#
}
Thanks in advance.