Validate parameters | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Validate parameters

Hi! I have two questions: 1. Is there, in the Report Manager, any way to validate query parameters before sending them to the query and if they don’t validate inform the report user about it? 2. Is there, in the Report Manager, any way to format DateTime parameters to display the date in a different format. E.g. 2003-10-01 instead of 10/1/2003 12:00:00 AM? Thank’s all! /Mat /Mattias
I think the purpose of Report Manager is basic management of security/report settings etc. It’s not really designed as a User UI although it can be used for that for basic functionality. I’d say that to get what you want, you’d have to write your own "wrapper" web page that then calls the report either using URL access or the Web Service calls. HTH Jasper Smith
I found one good way to validate parameter input and output and that’s by creating an CustomCode assembly and doing the validation there. /Mattias