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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to restrict # of recordes

Status
Not open for further replies.
yuli1104

yuli1104

Programmer
Feb 20, 2002
60
CA
HI,
Does anybody know how to restrict # of records from your query ? for example, you only want 5 records displayed from your query.
Thanks for any possible help

Yuli
 
Sort by date Sort by votes
Hi,
If ur Crystal Report is using a query, Replace it with a procedure and use Set Rowcount 5 in ur s.Proc

Regards,
Shuchi
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jbeggie
  • Locked
  • Question
How Do I Clear a Bounded form in VBA?
Replies
0
Views
280
jbeggie
jbeggie
razorii
  • Locked
  • Question
Help adding a field to a current report
Replies
1
Views
285
BobRodes
BobRodes
akneeta01
  • Locked
  • Question
Equivalent of MTS Remote components in COM+
Replies
0
Views
290
akneeta01
akneeta01
gust1480
  • Locked
  • Question
Method '~' of object '~' failed
Replies
2
Views
319
VBrit
VBrit
DaBearCubbies
  • Locked
  • Question
MTS To a new Domain
Replies
0
Views
153
DaBearCubbies
DaBearCubbies

Part and Inventory Search

Sponsor

Back
Top