CDS
|
| Posted: 09/30/2002, 5:26 PM |
|
I'm using the "ShownRecords" (predefined) variable to show the total number of records shown on each page. However, I'd like to know the total number of records shown on all pages of the returned recordset.
Could someone show me the light on how to do this?
Thanks much!!!
Using ASP, CCS latest version...
|
|
|
|
imranz
|
| Posted: 10/01/2002, 7:26 AM |
|
Looks like what you want is to return a total number of records listed in a particular form, regardless of which page you are on in the paging of that form. Here is a solution for the ASP world.
Counting Records in a Form In CCStudio
1) Drop a Label field somewhere into your form's HTML from the Forms tab in the Toolbox. The easiest place is at the start of your form, right after the <!-- BEGIN Grid *yourform* --> section.
2) In the properties, name this new field something like 'Counting'
3) Set the Source Type as 'Code Expression'.
4) Nothing in Control Source
5) Data Type of Integer
6) Nothing in Format
7) Put the Default value as: yourform*.datasource.Recordset.RecordCount()
*REPLACE 'yourform' above with the name of the form for which you're counting the rcords.
That's it!
|
|
|
|
|
|
