SSRS AlphaNumeric Parameter Validation
- Joel Lipman
- SQL Server Reporting Services
- Hits: 10913
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check:
The Plan
- User enters value in parameters and clicks on "View Report"
- Report passes parameter to dataset which gets formatted by the database
- Report retrieves (select) formatted parameter as a field value to use
- Report loads with changes based on returned value.
The Gist
- Add database level parameter check
- Add IIF in SSRS to confirm