Problem showing column data from SSRS report.

I had a big problem showing data in one column in my report. It showed fine in BIDS but it didn´t show in my external reporting tool, similar to report manager..

I had to do like this:

I had to change the fields from where the dataset get it´s data. I changed my name to only “dimension path” + “.[MEMBER_UNIQIE_NAME]. Then i added a new query field with field source ending with “.[MEMBER_CAPTION], see picture. Then i used the “member_caption field to show in column.

Now it works both in BIDS and in external environment.

dataset properties

Advertisements
Tagged with: , ,
Posted in Report Building

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Archive
Categories

Blogstatistics
  • 3,777 hits
Boyan Penev on Microsoft BI

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Sherry's BI Corner

All about Microsoft’s BI Platform (SQL Server, Reporting Services, Analysis Services, Integration Services)

Sherry's BI Corner

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Comments for CALUMO

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

True Tiger Recordings

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Data Inspirations

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

%d bloggers like this: