Hi, I am starting to work with huge databases. While creating the report I don't need Crystal to pull all the records in the table (for speed sake). I need to know how to limit the amount of records it pulls into the report. Is there somewhere I can limit the amount of records it pulls down? Then when I am confident that the report is the way I want it, I can change it back to pull all records? Thank you, Pam
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Limiting records
- Thread starter PFerrasci
- Start date
synapsevampire
Programmer
I'd suggest using a record selection criteria which limits rows based on a date as in the following example
From 'Report', select 'Edit Selection Formula', and then select 'Record'.
{MyTable.MyDate} > currentdate-7
to get the last weeks worth of data.
-k
kai@informeddatadecisions.com
From 'Report', select 'Edit Selection Formula', and then select 'Record'.
{MyTable.MyDate} > currentdate-7
to get the last weeks worth of data.
-k
kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question