SSRS: Report column populated in VisStudio, empty on server

0
votes

So I'm working on a simple SSRS report. When I preview the report in Visual Studio 2010, it behaves as expected. However, when I view the report on the server, the column is empty.

What I've Tried that Hasn't Worked:

Deleting and Redeploying Moving columns in the report around

Below are two pictures of the Visual Studio, and the SSRS Server.

Correct output in VS 2010

Incorrect output in SSRS

Any help is greatly appreciated.

1
sql-servervisual-studio-2010reporting-services
Is the data source set up correctly on the Report Server? If you export the report to excel does it have data ? - Holmes IV
Does your database have any kind of column-level security set up? And are you executing your report with the exact same credentials/security on VS as you are on the server? - DeadZone
@HolmesIV No, there is no data if I export to Excel. - Black Dynamite
@DeadZone No, there is no column level security as we aren't that advanced. - Black Dynamite
I am assuming you have closed your browser and reopened ? I know SSRS has a nasty way of caching results which can be annoying. - Holmes IV

1 Answers

0
votes

You are probably doing a left or right join and the data on the server does not have matching information on one of the tables. In other words the data on the server is not the same as that the BIDS(Visual Studio) points to.

Copy the sql that is the dataset of the report and run it on Management Studio pointing to production and you will likely discover that you are getting blank columns just like when you run the report from SSRS>