Solved

Speed Up Crystal Report

Posted on 2016-09-01
5
38 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
Comment Utility
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
Comment Utility
I don't understand what you mean
0
 
LVL 22

Expert Comment

by:Ido Millet
Comment Utility
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
Comment Utility
Yes it is a view.
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now