SQL Server Performance

Totals - Sql Statement or in Crystal Reports?

Discussion in 'SQL Server Reporting Services' started by vbjohn, Jan 12, 2007.

  1. vbjohn New Member

    Which is the best method of generating totals? On the Server in an SQL Statement or In Crystal Reports? Is there any reasons for one or the other?


    thanks.
  2. vbjohn New Member

    Found it.....

    It is best to have the server do all the work instead of crystal.
    Reason:
    1.) Less time connected to the server
    2.) Less memory needed to process the report on the PC
    3.) Lower transfer time from the server to the client.
  3. backborn New Member

    Hi,

    It is best to use RAQ Report to do all the work instead of Crystal Report.
    Reason:
    1.) Cross-platform
    2.) Faster
    3.) More convienent
    More information at www.raqsoft.com

Share This Page