Dashboard

[ypatel (Yash Patel)]

Is there a way to automatically email a dashboard at a certain time daily as a Excel file?

[knash (Ken Nash)]

This would be a BAQ Report.

[ypatel (Yash Patel)]

So would I need to recreate an SSRS Report in the designer or can I use an existing dashboard?

[knash (Ken Nash)]

Yup would have to create a SSRS Report. Check out the ICETOOLs_UserGuide pdf.

There should be a chapter on BAQ Report Designer which show you how to “Use the BAQ Report Designer to turn a Business Activity Query (BAQ) into a SQL Server Reporting Services (SSRS) report.”

[ypatel (Yash Patel)]

After the SSRS Report has been created and uploaded back in, how do I tell it to email daily?

[knash (Ken Nash)]

you will have to run the report.

Then set the schedule to what you want, and then set the email and what not.

[ypatel (Yash Patel)]

How do I add additional schedule times? I only have Now, Daily Midnight, Daily 4:00am

[hmwillett (Hannah Willett)]

[BHiggins (Brenda Higgins)]

You are awesome Aaron!