Skip to Content
0

Webi Report to Run with default From and To Sysdate ?

Feb 21 at 10:33 PM

32

avatar image
Former Member

Hello Experts,

I read lot of forums and also checked Dave's Adventure for how to prompt user with from and to sysdate at the same time I want to schedule this report so current date should be a default value there. Below is what I am doing at IDT creating a filter with below

Table.Column_name= case when @prompt('Enter shipping date','D',,mono,free) = '1900-01-01' then sysdate else @prompt('Enter shipping date','D',,mono,free) end

The expression parsed and worked fine, Now I want to use Between as below but parsing fails

Table.Column_name= between ( case when @prompt('Enter shipping date','D',,mono,free) = '1900-01-01' then sysdate else @prompt('Enter shipping date','D',,mono,free) end) And ( case when @prompt('Enter shipping date','D',,mono,free) = '1900-01-01' then sysdate else @prompt('Enter shipping date','D',,mono,free) end)

I tried creating parameter but still no success. Parsing error is attachedcapture.jpg Any help is appreciated.

Thank you

capture.jpg (28.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Feb 22 at 10:42 AM
0

Just remove the "=" sign from your syntax

Table.Column_name between

(

case when @prompt('Enter shipping date','D',,mono,free) = '1900-01-01' then sysdate else @prompt('Enter shipping date','D',,mono,free) end

)

And

(

case when @prompt('Enter shipping date','D',,mono,free) = '1900-01-01' then sysdate else @prompt('Enter shipping date','D',,mono,free) end

)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Kuldeep, It worked but report does not run for the current date any suggestion how to make the report work for the current date?

0