Limiting records in Crystal Reports

Posted on 2007-10-12
Last Modified: 2012-05-05
I am new to Crystal Reports.

I am building a report and it looks at 3 million records. Is there a way to limit the search results of CR? When I make a change to the layout or a field, I do not want to wait till CR runs through a seach of so many records. Is there a way to limit the number of results CR will bring back or a way to limit how many records CR will look at?

Question by:Blue_Dog_Jones
    LVL 17

    Expert Comment

    Go to SELECT EXPERT...and choose a field...then set your limitation there...

    There are other ways but this would be the quickest....
    LVL 17

    Expert Comment

    PIck a DATE..or a someother field...OR...if you can write a SQL statement that has the TOP 1000 or whatever at the beginning.

    select TOP 1000 *
    FROM yourdb.table

    LVL 42

    Accepted Solution

    If you don't want to mess with your existing selection criteria, you can use File -> Save Data with Report so Crystal doesn't reload every time (don't forget to turn it off when you're finished editing).

    Another option while the report is reloading you can click the STOP button (small square) near the upper right corner to stop reading in records.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    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…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 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