ReportViewer: converting existing .rdl reports from SSRS into .rdlc files

• george.lewycky

  Mr or Mrs. 500

  Points: 570

  More actions

  November 4, 2015 at 2:08 pm

  #312754

  Hi Everyone

  I'm glad I found this book Learning SQL Server Reporting Services 2012 By Jayaram Krishnaswamy

  and his websites/blogs which was a saviour along with the link below.

  This CODEPLEX site is also one of the best sites I have found.

  It seems ReportViewer is something NOT widely in use or well documented as I am discovering.

  I was given the task of migrating our reports (*.rdl) off our Report Server and onto the same server where the web app is running ( converting the *.rdl to *.rdlc )

  (1) I havent been able to find anything explaining how to access and reference multiple reports without hardcoding them as shown here:

  http://forums.asp.net/t/1472608.aspx

  Other websites and references just illustrate a single report or worse created a new report.

  (2) I'm trying to convert about 50 existing .rdl files to *.rdlc and migrate from SSRS to ReportViewer and not finding many cases, examples, documentation.

  Is there a utility to convert to .rdl to .rdlc for this ?

  (3) Report parameters: Can it dynamically code for the parms or do we have to code for each report individually as indicated on the same website mentioned above.

  These questions I have and many predecessors had also.

  Any ideas, references would be deeply appreciated

  Sincerely

  George Lewycky

  New York City

  george.lewycky@nyct.com

  Other useful links I found are:

  http://www.gotreportviewer.com/

  http://blog.jsmoot.com/2013/10/thinking-of-using-microsoft-reports.html

  http://www.cplusplusdevelop.com/1453_13106605/

  http://forums.asp.net/t/1078860.aspx

  https://msdn.microsoft.com/en-us/library/ms252073.aspx

  https://msdn.microsoft.com/en-us/library/ms252073%28d=printer%29.aspx

  http://blogs.msdn.com/b/sqlforum/archive/2011/04/28/sql-reporting-services-ssrs-bind-dynamic-dataset-to-your-local-report-with-reportviewer.aspx

  http://forum.finaquant.com/viewtopic.php?f=7&t=1236

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  November 4, 2015 at 5:22 pm

  #1837847

  The simplest answer for how to convert from RDL to RDLC is: rename.

  The content/structure of the file does not change, however the ReportViewer control does not "fetch" data for you, so any queries in the RDL will not be used.

  You can just rename the file from .RDL to .RDLC and then import it into your project (or store it somewhere that the web site can access at least).

  You need to supply a filled datasource to the ReportViewer which matches the dataset structure the report is designed to work with.

  I don't know about dynamically handling the parameters, sorry.

  I imagine you could query the RDLC directly as it is just an XML file.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]