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. Top-level reports must have a .RDL file extention. Child reports (reports that are only accessible from drill-through from another report) should have a .RDLC extension. Top-level reports will be visible in the report list, while child reports will not be directly launchable from this list. If you have created a child report with a file extension of .RDL using the SQL Server Reporting Services report designer, simply rename the file to .RDLC 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; Visual Studio creates .RDLC files. They are very similar and SQL Nexus will work with both types. However, .RDLC reports created in Visual Studio have several notable limitations that make authoring a report more challenging, so you may wish to use Reporting Services and create .RDL reports.