Link to home
Start Free TrialLog in
Avatar of TAB8
TAB8Flag 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

ASKER CERTIFIED SOLUTION
Avatar of Rob Farley
Rob Farley
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of 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