ReportServer

I want to create ReportServer which processes crystal report and sybase database using c#. Particulary this report server

get parameters from user and process this report send it back to user additional also send email,print,ftp etc... Also report server should be able to schedule reports as per user request.

Does microsoft gives any classes /services to start programming for this? Any suggestion or Any Idea ?

thanks for looking into this..

Out of the box .NET supports SQL Server and Crystal Reports. I don't know about Sybase. For SQL .NET has builtin support for displaying reports in WinForms or WebForms (Microsoft.Reporting). CR does the same thing (CrystalDecisions.Web) but they are in no way related.

In projects past if my app had to support multiple reporting subsystems then I created a generalized reporting manager with abstract report and parameter classes from which I derived specific types for SQL, CR or whatever. This is a lot of work and you are ultimately tied to the LCM of the reports. For example if Sybase doesn't support scheduling then you can't do it irrelevant of what your interface exposes. Therefore you must either target the LCM or do some sort of "Supports feature X" system to allow the generalized components to play nice together.

Michael Taylor - 9/14/07

http://p3net.mvps.org

|||what is LCM ?|||

Least Common Multiple. In the context of this discussion the list of features shared by all reporting types (such as types, parameter options, etc).

Michael Taylor - 9/25/07

http://p3net.mvps.org

|||

thanks for your reply.

I am now planning to write my own report manager. Because i tried "Crystal Report Server" , but it has limitation with features what I need

I am planning to write report manager which supports

- View /print/mail/ftp reports

- also schedule a job which containts bunch of reports with predefined parametes

- most important we also want to put user request in queue if other user is has submitted request for this report. this

type of reports take long time and may cause dead lock on database.

again thanks for your time

sql