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

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?
LVL 1
rwheeler23Asked:
Who is Participating?
 
Jason Yousef, MSSr. BI  DeveloperCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
If creates problem then use Float.

Because float has longer range than int.
0
 
rwheeler23Author Commented:
Either one worked. It is just strange that all the field types are not available.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here