0

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.

Shehan Tis
  • 177
  • 2
  • 13

1 Answers1

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