Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

crystal report issue..?

Posted on 2006-05-26
12
Medium Priority
?
173 Views
Last Modified: 2010-04-17
i was using crystal report 8.5, vb6.0, sql server 2000... for some maybe it sounds funny... i was using the stored procedure as the source of my report but it tooks a lot of time to generate the report... in short it is very slow...

... any idea on how can i make the report to generate more faster...

... thanks in advanced...
0
Comment
Question by:JackOfPH
  • 6
  • 6
12 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 16777499
Speed of the report is based on many things.

Does the report have formulas?

Do you do any filtering?

How many records are returned?

Does the report have subreports?

mlmcc
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16781478
some of my reports have formulas, have filtering...

why does when i am using the access the reports generates faster compared when i
was using SQL database?

regards,
JackOfPH
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16781483
do i nid some codes to write on my query before loading my reports?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 101

Expert Comment

by:mlmcc
ID: 16781710
What kind of code?

Is the Access database on your machine?

mlmcc
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16783193
no i was using SQL Server 2000 as my database....

what should i do to make the report generation more faster
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 16783648
How are you filtering the data?

Do all reports generate slowly?

mlmcc
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16786955
not all reports... but some of the reports especially those which connected to stored procedure...
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 16787117
Is the stored procedure long?

mlmcc
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16787639
some of it.
0
 
LVL 15

Author Comment

by:JackOfPH
ID: 16787644
do you have any code to make it more faster?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 16795252
No.  Will the stored procedure return the records you need or does the report also filter the records?

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 16795609
Glad i could help

mlmcc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Make the most of your online learning experience.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Screencast - Getting to Know the Pipeline

581 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