Tip #115 - How to ‘Subscribe’ to Reports

Tip #115 - How to ‘Subscribe’ to Reports [1]

With the Subscribe feature in SmartAdvocate, you can have any report automatically emailed to you (or to any valid email address) on a schedule you select. Here’s how:

Select a Report from the available list of reports on the top tool bar.

2. On the Report page, click the ‘Subscribe’ tab in the top right corner of the screen[2]

Figure 1 - Older Version of SQL

Figure 2 - Newer version of SQL

You will be presented with a list of available filters that will vary depending on the specific report selected. In the following example, we will use the ‘Critical Deadline Report’.

3. If you are using a newer version of SQL (See Figure 2), enter a description for your report.

4. Enter the appropriate email address(es) of the recipient(s) for the “To”, “Cc” and “Bcc” as appropriate.

5. Enter any appropriate text in the subject line or leave the default.

6. Enter the appropriate Report Parameters (Report Parameter Values). The options for the Report Parameter Values will vary depending on the specific report selected. In general, when subscribing to a report, you typically would want to use “Days From”, “Days To”, Days Forward”, and “Days Back” if those options are available. That way you can specify the number of days for your report rather than specific dates, since specific dates will always render a report that is inclusive of those dates only.

Figure 3 – Report Parameters, Older Version Of SQL

Figure 4 – Report Parameters, Newer Version of SQL

7. Click the “Select Schedule” or “Edit Schedule” button depending on your version of SQL.

8. Enter the schedule on which you want to receive your report and then click the “OK” or “Apply” button. The following example elects to receive the report weekly on Friday at 10:00 AM.

9. Click the “Create Subscription” button to start the subscription.

[1] Starting with the November 2020 release of SmartAdvocate, the ‘Subscribe’ feature has been renamed ‘Schedule this Report’.

[2] The page that is displayed in step 2 may look like Figure 1 or 2 depending on your version of SQL.