I need your assistance with creating an SSRS report type. Here's what I've done:
1. Created a simple SSRS report through Visual Studio and saved it to a file called sample.rdl.
2. Uploaded sample.rdl to a folder in our DNN instance.
3. Created an SQLView Pro report, report type SSRS.
4. Configured this report to use Processing Mode 'Local' and selected sample.rdl. I left all other fields at the default.
When I save this configuration, the page refreshes but throws the following error messages:
A data source instance has not been supplied for the data source 'DataSet1'.
An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot find table 0. ---> System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at DNNStuff.SQLViewPro.SSRSReports.SSRSReportControl.RenderLocalReport() at DNNStuff.SQLViewPro.SSRSReports.SSRSReportControl.RefreshReport() at DNNStuff.SQLViewPro.SSRSReports.SSRSReportControl.BindTemplateToData() at DNNStuff.SQLViewPro.SSRSReports.SSRSReportControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I looked through docs.dnnstuff.com, but it looks like you haven't published any SSRS documentation yet.
Can you please advise how to resolve this issue?
Thanks in advance.