Skip to Content

Webi Report to Run with default From and To Sysdate ?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 22 at 10:42 AM

    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

    )

    Add comment
    10|10000 characters needed characters exceeded

    • 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?