C# – How to get the data source information from a SSRS report, using .NET

cnetreporting-servicessql server

I am currently making an ASP.Net and C# page, which is a front end for some reports.

I also want to run some queries, from the same data source as the reports (each report uses just 1 data source).

Is it possible to extract the data source connection information from a report, using either ReportingService2005 or ReportExecutionService members, so that it can be reused in an SqlConnection?

Best Answer

You can use the ReportingService2005 API to get the datasource used by a particular report.

You need the full path of the report (which I assume you have), and then use it to query the reporting service for its data source (API).

// rs = ReportingService2005 that you need to set up.

DataSource ds;
DataSources dataSources = rs.GetItemDataSources(item);

// item is a string containing the full path to the report.

dataSources = rs.GetItemDataSources(item);
ds = dataSources[0];

The ds in the code above is either a DataSourceDefinition or a DataSourceReference. If it's a definition you can just cast it into that type and then get the connection string using the following code.

DataSourceDefinition dsd = ds as DataSourceDefinition();
if(dsd == null)
    throw new Exception();

String connectionString = dsd.ConnectString;

If it's a datasourcereference you need to check out the API.

Related Solutions

C# – How to get the path of the assembly the code is in

I've defined the following property as we use this often in unit testing.

public static string AssemblyDirectory
{
    get
    {
        string codeBase = Assembly.GetExecutingAssembly().CodeBase;
        UriBuilder uri = new UriBuilder(codeBase);
        string path = Uri.UnescapeDataString(uri.Path);
        return Path.GetDirectoryName(path);
    }
}

The Assembly.Location property sometimes gives you some funny results when using NUnit (where assemblies run from a temporary folder), so I prefer to use CodeBase which gives you the path in URI format, then UriBuild.UnescapeDataString removes the File:// at the beginning, and GetDirectoryName changes it to the normal windows format.

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Best Answer

Related Solutions

C# – How to get the path of the assembly the code is in

Sql – How to return only the Date from a SQL Server DateTime datatype

Related Topic