[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 88
  • Last Modified:

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
0
jspc
Asked:
jspc
  • 2
  • 2
1 Solution
 
HuaMinChenSystem managerCommented:
You have to ensure the query is running fast against the database, by ensuring that you're matching the tables with proper indices.
0
 
jspcAuthor Commented:
I don't understand what you mean
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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
 
jspcAuthor Commented:
Yes it is a view.
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now