I have a SQL Database from which I need to create reports daily, weekly and monthly. I am thinking of Creating Crystal Reports Manually so That I can execute that particular function periodically using a timer. Would this be a good approach or is there any other way in which I can do so? An example would be greatly appreciated... Thanks in advance.
Asked
Active
Viewed 394 times
0
-
What version of SQL are you using? If you are using SQL Server 2008 or later, you can use SQL Server Reporting Services. – LittleBobbyTables - Au Revoir Jul 17 '12 at 17:49
-
You can do this with Crystal Reports. Are the reports already built or are you starting fresh? – Buck Hicks Jul 19 '12 at 00:23
1 Answers
2
I know you asked for Crystal Reports, but assuming you have SQL Server 2008 Reporting Services installed, you can create reports that way and not have to get a second software package.
Both Microsoft Technet ("How to: Schedule Report and Subscription Processing (Reporting Services in SharePoint Integrated Mode") and Code Snippets ("SSRS: Scheduling Reports Using SQL Server Reporting Services 2008") have some examples of scheduling reports.

LittleBobbyTables - Au Revoir
- 32,008
- 25
- 109
- 114