all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Shared Datasource Help


Shared Datasource Help Paula
12/1/2005 11:20:51 AM
sql server reporting services: I need to populate a dataset with data in an external .NET solution. It
would be similar to this for xml, but the data I want is in a shared
datasource:
private DataTable LoadSalesData()
{
DataSet dataSet = new DataSet();
dataSet.ReadXml("data.xml");
return dataSet.Tables[0];
}

So, rather than ReadXml, I want to use "c:\test\shareddatasource.rds".

TIA,

Re:Shared Datasource Help Paula
12/1/2005 12:12:49 PM
I got a little further, now the report format displays, but not the data.
Here is my new code:

private DataTable LoadReportData()
{

DataSet ds = new DataSet();
ds.ReadXml("C:\\Reports\\ReportsSharedDataSource.rds");
return ds.Tables[1];
}

protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.
ProcessingMode.Local;
this.ReportViewer1.LocalReport.ReportPath =
"C:\\Reports\\ActivitySummaryReport.rdl";
this.ReportViewer1.LocalReport.DataSources.Add(new Microsoft.
Reporting.WebForms.ReportDataSource("ReportsSharedDataSource",
LoadReportData()));
this.ReportViewer1.LocalReport.EnableExternalImages = true;
}

Thanks,

AddThis Social Bookmark Button