SQL Server Performance

Validate parameters

Discussion in 'SQL Server Reporting Services' started by MattiasT, Feb 5, 2004.

  1. MattiasT New Member

    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
  2. jasper_smith New Member

    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
  3. MattiasT New Member

    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

Share This Page