I have C# (WPF) application where I want to display a SSRS report in the ReportViewer control. The local report file has XML datasource embedded in it. The report is displayed correctly when running from SQL Server Business Intelligence Development Studio. But when I run with my app I get the following error:\[code\]A data source instance has not been supplied for the data source '...'.\[/code\]So here is what I'm doing:I have defined embedded XML data, as explained in this tutorial Defining a Report Dataset from Embedded XML Data. I have a data source called \[code\]XmlDataSource_TopCustomers\[/code\] and a data set called \[code\]XmlDataSet_TopCustomers\[/code\], using that data source. I have referred the data set in a table and a chart. Overall, the RDL looks like this (just the essential, of course): <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <Body> <ReportItems> <Tablix Name="Tablix1"> <DataSetName>XmlDataSet_TopCustomers</DataSetName> </Tablix> <Chart Name="Chart1"> <DataSetName>XmlDataSet_TopCustomers</DataSetName> </Chart> </ReportItems> </Body> <DataSources> <DataSource Name="XmlDataSource_TopCustomers"> <ConnectionProperties> <DataProvider>XML</DataProvider> <ConnectString /> </ConnectionProperties> <rd:SecurityType>None</rd:SecurityType> <rd
ataSourceID>47833b52-231f-4634-8af4-3c63272b02a7</rdataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="XmlDataSet_TopCustomers"> <Query> <DataSourceName>XmlDataSource_TopCustomers</DataSourceName> <CommandText><Query> <ElementPath>Root /CustomerOrder {@CustomerNo, @CustomerName, @OrdersCount (Integer), @Total(Float), @AveragePerOrder(Float)}</ElementPath> <XmlData> <Root> <CustomerOrder CustomerNo="10001" CustomerName="Name 1" OrdersCount="2" Total="5.446740000000000e+003" AveragePerOrder="2.723370000000000e+003" /> <CustomerOrder CustomerNo="10894" CustomerName="Name 2" OrdersCount="5" Total="3.334750000000000e+003" AveragePerOrder="6.669500000000001e+002" /> <CustomerOrder CustomerNo="12980" CustomerName="Name 3" OrdersCount="2" Total="2.003290000000000e+003" AveragePerOrder="1.001645000000000e+003" /> </Root> </XmlData> </Query></CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> <Fields>... </DataSets> <rd:ReportUnitType>Inch</rd:ReportUnitType> <rd:ReportID>02172db8-2a1d-4c35-9555-b37ee6193544</rd:ReportID> </Report>At this point everything works fine from the IDE.In my C# application, I have a ReportViewer and the following code:\[code\]Viewer.LocalReport.ReportPath = @"<actualpath>\TopCustomers.rdl"; // actual path is OKViewer.RefreshReport();\[/code\]And then I get that\[code\]A data source instance has not been supplied for the data source 'XmlDataSet_TopCustomers'.\[/code\]I've seen others having the same problem, but in most of the cases the problem is multiple datasources, which is not the case here, as you can see from the RDL snippet above.Any suggestions?
ataSourceID>47833b52-231f-4634-8af4-3c63272b02a7</rdataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="XmlDataSet_TopCustomers"> <Query> <DataSourceName>XmlDataSource_TopCustomers</DataSourceName> <CommandText><Query> <ElementPath>Root /CustomerOrder {@CustomerNo, @CustomerName, @OrdersCount (Integer), @Total(Float), @AveragePerOrder(Float)}</ElementPath> <XmlData> <Root> <CustomerOrder CustomerNo="10001" CustomerName="Name 1" OrdersCount="2" Total="5.446740000000000e+003" AveragePerOrder="2.723370000000000e+003" /> <CustomerOrder CustomerNo="10894" CustomerName="Name 2" OrdersCount="5" Total="3.334750000000000e+003" AveragePerOrder="6.669500000000001e+002" /> <CustomerOrder CustomerNo="12980" CustomerName="Name 3" OrdersCount="2" Total="2.003290000000000e+003" AveragePerOrder="1.001645000000000e+003" /> </Root> </XmlData> </Query></CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> <Fields>... </DataSets> <rd:ReportUnitType>Inch</rd:ReportUnitType> <rd:ReportID>02172db8-2a1d-4c35-9555-b37ee6193544</rd:ReportID> </Report>At this point everything works fine from the IDE.In my C# application, I have a ReportViewer and the following code:\[code\]Viewer.LocalReport.ReportPath = @"<actualpath>\TopCustomers.rdl"; // actual path is OKViewer.RefreshReport();\[/code\]And then I get that\[code\]A data source instance has not been supplied for the data source 'XmlDataSet_TopCustomers'.\[/code\]I've seen others having the same problem, but in most of the cases the problem is multiple datasources, which is not the case here, as you can see from the RDL snippet above.Any suggestions?