Hi, You can make a filter with 2 set field actions: - the 1st one is just setting a dummy field with the result of the query you want to count the results - the 2nd one uses the $LASTCOUNT$ keyword
or you use a set field with SQL source, and write a query like SELECT COUNT(Field1) FROM table_Name WHERE query Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 17:41, Raj wrote: > Hi All, > Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields > action of a Filter on Submit. Seems is it not working. Always setting > the field to a constant value of 15. > Would like to set the field with the number of rows in that particular > table. Is the any other way around to do this? > How can it be done with the help of Direct SQL ? > > Please advise. > Thanks, > Ravi > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > 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"
