SOLVED

Automated Issue of SSRS Report to Users from Project Server

%3CLINGO-SUB%20id%3D%22lingo-sub-2752212%22%20slang%3D%22en-US%22%3EAutomated%20Issue%20of%20SSRS%20Report%20to%20Users%20from%20Project%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752212%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20SSRS%20Highlight%20Report%20(HLR)%20that%20sits%20outside%20of%20Project%20Server%2C%20but%20is%20populated%20with%20information%20from%20project%20plan%2C%20custom%20field%2C%20risks%2C%20issues%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20automate%20the%20issuing%20of%20a%20project's%20HLR%20in%20pdf%20format%2C%20to%20a%20set%20list%20of%20recipients%3F%3C%2FP%3E%3CP%3EThe%20names%20of%20recipients%20would%20be%20taken%20from%20the%20Project%20Site's%20'Key%20Contacts'%20list%20(although%20am%20open%20to%20suggestions%20of%20an%20alternate%20AD%20field%20list).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVague%20request%20I%20know%2C%20just%20looking%20into%20it%20even%20being%20a%20possibility%20before%20spending%20time%20detailing%20requirements.%26nbsp%3B%20Thanks%20in%20advance%2C.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

We have an SSRS Highlight Report (HLR) that sits outside of Project Server, but is populated with information from project plan, custom field, risks, issues etc. 

Is it possible to automate the issuing of a project's HLR in pdf format, to a set list of recipients?

The names of recipients would be taken from the Project Site's 'Key Contacts' list (although am open to suggestions of an alternate AD field list).

 

Vague request I know, just looking into it even being a possibility before spending time detailing requirements.  Thanks in advance,.

2 Replies
best response confirmed by APS1979 (New Contributor)
Solution

Hello @APS1979 ,

This should be possible, take a look at SSRS data driven subsciptons: https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions?view...

Paul

thanks for the quick reply Paul, very much appreciated.