Crosstab

rbuser

Hi,
I never use crosstab before. It might be a simple question, but I can't find
the properties anywhere.
How do we change the caption shown in a crosstab?
The crosstab that I have look like this:

Sum of TOTINC DY
ATTACKCLASSNAME 1 2 3 4 5
6 7 ....
Category 1 100 50 44 0
8 92 100
Category 2 100 50 44 0
8 92 100
Category 3 100 50 44 0
8 92 100 ...
and so on
Grand Total

It shows total per day of each category.
Can I remove the word 'Sum of TOTINC' and 'ATTACKCLASSNAME' which is the
field name and change the caption for 'Grand Total'?

And the report will show the rest of the month (8 - 31) on another page.
Can I just have it in the same page, like:


Sum of TOTINC DY
ATTACKCLASSNAME 1 2 3 4 5
6 7
Category 1 100 50 44 0
8 92 100
Category 2 100 50 44 0
8 92 100
Category 3 100 50 44 0
8 92 100
and so on
Grand Total


Sum of TOTINC DY
ATTACKCLASSNAME 8 9 10 11 12
13 14 ....
Category 1 100 50 44 0
8 92 100
Category 2 100 50 44 0
8 92 100
Category 3 100 50 44 0
8 92 100 ...
and so on
Grand Total

Please help, this is urgent.

Thanks a lot,
Karnel

digitalmetaphors

Please take a look at the crosstab demo #127 as it shows how to modify every
cell's text.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

OK, thanks.
Anyway, how about printing the crosstab in column format?
I need to print everything in 1 page.
And is it possible to make the first row invisible and fix the width of all
columns ?

Thanks a lot,
Karnel

digitalmetaphors

You can create the crosstab definition so that it generates this way. Make
the definitions row only and not column based. This should make the crosstab
generate downward. The cross tab renderer class controls how the crosstab
is rendered. You can create your own and register it so that you could
control the widths to your liking. Use the ppCTRend.pas file as a start for
you new renderer class. The registration call you need is also at the bottom
of this file in the supplied RBuilder\Source directory.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi, Jim.
What do you mean by crosstab definition?
Can you give me some example, or maybe where can I find the definition?

As for the column, I will have a few crosstab on the same report, the column
width will be different for each crosstab.
So, I don't think modifying ppCTRend.pas file is a solution for my case.
Does version 7 of report builder has an improvement on crosstab?

Thanks,
Karnel

digitalmetaphors

I meant to say: use the cross tab configuration editor. Create rows instead
of columns. This way the crosstab will generate downwards. The alternative
is to create your own renderer. RB 7 does not have significant changes to
the crosstab other than fixes for bugs which were been reported.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Ok, I'll try that.
I did some trick to get the output I want.
Instead of using 1 crosstab for 30/31 days, I use 4 crosstabs, each for 8
days.
As for column width, I add a few spaces behind the column header.
But it's a bit of trouble if I want to make center alignment.

Anyway, thanks a lot, Jim.
I really appreciate your help.

Karnel