Frank,

Quick and dirty way.. Build two database view, one returning top 1000 using the 
qualification you want, and the other returning all.. and point these views to 
two AR System view forms.. each for each kind of group..

Joe




________________________________
From: Frank Caruso <[email protected]>
To: [email protected]
Sent: Wed, April 28, 2010 1:14:41 PM
Subject: Limiting Queries

** Is there a way to limit the number records returned from user tool queries 
while at the same time allowing certain groups unlimited query capability?

I want to limit all users form returning more than 1000 records but at the time 
allow certain groups unlimited capability.

I know I can set a hard limit on the server but that would apply to everyone, 
including my nightly ODBC based reports, which return well over the 1000 record 
limit. I also know you can control this from the User tool but I cannot stop 
users from changing that value.

Thoughts?

Frank
(18 days left in the desert!)


_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_




_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Reply via email to