Search code examples
sharepoint-2010ssrs-2008

SSRS, some fields are not displayed report once deployed to server (Sharepoint 2010)


I am not able to view some of the fields once the report is generated on server. Report is getting generated properly but data is not being displyed. The report works fine on local machine.

Below is the screenshot of the issue I am facing.

Local Reports:

Locally Working Screenshot

On Server I am facing the issue as below, the data is fetched properly as can be seen on the screenshot. The sections have got created correctly indicates query has executed successfuly. For some strange reasons only Time column is getting displayed.

Issue on server


Solution

  • The above issue was because Dataset did not contain all the columns, i changed the default view and added all the fields to the default view.

    I could see only time column as the default view had only Time column in it, i had to add all other columns in order to get it working.

    Referred this link to get to the solution.