Customer #: Your customer number is provided by ChristianSteven when you register for support (Free during the 30 Day trial period) or buy the software. Technical support is only provided to registered users. Licensed users are automatically registered for support, but evaluation users have to register for support to obtain a customer number. Enter your customer number here when you have received it from ChristianSteven. This will also stop SQL-RD from prompting you to register.
Automatically refresh desktop: When viewing the SQL-RD desktop (especially when using "Detail" view) this option will refresh the screen every x seconds. So you can see an up to date status of your schedules at a glance without having to refresh the system manually.
Only convert remote paths to UNC: This setting instructs SQL-RD to only convert remote paths to UNC. This helps prevent any path resolution problems you may otherwise have. Local paths are not affected if you are a system administrator.
Use the Process Watcher for manual executions: This setting instructs SQL-RD to use the Process Watcher for manual executions.
Use Relative Time: This setting lets you select whether timings should be displayed and saved in the time zone of the scheduler or the time zone of the user (if they are different).
Send an Email: Choose to be notified by email if a report fails to run successfully.
Send an SMS: Choose to receive an SMS text message on your cellphone if a report fails to run successfully.
An error log file is stored in the installation folder (typically, Program Files\Christiansteven\SQL-RD). You can also view the log file from the System Monitor.
Sync User Defaults across All clients: User default settings applied here will apply to all connected SQL-RD client installations.
Compacting the System *: SQL-RD stores the schedule information and all your settings locally in an MS Access database. Access databases can grow very quickly, most of it consisting of empty unused space. When your database size exceeds 50 MB, SQL-RD will prompt you to "Compact the system". The compacting process reduces the size of the database, and re-indexes the records, repairing any corrupted records in the process. Uncheck the option if you do not want SQL-RD to prompt you.
The compacting process requires that no other applications are using the access database e.g. the SQL-RD scheduling services. SQL-RD will close down any applications including the scheduling service and the editor whilst performing this process.
For Advanced users:
You may manually compact and re-index the database directly in MS Access 2000 or above. Here's what to do:
Ensure that the database is not in use by the SQL-RD Editor, the schedulers or anything else.
Open Program Files\SQL-RD\SQL-RDLive.dat with MS Access.
In MS Access, go to Tools - Database Utilities and select "Compact and Repair"
* Only if you are using File System (Default). When using SQL or ODBC compliant database, this functionality will have no effect, and you should use the maintenance and housekeeping tools in your database to re-index and compact the database as and when it is necessary.
Pre-caching of reports: Pre-caching is effective when there are multiple destinations in a single schedule. When switched on the report is exported once and then SQL-RD works on the result locally to produce the various formats required by the different destinations.
If it is switched off, the report will be exported multiple times, once for each destination format. If your report is resource-hungry then this could cause a high load on your database server and network.
If your report takes a long time to complete e.g. 1hr, then the second and third destinations could end up having different data if the database was updated during that time. Switching on Pre-Caching ensures that all destinations receive identical data in their report.
Show Hidden Parameters: SSRS report parameters will be displayed in SQL-RD even if they are hidden.