Link to home
Start Free TrialLog in
Avatar of ammartahir1978
ammartahir1978Flag for United Kingdom of Great Britain and Northern Ireland

asked on

how to automate reports

hi Guys,

is there any script available through which i can create a report and then automatically convert it to PDF and email accross to users.

i will be creating reports in SQL server.

Thank you
Avatar of TempDBA
TempDBA
Flag of India image

You mean to say reports like selecting data in Management studio or creating a proper report in sql server reporting service. IF it is latter, you can simply create subscription and choose to send the rendered report on a schedule time to the subscribers. One of the rendered format is pdf too.
Avatar of ammartahir1978

ASKER

Thank you TempDB for you response

But what I am saying is like weekly sales report right now I am runnin it manually and then converting them to pDF and sending it out but what I ideally like is every week this report run on a specific time and then get converted to PDF and self emailed to reciept users
by report what kind of report you wanted to say. Can you please clarify it?
Whether it is a crystal report, SSRS or just running a query and then creating a pdf with the data only(manually).
i have a SQL server i want to create a report for example

select * from sales
where date between ATOMATIC DATE and AUTOMATC DATE
order by store

where automatic date will be the last week date which should automatically passed to this query once thats run then report should get converted to PDF and emailed across
If you have reporting service installed, you can do it easily with SSRS by creating .rdl file.
Or else you can use any programming language to get the data from server and then create a pdf for the fetched resutl.
Avatar of vasto
You can use a SQLServer job. Check here how to create one : http://msdn.microsoft.com/en-us/library/ms190268.aspx
You can use also use SSIS but this require some learning curve.

There are third party tools that you can use too:
Report genie - basic but free: http://download.cnet.com/Report-Genie/3000-2064_4-10555178.html

R-Tag report manager - advanced and paid : http://r-tag.com/ReportManager.aspx
There is a free version with limitations . I am linked to this company

If it is something temporarily or for personal use I would use SQlServer job.
If you need some advanced  options like to keep history of the reports, share them on the local network, SharePoint, combine them with other reports I would use R-Tag manager or SSIS
R-Tag report manager will allow other users to run the queries too since it provides a viewer.
ASKER CERTIFIED SOLUTION
Avatar of vasto
vasto
Flag of United States of America 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
thank you Vasto that is great
excellent