[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS 2008 The property 'Valid Values' of report parameters 'MyField' doesnt have the expected type.

Posted on 2011-10-03
3
Medium Priority
?
4,222 Views
Last Modified: 2012-05-12
I am trying to create a parameter field for an SSRS2008 report. The field in the table is defined as bigint. In SSRS I can only set the parameter type to integer. Whenever I try to run the report I keep geting this message "The property 'Valid Values' of report parameters 'MyField' doesn't have the expected type." Is the difference between integer to bigint causing this error? I cannot change my table so is there any way to get this report to use this parameter field?
0
Comment
Question by:rwheeler23
3 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 1600 total points
ID: 36905314
Hi ,
Just use data type TEXT in the report parameter.

http://www.bidn.com/blogs/timmurphy/ssas/942/ssrs-bigint-solution

BIGINT to Varchar is an Implicit and should give problems, anyway you can always cast or convert in the SPs.

http://msdn.microsoft.com/en-us/library/ms187928%28v=SQL.90%29.aspx
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 400 total points
ID: 36907967
If creates problem then use Float.

Because float has longer range than int.
0
 

Author Comment

by:rwheeler23
ID: 36908956
Either one worked. It is just strange that all the field types are not available.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question