Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2011-12-05 : 10:44:10
|
| Ok, now that we finally have our systems working together succesfully for our agent job which monitors db and table size, and compiles those results to a table, is there any way to script a mechanism by which we can export those table results to a pdf file? I would then put that in another agent job and clear the contents of the table collecting that data after the pdf is created.Bangers and Mash are neither "Bangers" nor "Mash". |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-05 : 11:32:17
|
| you can host a report which pulls the table contents in sql report server and then in a job render the report as a pdf.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2011-12-05 : 11:41:27
|
| is SSRS 2008 included in sql2008 r2 developer edition? I'm not finding it on my end.Bangers and Mash are neither "Bangers" nor "Mash". |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-05 : 11:43:00
|
quote:
Originally posted by WJHamel
is SSRS 2008 included in sql2008 r2 developer edition? I'm not finding it on my end.Bangers and Mash are neither "Bangers" nor "Mash".
you've to install it during installation time. It comes as Reporting services component------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2011-12-05 : 11:47:30
|
| thank you.Bangers and Mash are neither "Bangers" nor "Mash". |
|
|
|
consultor.dwh
Starting Member
6 Posts |
Posted - 2011-12-05 : 18:28:24
|
| You must create a SSRS report. Then, you must create a subscription to this report. In the suscription process you can define how to suscribe (copy report in a shared folder or send by email) and the desired format (pdf is one the options) |
|
|
|
|
|
|
Scripting table results to export as pdf?