ASP.NET Reporting

AndyBrew70

Hi After 3 years of bodging our reporting requirements with anything and everything from HTML browser based reports to Tall PDF based reports, and a brief flirtation with ComponentOne's reporting engine we have now decided to attempt to solve this issue once and for all LOL!!! Anyway we have some very complex reports, some include charts intermingled with tabular data, some require the titles to be displayed vertically etc. and then more simple mail merge type requirements so a good varied range of reporting styles and layouts. So what are peoples opinions, what are peoples experiences of different tools, anybody used Crystal Reports?? Suggestions please, all help greatly appreciated it looks like a mine field out there everybody claims the earth but little has delivered to date! Thanks in advance Andy

Michael Sync

I used to use SQL reporting Service in ASP.NET project..

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

AndyBrew70

Is this SQL 2005 specific?

Michael Sync

Nope.. It can be used with SQL 2000..

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

AndyBrew70

thanks for your feedback Michael much appreciated :) can I build reports in the SQL 2005 environmentand then migrate them to SQL 2000, do you know? does SQL EXPRESS 2005 support trport services? thanks in advance Andy

pmarfleet

A point of clarification should be made regarding the relationship between SQL Server and SSRS. Reports developed using SSRS can link to a variety of data sources. These include SQL Server, Oracle, any ODBC-compliant data source and XML. This means that the data for your reports doesn't need to be stored in SQL Server. However SSRS requires an instance of SQL Server to be installed as it stores the metadata for its report catalog in a SQL Server database. This can be either SQL 2000 or SQL 2005.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Michael Sync

AndyBrew70 wrote:

can I build reports in the SQL 2005 environmentand then migrate them to SQL 2000, do you know?

downgrading? I wonder why you want to do like that. I never try before..

AndyBrew70 wrote:

trport services

I'm not so sure what you meat by trport service.

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)