materix
|
| Posted: 09/06/2004, 6:26 AM |
|
I have a grid that displays a lot of entries. In the event BeforeShowRow the integer-columns in the entries are being added to a calculated sum.
But i do not always want the entries-grid to be displayed on the screen, so in the event BeforeShow I set "$entries->Visible = False;".
But when the grid-visibility is set to false, then the tiggers in the BeforeShowRow are not being processed, so the calculated sum is always showing zero.
Do you have any suggestion for a work-around to this problem?
|
|
|
 |
DonB
|
| Posted: 09/06/2004, 1:21 PM |
|
One optimization that CCS performs is to not fetch data if the control bound
to that data is not visible.
You have the option of having two Grids - one for the "visible" appearance,
and another for the "not visible" appearance. For the latter, you'd provide
an alternate query which queries for SUM(fieldname) of the various columns,
giving you one row of output instead of listing each row individually.
The second option is to modify the query of your one grid, which is always
visible, so that it selects the SUMs when you want only the totals shown.
Change the query in the BeforeExecuteSelect event.
--
DonB
http://www.gotodon.com/ccbth
"materix" <materix@forum.codecharge> wrote in message
news:5413c658ec340a@news.codecharge.com...
> I have a grid that displays a lot of entries. In the event BeforeShowRow
the
> integer-columns in the entries are being added to a calculated sum.
>
> But i do not always want the entries-grid to be displayed on the screen,
so in
> the event BeforeShow I set "$entries->Visible = False;".
>
> But when the grid-visibility is set to false, then the tiggers in the
> BeforeShowRow are not being processed, so the calculated sum is always
showing
> zero.
>
> Do you have any suggestion for a work-around to this problem?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
materix
|
| Posted: 09/07/2004, 7:32 AM |
|
Thx. for the answer Don.
http://www.gotodon.com/ccbth is a great site!
|
|
|
|
|
