"RobKaratzas" wrote:

> Yes, the Report Parameters have a Data Type, Available values and Default
> Values properties.
>
> right-click in the whitespace to the left of your report in Layout view
> (VS.NET), or directly from the SSRS browser for the report.
>
> Select your parameter from the Parameters list in the applet and modify your
> parameter to be integer or float as appropriate.
>
> Rob
>
> "Atina" wrote:
>
> > I have a report generated using Reporting Services that contains a report
> > parameter of integer datatype. I was asked to put a "validation" on the
> > report parameter to accept only numeric data. The RS used to crash if any
> > alphanumeric data was input in the report parameter textbox.
> > Basically, I have to block the ability for the user to search for records if
> > the data entered in the report parameter is not numeric. In short if a user
> > enters any data, which is not numeric, then the report parameter should be
> > validated and an error message should be displayed.
> > How do I provide a validation on the report parameter in MS Reporting
> > Services so that it does not give an ‘rsParameterTypeMismatch’ Reporting
> > Services error? Is it possible to provide any validation on the 'View Report'
> > button ?
> >
> > Any help will be really appreciated. Thanks.