question

SowmyaRamappa-1538 avatar image
0 Votes"
SowmyaRamappa-1538 asked SowmyaRamappa-1538 commented

Display Pop-up message in the parmeter pane in SSRS report

I want to display a pop-up message in parameter pane when user selects certain optional parameters but forgets to select the mandatory parameters.
Message should alert the user to select mandatory parameters in the SSRS report.
It should display before clicking on View Report and asks user to select the mandatory parameters.

How can I do that? please provide me the inputs!

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered SowmyaRamappa-1538 commented

Message should alert the user to select mandatory parameters in the SSRS report.

SSRS already reminds the user to enter/select a value for as NOT NULL = mandatory parameters.
And SSRS is a reporting tool, not an high interactive frontend.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, but i want to remind the user to select some specific parameter value from the mandatory parameters
For eg. if i select optional parameters then i should select a value = 'None' from the mandatory parameters. This feature i want to add as a pop-up message to let the user know what value to be selected when he selects optional parameters.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Hi,
This is unfortunately not possible with current features of SSRS.
But, SSRS would not allow running the report if not all required parameters are given. So I think this issue could be omit, since report will not be generated if some parameters are missing.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.