Limiting records in Crystal Reports

Posted on 2007-10-12
Medium Priority
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
  • 2
LVL 17

Expert Comment

ID: 20065637
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

ID: 20065684
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

frodoman earned 150 total points
ID: 20066214
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.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

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. …
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

809 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