Going to replace Crystal Reports with SQL Reports?

[ragstta]

Morning all

We've had enough of crystal reports on our application and are considering replacing it with SQL Reports. Dont know too much about SQL Reports but we do the following with Crystal:

- Sub reports which work from filters derived from Detail records on parent report.
- Use the same report fiiles used in the windows enviroment in a web environemnt.
- Use stored procedures as well as tables.
- Have conditional code to control the presentation of the report.
- Embed reports into a Windows VB.net application using a report Viewer.
- Display reports inside a windows app.
- Report Save to PDF
- Report Save to CSV
- Report Save to Excel
- Report Save to RTF
- Auto generate the report so that we can email a file (in the formats listed above).

Will SQL Reports Provide the same functionality?

Thanks in advance

[Merrion]

Yes -reports can have subreports and images and whatnot

Yes - reports can be rendered as XML, PDF, CSV, Excel

In fact I think you can do all your requirements and more with SQL Server Reporting Service.

[ragstta]

Thanks Merrion, Those links are super!
Cheers
Bud

is page breaking available eg
for every customer page break>?