hi all, i have an report with 2 parameters. each parameer is optional. but on eof this two has to been inserted. i am looking for a way to validate the input (from the user) before the reports get loaded. like an before submit funktion or else. i want to inform the user py an popup ore something else if both fields are blank. thx for help!

Hi chris_ktm, According to your description, you would like to show a message to prompt user to input values into one of the two fields when both fields are blank, right? If I misunderstand, please let me know. Reporting service don’t have built-in report items to use as popup, so I suggest a workaround for you, using Textbox with expression to achieve your target. In summary, if both of the fields are blank, the textbox will display and the error message will be show on the report, if any fields have a value, the textbox will be hidden, for more details please following the steps as below. 1. Create two parameters with checked “Allow blank value (“”) “check box in the Report Parameter Properties. 2. Insert a textbox to the report title area. 3. Click the textbox, type in the error message with what you would like to display when both of the fields are blank. 4. Select <Expression…> from the Hidden drop-down list under the Visibility property of the textbox properties. 5. Type in the expression: =Iif(Parameters!ReportParameter1.Value="" and Parameters!ReportParameter2.Value="", false, true) 6. Select Color under the Font property of the textbox properties, select “Red”. After you complete these steps above, if both fields are blank, when user click “View Report”, the error message with red font will appear in the report. If you have any question, please feel free to ask. Thanks, Eileen Zhao