Blue_Dog_Jones
asked on
Limiting records in Crystal Reports
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?
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?
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
MikeV
select TOP 1000 *
FROM yourdb.table
MikeV
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are other ways but this would be the quickest....