Web Designer as SSRS - RDL Editor?

Web Designer as SSRS - RDL Editor?

Posted by: andy.beaulieu on 29 October 2018, 2:34 pm EST

• 

  andy.beaulieu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 October 2018, 2:34 pm EST

  We want to stick with using SSRS as our Reporting Server.

  But we are looking for a web-based designer for RDL’s.

  Is it possible to use the ActiveReports Web Designer in this way?

  • we would give the designer RDL to edit, and it would give back the RDL after editing.

  • we currently use 2016 schema of the RDL, and it would need to stay compatible with that.

  Is this possible? If so, can you point me to docs on that functionality?

  Thanks!

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 5:34 am EST

  Hello Andy,

  Thanks for showing the interest in ActiveReports.

  Actually, you can open and edit the RDL report using ActiveReport tools. However, it will change the report definition according to AR definition when you try to save the RDL report after making some changes.

  I recommend you to use ActiveReports Server instead of SSRS for report services. You can open the existing RDL report and save them with AR definition. It provides you with additional functionality to edit the report online.

  For more information and feature of ARS, you can refer to the following documentation link:
  
  https://www.grapecity.com/en/docs/platforms/activereports-12-server.

  You can use the trial version of ARS for evaluation purpose which can be downloaded from the following link:
  
  https://www.grapecity.com/en/download/activereports-server

  Also, you can request the demo for ARS to have more information regarding the ARS.

  Thanks

• 

  andy.beaulieu

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 8:42 am EST

  Thanks for the reply.

  Can you point me to any docs on how to import an existing SSRS RDL into ActiveReports?

  Is there a separate tool for this? I tried locally but it didn’t work, I’m probably missing something…

  • I set up ActiveReports 12 Server
  • I logged into the admin site at http://localhost:8080/admin/reports
  • I selected “Upload report” from the toolbar
  • I drag/dropped a few different existing SSRS RDL’s and selected “Upload”
  • the upload fails with the message “Cannot recognize report content.”

  Thanks!

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 8:50 am EST

  Hello Andy,

  Could you please share the one report as a sample for us to reproduce the issue at our end.

  Thanks,

• 

  andy.beaulieu

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 9:47 am EST

  Here is a really simple one, I just created this SSRS RDL using the Report Wizard in VS2017…

  RDLForImport_103018.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 10:21 am EST

  Hello Andy,

  I am able to reproduce the error at my end. However, when I changed the schema from

  <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily" MustUnderstand="df">
    <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>
  

  to

  <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  

  it uploaded successfully. It seems that ARS does not support the latest schema. I have escalated the issue to our developer team(Id 266518) and will update you once I get the information from them

  Thanks