Home Dashboard Directory Help
Search

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


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 770808
Opened: 11/12/2012 6:40:03 AM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Sign in to post a comment.
Posted by Microsoft on 10/31/2013 at 5:00 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.

Mariusz Cichomski
Program Manager, Microsoft | SQL
Posted by Microsoft on 10/31/2013 at 5:00 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.

Mariusz Cichomski
Program Manager, Microsoft | SQL
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....