Running Reports

 

When it starts up, SQL Nexus identifies the top-level reports in its Reports subfolder and lists them in the navigation pane on the left.  It distinguishes between top-level and child reports vai the file extension.  Top-level reports have a file extension of .RDL; child reports use .RDLC.

 

To run a report in SQL Nexus, simply click it in the navigation pane on the left.  If the report has already been opened this session, it will display instantly.  If not, SQL Nexus will run the database queries that provide its data and render it in the report pane in the center of the screen.  This may take a few seconds, and you will be able to perform other tasks while the report itself renders (you will see a spinning progress indicator in the report viewer pane while the report is being rendered).

 

If you wish to refresh a report that is current open, click the Refresh button on the report toolbar.

 

If the report you are viewing support user-definable parameters, click the Parameters button on the Report toolbar to set them.  SQL Nexus will provide an easy-to-use grid in which you can enter each parameter or select its value from a list of allowed values.

 

If the report contains links to other reports, click them to view the corresponding child reports.  Press the Back button on the report toolbar to return to the parent report.  Hold down the Control key when clicking a child report to view it in a separate window.  Note that subreports will always be rendered in the current window, but child reports can be viewed in the current window or in a separate one.

 

Once you have finished with a report, you can right-click it and select Close from the pop-up menu in order to close it.  You can also select Close all but this to close all reports except the one you are currently viewing and Close all to close all report windows.