Imran
|
| Posted: 09/13/2002, 2:30 PM |
|
Is there a built in value on CCS grids that contains the total record count?
Looking for the fastest way to show total number of records...
|
|
|
 |
Sixto Luis Santos
|
| Posted: 09/13/2002, 7:21 PM |
|
Imran,
For the count of records in the grid, create a new label, set its source
type to 'Code Expression' and its control source to:
$this->ds->RecordsCount
If you need to display total records in the database, you need to set the
control source to:
CCGetDBValue($this->ds->CountSQL, $this->ds)
Of course, if you are not using a search form (i.e. the grid displays all
records), then both methods are equivalent.
Regards,
Sixto
"Imran" <imranz@knight-images.com> wrote in message
news:altlde$pbb$1@news.codecharge.com...
> Is there a built in value on CCS grids that contains the total record
count?
> Looking for the fastest way to show total number of records...
>
>
>
>
>
>
>
|
|
|
|
Imran
|
| Posted: 09/16/2002, 8:29 AM |
|
Hi, thanks, but I forgot to mention. I'm using ASP....
Anyone?
Thanks...
"Sixto Luis Santos" <sixto@tecnoapoyo.com> wrote in message
news:alu6et$ndq$1@news.codecharge.com...
> Imran,
>
> For the count of records in the grid, create a new label, set its source
> type to 'Code Expression' and its control source to:
> $this->ds->RecordsCount
>
> If you need to display total records in the database, you need to set the
> control source to:
> CCGetDBValue($this->ds->CountSQL, $this->ds)
>
> Of course, if you are not using a search form (i.e. the grid displays all
> records), then both methods are equivalent.
>
> Regards,
> Sixto
>
> "Imran" <imranz@knight-images.com> wrote in message
>news:altlde$pbb$1@news.codecharge.com...
> > Is there a built in value on CCS grids that contains the total record
> count?
> > Looking for the fastest way to show total number of records...
> >
> >
> >
> >
> >
> >
> >
>
>
|
|
|
|
Imran
|
| Posted: 09/16/2002, 9:12 AM |
|
Found out that in ASP, this is the way to do it:
- create a label field called 'countnumber' or whatever
- select a datatype of integer
- select a source type of code expression
- for default value, put Formname.datasource.Recordset.RecordCount() where
Formname is the name of the form you're on.
And that's it!
Staff.datasource.Recordset.RecordCount()
"Imran" <imranz@knight-images.com> wrote in message
news:altlde$pbb$1@news.codecharge.com...
> Is there a built in value on CCS grids that contains the total record
count?
> Looking for the fastest way to show total number of records...
>
>
>
>
>
>
>
|
|
|
|
|
