Displaying alert message based on user input on input param screen

[Former Member]

Hi,

Based on user input I wish to display an alert popup on my report. I

have provided the user 2 dropdowns called sortasc and sortdesc with all

the column names used in the report to simulate dynamic sorting.This is

because we do not have dynamic sorting in CR XI R2. When the user

selects same column name in both sortasc and sortdesc then the sort

type which has priority in the record sort expert is executed. This is fine but we want an alert

or message popup displayed so as to prevent user from selecting same

column names.

I tried adding an alert with the following code:

if {?sortasc} = {?sortdesc} then true else false

So far I have not been prompted with any alert message box.

Let me know if there is any other option.

[Former Member · Accepted solution]

Hi Shalu,

I have created a alert and it is working fine, please follow the steps

Create a new Alert using two static parameters and give the condition for message like :

if {?Myworld} = {?Myworld1} Then

'You have entered a correct word'

else

'This is not a correct word'

Then create a condition like :

{?Myworld} = {?Myworld1} or {?Myworld} <> {?Myworld1}

Also check the check box Enabled and save the alert. Now it will popup if the myworld is equal to myworld1 or myworld is not equal to myworld1.

Hope this will help you

Thanks,

Sastry

[Former Member · Accepted solution]

Hi Sastry,

Thanks for your response. I am using the alert exactly as illustrated by you but I am not getting any alert message box even though i select the same values for ?param1 and ?param2.

Let me know where do I expect to see the alert.

Thanks!

[Former Member · Accepted solution]

Hi Shalu,

Can you remove true or false from your statement and usethe following :

 = {?sortdesc} or {?sortasc}<> {?sortdesc}

Thanks,

sastry

[Former Member · Accepted solution]

Hi Shalu,

Please go in FileReport Optionsand check in Display Alerts on Refresh and refresh the report and check.

Thanks,

Sastry