I am almost certain there might be a better way of doing this, but this works for me and has been proven and tested in my own environment on multiple occassions.

I have a SharePoint list containing employee data that needs to be used in a Reporting Services report. The goal of this report is to display the number of employee turnovers for each satellite office location. On one specific occassion, i had a need to parse out the ugly XmlNode that was returned to me after querying my SharePoint list for employee ID’s.

First, i connected to my SharePoint list containing the employee id’s, then created my XmlDocument and XmlNode(s) to query my list. The XmlNode, “ndViewFields”, contains the fields i am interested in returning. You can leave this empty if you’d like to return every column in that list, but in my case, i’m only interested in the “ID” and “EMPLID” columns. (more…)

Navigate to the ReportServer website. You will see a list of folders. Open the folder with your report in it. Find the report you want and open it. The screen will come up and prompt you for parameters. Let’s say that your report needs a CustomerID. Simply ad this as a querystring value to the URL “&CustomerID=1516″ and refresh the page. If you pass all of the required parameters to the report it will run automatically.

(more…)