Hi,
I have a series of reports designed in Reporting Services that I'd like to make available through a single ASP.NET web page. I plan to make the reports available via the ReportViewer control. Unfortunately we don't have SharePoint available and my company isn't looking to buy it - so I'm stuck (I believe) with this method.
Is it possible to host a ReportViewer control inside a Web Part control? First off the ReportViewer control displays my reports perfectly on the page. But once I wrap them in the WebPartZone control I get the following error:
The DataSourceID of the ReportDataSource 'DataSet1' of the ReportViewer 'ReportViewer1' must be the ID of a control of type IDataSource. A control with ID 'ObjectDataSource1' could not be found.
Here is an example web part / report declaration:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
<LocalReport ReportPath="Report2.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetProducts" TypeName="Merchant"></asp:ObjectDataSource>
The reason I'm using Web Parts is to make a dashboard style page.
What can I do to make the datasource available? Or perhaps there is a better / easier way to generate a dashboard style layout in ASP.NET for reporting services reports.
Any pointers appreciated.