Post reply

Crystal Reports and OLE_DB vs ODBC

  • July 15, 2008 at 12:44 am

    #842834

    Hi Qaseem,

    I have been caught multiple times with earlier Crystal Reports and when it first comands/SQL within the Page/Header/Footer begin and end sections. I normally tried to build a custom stored procedure that would return all the information in one hit and then create a simple wrapper report to make it look nice. Failing that you have to plan which SQL is fired in which section.

    I normally wrote it out on a piece of paper and plan which part of the report will be fired in which order.

    Sorry I could not offer much more help its been a while since I had to create reports in Crystal.

    Regards

    Richard...

    http://www.linkedin.com/in/gbd77rc

  • August 5, 2008 at 3:30 pm

    #853524

    Hello,

    I am running Crystal reports too with an OLE DB provider for SQL Server. I am having performance issues too..If anyone has any idea how to improve it in Crystal, please let me know. I have a sp running in SQl that Crystal uses to run the report along with some cascading paramters.

    Any help will be great!

    Thanks

  • August 6, 2008 at 7:16 am

    #853792

    I had to rewrite my query to improve it's performance, and once I did that, my problem was solved. However, I think there's a clear consensus that with Crystal Reports, you really need to specify your query as Command text, whether it's in a stored procedure or not. Anything else and you can get some really strange effects. My particular problem was solved, but I still don't really have an answer as to why there was such a phenomenal change in performance having ONLY changed the connection method. Despite the query not being optimized, it was still running very fast under SSMS, and seeing it run 17 times slower was pretty extraordinary, even considering that Crystal DOES do odd things from time to time. Anyway, all I can suggest is to ensure your query is specified by you and that it runs as quickly as possible within QA or SSMS - then, once fully optimized, you paste it into Crystal or wrap an SP around it and type in the EXEC statement.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 16 through 17 (of 17 total)

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