Avatar of jspc
jspc
Flag 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
Crystal Reports

Avatar of undefined
Last Comment
Ido Millet

8/22/2022 - Mon
Peter Chan

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

ASKER
I don't understand what you mean
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
jspc

ASKER
Yes it is a view.
ASKER CERTIFIED SOLUTION
Ido Millet

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.