tags:

views:

23

answers:

0
Q: 

STATE_ABBR in SSRS data type does not match the matching field data type

I'm creating an analytical US state map using SSRS. I've matched the STATE_ABBR field to my db's state abbreviation field that is of data type VARCHAR(50). I changed the data type to VARCHAR(2) and CHAR(2) but still get the following error:

The expression that specifies the binding field 'STATE_ABBR' for layer 'PlygonLayer2' in the map 'Map5' is not valid. The data type does not match the matching field data type.

IF the problem is with the state's data type, what is the appropriate type for this?

Thanks.

related questions

Representing unlimited in database with integer data type
How Does MySQL Store Enums?
WPF HiercharchicalDataTemplate.DataType: How to react on interfaces?
What's bigger than a double?
Sql Data Type for Primary Key - SQL Server?
Sql Server 2005: what data type to use to store passwords hashed by SHA-256 algorithm?
What is the best datatype for currencies in MySQL?
MySQL: what data type to use for hashed password field and what length?
Limiting File Attachments to a SQL Server 2005 DB to a value > 8000 bytes
String vs string in C#
What is the data type for length property for Java arrays?
What data type do you use for storing IDs?
What is the best datatype to use for storing moderate amounts of text in SQL Server (2005)?
Data Types supported in visual studio 2008
In MySQL, is there any difference (performance-wise) between decimal and double?
VB6 Date Datatype: Precision and formatting
Letters within integers. What are they?
What are the lengths of common datatypes?
SQL Server 2005 encryption trigger
Setting data type when reading XML data in SAS
How do I parse a number from a String that may have a leading zero?
Should I never use primitive types again?
Is it possible to store and retrieve a boolean value in a varchar field using Java JDBC?
C# Datatype for large sorted collection with position?
Datatypes for physics