Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: how to report more fast ??? i used crystal report 8.5

    how to report more fast ???
    i used crystal report 8.5
    report from VB ...
    it's very slowly .... if records about > 50,000
    is there any method or function make it run more fast .... or another way to do this ....

    please tell me

    thanks alot .....

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Have you checked to make sure your indexes are set properly? When you do this same report from QA is it faster?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: how to report more fast ??? i used crystal report 8.5

    Originally posted by brain_os
    how to report more fast ???
    i used crystal report 8.5
    report from VB ...
    it's very slowly .... if records about > 50,000
    is there any method or function make it run more fast .... or another way to do this ....

    please tell me

    thanks alot .....
    I was using crystal reports a lot and could say that it works fast if you use fast stored procedures. Do not use subreports - it works slowly.

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I agree with that Snail, they could really do some improvements on the performance of their sub-reports, that is one reason I am looking forward to Microsoft's reporting services software.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    Interseting,Microsoft is coming out with a reporting service software?
    Where can I look up in the net for some info on this?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  6. #6
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    There is a lot of info out on it, I spoke to an UNNAMED SQL Server MVP and he told me that inside Microsoft they are calling it the "Crystal Killer", hehe

    Here are a couple links

    http://www.microsoft.com/sql/evaluat...ngservices.asp

    http://www.microsoft.com/technet/tre...ql/sql0625.asp
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •