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.