Publishing RDL Reports

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > RDL Reports >

Publishing RDL Reports

After designing RDL reports, they can be saved for re-use or shared with others. Two ways to share reports are described below. Regardless of the method used, the RDL report will appear as an available report in EQuIS Professional. When that report is opened, the Report Viewer will open in report mode, with a prompt to enter the desired input parameters (based on the underlying report defined in the RDL).


Publish RDL Report to Database


Only Database-Level Security (DLS) users or Application-Level Security (ALS) administrators may publish reports. ALS users who are not administrators may not publish a report. With appropriate permissions, a user can publish an RDL report to the EQuIS database using the normal report publishing process.


1. Click on Report in the Publish section of the Home Ribbon or click Publish in the report list in EQuIS Professional (top-right or Report Open Dialog) or right-click (in the
   whitespace, not on an existing report), and choose Publish Report(s).

2. Change the file type drop-down to RDL Reports (*.rdl).

3. Browse to the existing *.rdl file containing the RDL report and click Open.

4. Use the Report Publisher Form to check the report name and parameters before publishing the report.

5. Click Save in the Report Publisher Form to publish the RDL report to the database.


Be aware of the following when publishing RDL reports:


Publish only RDL reports that are designed as described here. Do not publish RDL reports that use native SQL queries.

The Dataset report(s) used in the RDL must already be published reports.

The values in ST_REPORT.REPORT_NAME and ST_REPORT.DISPLAY_NAME will be based on the name of the .rdl file. If this is the same as an existing report's display name, the file name must be changed before opening the report in the Report Publisher or change the Display Name in the New Report Column of the Report Publisher Form before publishing.

Reports designed on one database can be published to another database, but the JSON in the Dataset CommandText must be edited first to include only DisplayName - and DisplayName must match a published report in the target database (edit the JSON in a text editor so DataSet fields are not removed by the third party RDL editor application).




Publishing an RDL report to the database will make that report available in EQuIS Enterprise.

A user must have permission to the published RDL report in order to run that report, but does not need permission to the underlying Dataset report(s).


Save RDL Report to Facility's Work Folder


In some situations, you may not want to publish an RDL report to the database, but still want to run it as a standalone report. In this situation, save the *.rdl file for the report to facility's work folder (e.g. My Documents\My EQuIS Work\database name\facility name). When a facility is opened in EQuIS Professional, it will scan the facility's work folder and display any *.rdl files on the list of available reports.


Be aware of the following when saving RDL reports to your facility's work folder.


The Dataset report(s) used in the RDL must already be published reports.

This method will not make the report available in EQuIS Enterprise. The RDL report must be published to the database first (see above) in order to use it in EQuIS Enterprise.

Anyone with access to the facility's work folder (e.g. if the folder is on a network share) will have access to your RDL report.