Interesting subscription question...I could use some brainstorming help -- sql server reporting services

kimcheebowl
6/6/2006 11:14:49 AM

I have a report that needs to be emailed to 40 diffferent technicians.
Each tehnician handles a different US region so the report will be
driven via a parameter (most likely a technician ID). We don't want
other technicians seeing data for someone elses region. This all has
to be automated, no user interaction with this report other than each
technician getting an email with his/her data (based on his/her
results).

What would be the best way to handle this with a subscription?

kimcheebowl
6/6/2006 11:30:04 AM

I do know that this will have to be a data-driven subscription. Is it
possible for the value in a data driven query be used as a parameter in
the report??

[quoted text, click to view]

Matt
6/7/2006 5:03:17 AM

Absolutely - DDS will be just what the doctor ordered. You will need
to feed the parameter values into a table for the DDS to pull from. I
use both Access DB and Excel spreadsheet uploads to upload subscription
parameters into a SQL Server table, which is then used by the DDS.

Matt A

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Interesting subscription question...I could use some brainstorming help