Wednesday, 28 January 2015

Value of Optional Prompt if you entered anything or not.


Value of Optional Prompt if you entered anything or not.


  • Create a list report with an Optional Value prompt on City data item.


  • On running the report you will get the output as below with all City prompt values.


  • Now drag the “Layout Calculation” from Toolbox and entered the If-Then-Else and click OK.
  • This way, If you did not select any value by default it will run for all and you will get “2”.
  • And, If you select any value in the prompt e.g. Toronto then it will show “1”.

9 comments:

  1. If (paramDisplayValue('Parameter1') is null) then ('1') else ('2')
    this will work in "report expression"
    But when we add this in "filter expression" this wont work..
    Can u help me

    ReplyDelete
    Replies
    1. yes it will not work in filter as it contains only Paramvalue, but why you want this to put in filter, are you trying to filter either 1 or 2?

      Delete