Solved

Speed Up Crystal Report

Posted on 2016-09-01
5
55 Views
Last Modified: 2016-09-01
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
0
Comment
Question by:jspc
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

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

Author Comment

by:jspc
ID: 41779468
I don't understand what you mean
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 41779587
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.
0
 

Author Comment

by:jspc
ID: 41779603
Yes it is a view.
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 41779608
Then pursue that issue.  You can start by asking the DBA to find out how long it takes that VIEW to run. If that is indeed the issue, you could consider materializing it.
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question