How do I setup Default Destinations in SQL-RD?

Default destinations are destinations which can be reused each time you create a schedule (without having to enter the same destination information over and over again).

Options - Default Destinations

  • Go to Options.
SSRS. SQL-RD Home Menu
  • Select Default Destinations.
SSRS. Default Destinations in Option section in SQL-RD

Adding a Default Destination

To add a Default Destination, perform the following:

  • Click Add.
SSRS. Default Destinations in Option section in SQL-RD
SSRS. Adding a destination in SQL-RD
  • Enter the name you wish the destination to be called, click OK on the Destination window. Then, click Apply.
SSRS. Email Destination in SQL-RD

SSRS. Default Destinations in Option section in SQL-RD
  • The Default Destination has been successfully created.

Using a Default Destination

To add the Default Destination to a schedule, perform the following:

  • Navigate to the Destinations tab of the Schedule Properties and click Import.
SSRS. Default Destinations in Option section in SQL-RD
  • Select the Default Destination you wish to use and click OK.
SSRS. Select Destination for Testing in SQL-RD
  • Click Apply.
SSRS. Destination Wizard in a Report Schedule Properties in SQL-RD

This report will now use the specified default destination without the need to set up the destination specifics.

Testing Using a Default Destination

One of the features of SQL-RD is the ability to set up specific default destinations for testing purposes (such as a test folder on the server's C: drive or a testing e-mail address).

To test a schedule using a default destination instead of the schedule's actual destination, perform the following:

  • Right-click on the schedule you wish to test.
  • Click Tools. Then, click Test.
SSRS. Report Schedule Context Menu (Test) in SQL-RD
  • Click the destination you wish to use from the list of Default Destinations that pops up. Then, click OK.
SSRS. Select Destination for Testing in SQL-RD
  • Once you click OK, the schedule will automatically execute to the test destination, and you will receive a success or failure message.

Sharing Default Destinations

  • Default Destinations can be assigned to specified user groups. These groups are created in the User Manager. If you want to "pre-make" a destination so that a certain group of users can only have schedules export to that location, you can find how to assign them that default destination.