RDLC converted from RDL in VS2010 fails to return data
I upgraded several RDL reports to RDLC; the reports were originally written in VS2005 and upgraded with VS2010. I'm using the report viewer in VS2010. The reports run without error, but don't return any data, although the parameters are visible in the report header. A test report developed in VS2010 runs. Is there some references available that enable me to edit the xml file to resolve this issue? Note that the obj references SlaveDataSet from intellisense, but when I don't get an error when I use DataSet1 as the rds.Name (SlaveDateSet errors): try { ReportDataSource rds = new ReportDataSource(); rds.Name = "DataSet1"; rds.Value = obj; this.rpvFlash.ProcessingMode = ProcessingMode.Local; this.rpvFlash.LocalReport.ReportEmbeddedResource = sReport; this.rpvFlash.LocalReport.DataSources.Add(rds); if (bHasParams == true) { ReportParameter[] rParam = new ReportParameter[2]; rParam[0] = new ReportParameter("Start", dtpStart.Value.ToShortDateString()); rParam[1] = new ReportParameter("End", dtpEnd.Value.ToShortDateString()); this.rpvFlash.LocalReport.SetParameters(rParam); } else { ReportParameter rParam = new ReportParameter(); rParam = new ReportParameter("Date", dtpEnd.Value.ToShortDateString()); this.rpvFlash.LocalReport.SetParameters(rParam); } //MessageBox.Show(this.rpvFlash.LocalReport.IsReadyForRendering.ToString()); this.rpvFlash.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } Dan Slaby
November 23rd, 2010 2:06pm

Hi Dan, Could you please clear the DataSources first, and then add the rds to DataSources to check if the issue is solved? this.rpvFlash.LocalReport.ReportEmbeddedResource = sReport; this.rpvFlash.LocalReport.DataSources.Clear(); this.rpvFlash.LocalReport.DataSources.Add(rds); Thanks, Jin Chen Jin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 3:42am

Thanks for your suggestion, but it did not fix the issue. Do you have any other?Dan Slaby
November 24th, 2010 3:40pm

Hi Dan, Could you please debug the application, and check if the dataset has data? Also, could you please try to add a textbox to the report, and use the expression =First(Fields!fieldname.Value, "dataset") to check if the data is passed in correctly. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 3:28am

Apparently the probem is that the "DataSet1" that is embedded in the report is not the same as the "DataSet1" that was created in the application where the reports were copied. I don't see any xml files in the embedded windows reports that I can change guids. Is there a way to edit these reports and datasets to conform their guids? Dan Slaby Incidently, I copied the reports to VS2010 and am developing the application in VS2010. The Tablix Properties show the dataset name 'Dataset1' on the row containing the expresions from the Fields(DataSet1), but don't display data. The textbox using the expression =First(Fields!LGC.Value, 'DataSet1') doesn't return any data. the Fields in the category shows the message 'Report item is not linked to a dataset'. Are these typical issues trying to use the reportviewer in VS2010 with report conversions from RDL to RDLC? Incidently, I created another approach using the webbrowser in VS2010 and find that the parameters are ignored even when they are in the parameter string, and when the webbrowser opens it doesn't activate the calendar nor accepts input from the associate textboxes. Is this because the client side scripting does not work in the windows webbrowser? SSRS log on developer machine (the reports are connecting to a different SQL server): <Header> <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product> <Locale>English (United States)</Locale> <TimeZone>Pacific Standard Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__11_25_2010_01_31_14.log</Path> <SystemName>1347259-VS2010</SystemName> <OSName>Microsoft Windows NT 6.1.7600</OSName> <OSVersion>6.1.7600</OSVersion> <ProcessID>1972</ProcessID> <Virtualization>None</Virtualization> </Header> rshost!rshost!41c!11/25/2010-01:31:14:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. rshost!rshost!41c!11/25/2010-01:31:14:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager. rshost!rshost!41c!11/25/2010-01:31:14:: i INFO: Endpoint 4 is disabled and no url is registered vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. rshost!rshost!84c!11/25/2010-01:31:14:: i INFO: Derived memory configuration based on physical memory as 8317376 KB servicecontroller!DefaultDomain!84c!11/25/2010-01:31:14:: i INFO: Recycling the service from the default domain rshost!rshost!84c!11/25/2010-01:31:19:: i INFO: Application domain type WindowsService statistics: created: 5, unloaded: 5, failed: 0, timed out: 0. appdomainmanager!DefaultDomain!84c!11/25/2010-01:31:19:: i INFO: Appdomain:7 WindowsService_5 started. library!WindowsService_5!84c!11/25/2010-01:31:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; servicecontroller!WindowsService_5!84c!11/25/2010-01:31:19:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. resourceutilities!WindowsService_5!84c!11/25/2010-01:31:20:: i INFO: Reporting Services starting SKU: Developer servicecontroller!WindowsService_4!84c!11/25/2010-01:31:20:: i INFO: Service controller exiting. appdomainmanager!DefaultDomain!84c!11/25/2010-01:31:20:: i INFO: Appdomain:6 unregistered. appdomainmanager!DefaultDomain!84c!11/25/2010-01:31:20:: i INFO: Appdomain:6 WindowsService_4 unloading. appdomainmanager!DefaultDomain!934!11/25/2010-01:31:20:: i INFO: AppDomain:6 0 pending unload(s) library!WindowsService_5!41c!11/25/2010-01:31:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; library!WindowsService_5!41c!11/25/2010-01:31:20:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. library!WindowsService_5!41c!11/25/2010-01:31:20:: e ERROR: ServiceStartThread: Attempting to start service again... rshost!rshost!934!11/25/2010-13:31:20:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. rshost!rshost!3f8!11/25/2010-13:31:20:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager. rshost!rshost!8dc!11/25/2010-13:31:20:: i INFO: Endpoint 4 is disabled and no url is registered vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder. rshost!rshost!84c!11/25/2010-13:31:20:: i INFO: Derived memory configuration based on physical memory as 8317376 KB servicecontroller!DefaultDomain!84c!11/25/2010-13:31:20:: i INFO: Recycling the service from the default domain rshost!rshost!84c!11/25/2010-13:31:21:: i INFO: Application domain type WindowsService statistics: created: 6, unloaded: 6, failed: 0, timed out: 0. appdomainmanager!DefaultDomain!84c!11/25/2010-13:31:21:: i INFO: Appdomain:8 WindowsService_6 started. library!WindowsService_6!84c!11/25/2010-13:31:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; servicecontroller!WindowsService_6!84c!11/25/2010-13:31:21:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. resourceutilities!WindowsService_6!84c!11/25/2010-13:31:21:: i INFO: Reporting Services starting SKU: Developer servicecontroller!WindowsService_5!84c!11/25/2010-13:31:21:: i INFO: Service controller exiting. appdomainmanager!DefaultDomain!84c!11/25/2010-13:31:21:: i INFO: Appdomain:7 unregistered. appdomainmanager!DefaultDomain!84c!11/25/2010-13:31:21:: i INFO: Appdomain:7 WindowsService_5 unloading. appdomainmanager!DefaultDomain!7f0!11/25/2010-13:31:21:: i INFO: AppDomain:7 0 pending unload(s) library!WindowsService_6!3f8!11/25/2010-13:31:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ; library!WindowsService_6!3f8!11/25/2010-13:31:21:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. library!WindowsService_6!3f8!11/25/2010-13:31:21:: e ERROR: ServiceStartThread: Attempting to start service again...
November 26th, 2010 6:50pm

Apparently the probem is that the "DataSet1" that is embedded in the report is not the same as the "DataSet1" that was created in the application where the reports were copied. I don't see any xml files in the embedded windows reports that I can change guids. Is there a way to edit these reports and datasets to conform their guids? Dan Slaby Incidently, I copied the reports to VS2010 and am developing the application in VS2010.
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 6:51pm

Apparently the probem is that the "DataSet1" that is embedded in the report is not the same as the "DataSet1" that was created in the application where the reports were copied. I don't see any xml files in the embedded windows reports that I can change guids. Is there a way to edit these reports and datasets to conform their guids? Dan Slaby Incidently, I copied the reports to VS2010 and am developing the application in VS2010. The Tablix Properties show the dataset name 'Dataset1' on the row containing the expresions from the Fields(DataSet1), but don't display data. The textbox using the expression =First(Fields!LGC.Value, 'DataSet1') doesn't return any data. the Fields in the category shows the message 'Report item is not linked to a dataset'. Are these typical issues trying to use the reportviewer in VS2010 with report conversions from RDL to RDLC? Incidently, I created another approach using the webbrowser in VS2010 and find that the parameters are ignored even when they are in the parameter string, and when the webbrowser opens it doesn't activate the calendar nor accepts input from the associate textboxes. Is this because the client side scripting does not work in the windows webbrowser?
November 26th, 2010 6:53pm

I found the missing part, and added a function to fill obj with data before assigning it to rds.value.Dan Slaby
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2010 1:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics