hiding "some" grand totals in a crosstab

rbuser

Hi,

I have a crosstab with totals showing. Is there a way to hide some of
the totals. For example I just want to show the first column's total.


Bora Aydemir

nicocizik

Hi Bora,

Unfortunately the crosstab component is not very customizable in this case.
It is possible to alter the text shown in the grand total row or column, but
the removal of this item entirely is currently not an option. Take a look
at the crosstab demos located in the \RBuilder\Demos\Crosstabs\... director
for examples of what is possible as far as customizing the output.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Hi Bora,

You may also want to check out the thrid party crosstab component Grid Pack.
This may contain the features you are looking for.

http://www.planitechnologies.com/

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Setting the display value of the desired total to null string will do
the trick. BUT I can not find the column/row..., of the displayed total
column at "GetTotalValueText" event.

bora

rbuser

I have checked it out. The crosstable component of planit has only one
dynamic dimension at the moment. The author sad it will support two
dynamic dimensions in the next major release(schedule unknown).

bora

nicocizik

Hi Bora,

Usually this will need to be done with trial and error. Try setting a break
point inside this event and check the row and column values to find out
which ones are the needed total value cell.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I don't know how to find the column number or column header of the total
at the event 'GetTotalValueText'. In other events there are parameters
like aElement etc that lead the path but in 'GetTotalValueText' I'm
blinded (or think so). What I really need to know is how I can get to
column info of the total at GetTotalValueText event.

bora

nicocizik

Hi Bora,

I'm unclear about what you mean by "blinded". In my testing with a simple
crosstab with one grand total, the OnGetTotalValueText event fires once
giving me the correct value inside the aText parameter. Setting the aText
to '' (empty string) removed the value from the crosstab component.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

sorry for the confusing explanation.
Simply I have a crosstab report with dynamic number of columns, as usual
For some special columns (which I know the header text) I want to
display totals. At OnGetTotalValueText I don't know if this total should
be displayed or not. If I could find the column headers text of that
total in this event I can decide to show or not to show it by setting
aText to emptyString.
(By saying 'blinded' I was trying state that I do not know which
column's total is being generated at OnGetTotalValueText. If I could
somehow know the dimension's caption that would solve my problem)

Bora

nicocizik

Hi Bora,

Have you tried using the OnGetTotalCaptionText, OnGetDementionCapiton, or
OnGetCaptionText events to get the caption text you need? You could perhaps
store all these values along with their respective column numbers, then when
you use the OnGetTotalValue text you can compare column numbers and make
changes accordingly.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks, it worked

Bora Aydemir