Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SSRS allows you to create 5 types of parameters: Text, Boolean, Date/Time, Integer and Float.

I created a new integer parameter which allows user to enter a minimum price and view a report. However if the user tries to enter for example 100.00, the reports throws an error. Is there a way to convert that parameter to allow decimal data types?

enter image description here

share|improve this question
Did you choose data type Float for the parameter? – efesar Sep 9 '13 at 20:13
I just tried it with data type Integer and received the same error, but changed it to Float and had no problems typing in 100.50 and viewing the report. – efesar Sep 9 '13 at 20:14
It worked with float... which is weird because I tried it before and got an error. I must have done something wrong. thank you – Pawel85 Sep 10 '13 at 13:09

You have selected the parameter type as integer then why are you entering value like 100.50. Instead enter only 100 or change the parameter type to float. Also check the column in your database also, if is it float or integer & then enter appropriate value. Hope this should work proper.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.