January 22, 2014 at 5:56 am
Hi Guys,
I think iam missing out on something.
I made an tsql with some results i want.
Put them into RDL with a nice layout.
So far everything works. But i have trouble to get those results to pdf on an daily base without manually kicking it off.
I set already mail up on the sql and that works.
What i miss is how to get those results into an PDF and send it trough mail to people.
If SSIS isn't the best method please let me know. thanks all for your help.
January 22, 2014 at 6:20 am
Add a subscription to the report on the Reporting Services server
Far away is close at hand in the images of elsewhere.
Anon.
January 22, 2014 at 6:27 am
I might feel dumb now but how do i do this on the reporting server?
Sorry again.. but if i dont ask i get never smarter 🙂
Much appreciate your time.
January 22, 2014 at 7:04 am
OK my bad, not actually on the server itself.
Use browser to connect to reporting services, ie http://servername/Reports/Pages/Folder.aspx
Select folder containing report
Open Menu (click on down arrow in yellow box)
Click on Manage (left hand side)
Click on Subscriptions
Click on New Subscription
Far away is close at hand in the images of elsewhere.
Anon.
January 22, 2014 at 7:45 am
Thanks again..
I got an step further now.
But i got an message "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid."
Again learning a bit more everytime. starting to like this.
Its real nice to see people help.
Regards.
January 22, 2014 at 8:00 am
The easiest way to deal with this issue is to go to the data source folder in the report manager, open your data source and put in credentials. We use a service account that has the appropriate permissions for all reporting but you can really use any account. Be aware that if you use an account where policy requires periodic password changes your subscription will fail after a change unless you remember to update the credentials in your data source.
January 22, 2014 at 8:01 am
You need to go back to Manage the report and choose Data Sources.
Provide the necessary credentials to run the report, (ie it cannot be set to Credentials supplied by the user running the report)
If the report uses a shared data source then you need to change the shared data source properties instead (or change to custom data source)
Far away is close at hand in the images of elsewhere.
Anon.
January 23, 2014 at 12:22 am
thanks guys for the help.
I got it to work. now its all fine tuning the results.
It was indeed the login i had to adjust after that it worked.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply