I apologize for my error in my previous email. I just realized I helped you to colsum and not colcount.. I read and posted it in a hurry..
Joe ________________________________ From: Ravi <[email protected]> To: [email protected] Sent: Mon, May 10, 2010 12:48:24 PM Subject: Re: COLCOUNT not working ** So, if I use the first way you mentioned: Since, I don't have the dummy field, so do I need to add a temp field to that form. If so then still what should I be using to set the count? As the need is to set count of number of rows in the table to a field.( Table contains only one column but will have multiple rows) and then use $LASTCOUNT$ ( As COLCOUNT is not working) ? Please let me know. Thank you. On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support <[email protected]> wrote: ** > >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" >> > > > > > > > >_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"
