Adding New Reports
You can add new reports to those displayed by SQL Nexus simply by dropping them into the Reports subfolder under the SQL Nexus startup folder. The filename of each top-level report must have an extension of .RDL. Child reports must have an extension of .RDLC. This allows SQL Nexus to easily distinguish top-level reports from child reports.
If you have created a report with the wrong file extension in either the SQL Server Reporting Services report designer or the Visual Studio report designer, simply rename the file when you copy it into the SQL Nexus Reports folder. No functionality will be lost by changing the file’s extension. SQL Nexus fills in the gaps left by the Visual Studio client-side report viewer control.
DataSet references and database queries embedded in your report will be automatically resolved using the connection info you provided at startup. Any report parameters you defined using database queries will have their values set automatically using the embedded queries.
You can also add a report to those listed in the navigation pane by simply clicking the Open button on the main toolbar (or the Open option on the File menu). Open allows you to load any report you like into SQL Nexus. When you open a report this way, it will be automatically added to the navigation pane and removed when you close it. Once a report has been opened, you can perform all the same operations on it as any other report including exporting it and attaching it to an email.
You can design new reports using the report designer included with SQL Server Reporting Services or the one in Visual Studio. SSRS creates .RDL files; VS creates .RDLC files (the “C” stands for “client-side”). As mentioned above, change the file extension as appropriate before opening them with SQL Nexus.