Post reply

SQL Server Reporting Services vs Crystal Reports

  • August 11, 2004 at 8:01 pm

    #161307

    I don't have any experience with SQL Server Reporting services.

    I only worked with Crystal Reports 8/9.

    At my new work project manager wants me to

    build an interface for reporting system using

    SQL Server 2000 Reporting Services?

    Is it better than Crystal Reports, worse? What are the limitations and benefits?

    Thanks,

  • August 12, 2004 at 3:15 am

    #518623

    there is a web cast that you can view at http://www.microsoft.com/sql/reporting

    this shows how easy it is to create and distribute reports, although it's a bit cheesy for my liking.

    crystal reports is very flaky and crashes at the slightest thing.

    are you distributing over the web? if so then using crystal 8.5 you get free liscences for crystal enterprise (the web delivery system) which is pretty easy to set up and configure.

    also with SQL reporting you have to have Visual studio installed on your pc in order to create reports..... not so for crystal.

    MVDBA

  • August 12, 2004 at 7:55 am

    #518667

    Mike,

    Thank you for your response.

    This is going to be on the Web.

    And I have Visual Studio.Net installed on my PC.

    I also have SQL Server 2000 (server) on my machine.

    How do I setup everything?

    After I install Reporting Service

    it will be available in my Visual Studio.NET?

    Thanks in advance.

    Robert O.

  • August 12, 2004 at 8:06 am

    #518675

    have a look at

    http://www.microsoft.com/sql/reporting/productinfo/RS_AuthoringDemo.asp

    you will see how it's done

    but yes, a new project type is available - SQL report

    are you planning to write all of the reports yourself? that's the benefit of crystal, you can install (the fairly easy to use) crystal reports onto a business users desktop and collect the report files in and publish them.

    MVDBA

  • August 12, 2004 at 8:14 am

    #518679

    As far as I know, yes.

    I will have to write (design) the reports myself.

    There is an application Microwebs II running on web servers.

    Then IIS Log Agent collects and does some grouping,filtering to the data (number of hits by application,country,page). Then this data is being stored at the SQL Server 2000 database and then I have to build my reports based on the data in that database. The reports have to be accessible on the web.

    Thanks,

    Robert O.

  • August 13, 2004 at 6:42 am

    #518843

    caution...

    today you can only use one data provider each report in sql server reporting services. this is not business-intelligence. use chrystal, better businessobjects.

    peter

  • August 14, 2004 at 2:57 pm

    #519002

    Hi Peter,

    Do you mean I can't access two different databases in one report? That's fine. I won't need it.

  • August 15, 2004 at 6:07 pm

    #519020

    What do you mean by "only use one data provider", I've got a couple of reports that reference different databases both in SQL Server and Progress via ODBC.

    One report in particular has 4 datasets, 2 from SQL Server and 2 from Progress.

    --------------------
    Colt 45 - the original point and click interface

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply