Search code examples
pentaho

How to change display value in parameter selection pentaho reports

I need to display "All" when my data in parameter list is -1. Just to display in the parameter selection.

Help me with this

Thanks, Keerthi KS

Solution

  • you can change your sql like these.

    Eg:- 

    SELECT "ALL" AS column_name
UNION
SELECT column_name FROM table_name

    in that bottom sql is your 43,44,45 sql.

    If you modified like these.

    Again little bit changes required in that main sql. Meaining in sql where condition.

    I think your problem will be solved.

    Thank you..