RAP and Crosstab.OnGetValueText and GrandTotals

rbuser

Hi,

I want to format only the value fields, not the dimension fields or the
total or grandtotal fields.
I've tried to use the OnGetTextValue and that works fine, except the
grand total fields that I show in my crosstab get formatted as well. How
do I prevent this using RAP

regards
Paul Sjoerdsma

digitalmetaphors

Check out crosstab demo #127. It should only format the values in that
event. There are other events to format the total values, as the demo
shows.

The demo is in Delphi code, but the approach should be the same in RAP.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

I ahve seen that one, the values in the grand total row have a (V) after
them, indicating a ValueText. So how do I distinguish between values
that appear in a Grant Total row and other values.

regards
Paul

In article <3de24be9@dm500.>, "Jim Bennett \(Digital Metaphors\)"

digitalmetaphors

Looks like the demo is hooking into the wrong event handler. There is a
OnGetTotalValueText event that isn't being utilized in the demo. Use that
to get at the grand totals. Sorry about that.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The reason I asked was because I already used the following events

OnGetValueText --> aElement.Font.Color := clRed;
OnGetTotalValue --> aElement.Font.Color := clBlack

Now if I look at the color of the values in the total row they are ...
red instead of black. So either this is a bug or I need to use some
other means of deciding in the OnGetValueText if the current value
belongs to the total row.


regards
Paul


In article <3de520d3$1@dm500.>, "Jim Bennett \(Digital Metaphors\)"

digitalmetaphors

I'm running RB 7 and in RAP using :
CrossTab1OnGetTotalValueText(..

begin

aElement.Font.Color := clRed;

aText := '55.55';

end;

CrossTab1.OnGetValueText...

begin

aElement.Font.Color := clBlue;

aText := '66.66';

end;

When I use this code, the bottom row and right column totals are 55.55 in
red and the inner values in the crosstab are 66.66 in blue. Can you send an
example to support@digital-metaphors.com that doesn't work?


Cheers,


Jim Bennett
Digital Metaphors

rbuser

Jim,

I'm using RB 6.03 Enterprise, so it might work with RB 7 I don't know.
At the moment we are planning to move to RB 7 and have already invested
in it, but it will take some months before we are ready to do so. In the
meantime is there a workaround for RB 6 or have I missed something??

regards
Paul

In article <3debb435$1@dm500.>, "Jim Bennett \(Digital Metaphors\)"

rbuser

Jim,

Using RB 6.03
I had another look at crosstab demo 127 and it seems the right event
handlers are there. I guess that is your demo.

regards
Paul

In article <3debb435$1@dm500.>, "Jim Bennett \(Digital Metaphors\)"

digitalmetaphors

I searched through the changes again, and there was a fix in RB 7 that
changed the event id for the notification of the total value event. This
would explain why it works in RB 7 and not RB 6.03. You'll have to upgrade
to RB 7 to get the fix. Otherwise, you'll have to use a Delphi event handler
for the CrossTab.OnGetTotalValueText event.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

Thanks for the clarification.

regards
Paul

In article <3deccdfd$1@dm500.>, "Jim Bennett \(Digital Metaphors\)"