Link to home
Start Free TrialLog in
Avatar of jspc
jspcFlag for Australia

asked on

Speed Up Crystal Report

Hello,

I have a Product Value Report as at date which I run on my SQL Database (via my accounting software) which gives me the location value of stock as at a date.  

One issue I have with the report is that the more transactions and warehouses you have in the database the longer the time taken to produce the report.

I’m wondering if anyone would know how to speed up the report for me if possible?

Attached is an example with saved data.

Thank you.
QuantityValuebyLocationAsAt.rpt
Avatar of Peter Chan
Peter Chan
Flag of Hong Kong image

You have to ensure the query is running fast against the database, by ensuring that you're matching the tables with proper indices.
Avatar of jspc

ASKER

I don't understand what you mean
Avatar of Ido Millet
What is gProductAsAtDate -- a snapshot table or a VIEW that has to do a lot of heavy lifting before it can return the data? If it's a VIEW, you could automate the process of periodically materializing it to a snapshot table in order to speed up the report.
Avatar of jspc

ASKER

Yes it is a view.
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial