Avatar of TAB8
TAB8
Flag for New Zealand asked on

Run .RDL and produce .pdf using t-sql

What I want to do is create a scheduled SQL Agent job to run a .rdl report pdf it and then I can email it out

Microsoft SQL ServerDB Reporting Tools

Avatar of undefined
Last Comment
TAB8

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rob Farley

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
shorak

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rob Farley

Hi Shorak,

I got the impression it had to be done using RDL that wasn't yet deployed.

...But otherwise yes, subs would be more useful.

Rob
TAB8

ASKER
Hi Shorak, I had thought of that but I dont want to have to install reporting services on the server hence the use of the .rls.   I was thinking I might just have to redo this as an HTML export.

Its just so easy in the gui to right click and export as a .pdf

thought someone might have a way to do this in T-Sql
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes