Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Database Reports

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-25 : 07:39:58
Mayoor writes "I have been asked to produce reports which will be triggered and generated automatically via scheduled tasks against data in SQL SERVER.

The reports will be generated as CSV's to provide compatibility with Excel.

The reports will then e-mailed as attatchments to an agreed list of recipients.

This all has to be done with the use of ASP and SQL Server.

Can anyone advise on how the prolem should be approached?

Mayoor"

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-02-25 : 08:02:50
Have you investigated using Reporting Services (assuming you are running SQL 2000)?


Raymond
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-02-25 : 08:21:55
I agree with Raymond, Sounds like the perfect project for Reporting Services.
I went to the Sydney demo of it tonight, looks like an awesome product.


Damian
Go to Top of Page
   

- Advertisement -