Take the 2-minute tour ×
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.

SSRS allows you to create 5 types of parameters: Text, Boolean, Date/Time, Integer i 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 conver 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
1  
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.