How to Change the SSRS Datasource

by Garth 26. August 2010 12:00

When a SSRS report is created a data source (DS) is used to create and test the report. This DS may not exist on your SSRS site therefore you will need to point it to a DS that does exist on your site. Use these steps to re-point the DS to an existing DS.

· Connect to your SSRS site

· Browse to the appropriate folder

· Click the report you want to change data source for

· Click the Properties tab

· Click the Data Sources link on the left

clip_image002

· Click the Browse button

· Expand Home | <Your SSRS folder name> until you find the shared data source you are looking for

clip_image004

· Select the data source

Note: {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} is the default ConfigMgr data source

· Click OK (You might need to scroll down to see the OK button.)

clip_image006

· Click Apply button

clip_image008

· Click the View tab to ensure that that report works correctly.

clip_image010

Comments are closed

Powered by BlogEngine.NET 1.6.0.0


Enhansoft specializes in providing software solutions, custom reports, and consulting services for retrieving your IT asset inventory. 

This is done within the system management area focusing on Microsoft System Center Configuration Manager (SCCM) by extending its asset information and reporting capabilities.

Our software solutions found in the Enhanced Asset Management Suite – EAM: Warranty Information Reporting - WIR, Monitor Information Reporting - MIR & Enhanced Web Reporting - EWR, will quickly and accurately report on your:

  • PC (laptop, notebook, desktop & server) warranties
  • PC monitor information
  • Enable you to use over 100 different SQL Server Reporting Services (SSRS) ranging from hardware, software and dashboard categories, to keep track of and effectively display even more detailed information about your IT assets.

Enhansoft aims to make tracking the life cycle of each IT asset on the network as easy and efficient as possible.

Be more efficient.   Be more accurate.  Enhansoft.

 

Tag cloud