Search

Field value is not displayed if the field name includes 15 characters or more in SSRS by Sharpening

Active

1
0
Sign in
 to vote
Type: Bug
ID: 770808
Opened: 11/12/2012 6:40:03 AM
Access Restriction: Public
1
Workaround(s)
0
User(s) can reproduce this bug
I design a SSRS 2008 R2 report that pulled data from a relational SSRS 2008 R2 DB. One column's name that is 15 characters long. When I use the original column name as the filed name in a dataset, the field does not show any value when I run the report. However, when I run the dataset query in SSMS, the column value is displayed.
Details (expand)

Product Language

English

Version

SQL Server 2008 R2

Category

Reporting Services

Operating System

Windows Server 2008 R2 Enterprise (SP1)

Operating System Language

English

Steps to Reproduce

1. Create a table that includes a column with a name more than 15 characters
2. Create a dataset that uses the column as query field name
3. Run the report

Actual Results

No data is displayed for the query filed.

Expected Results

Field value is displayed.

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.
Posted by Sharpening on 11/12/2012 at 6:42 AM
Use an alias that is less than 15 chars for the column name, for example:

SELECT ORIGINAL_COLUMN_NAME AS SHORT_COL_NAME FROM....
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement