CrossTab questions

rbuser

I have 2 questions on crosstabs
1. Is the pipeline assigned to a crosstab component the same as that of the
reports'. My problem is that I get the crosstab table not just once but
quite a few times - the same one. It is perhaps the number of records.
2. How can I modify the labels of a crosstab table ie the GrandTotal, Sum
Of, Count Of etc?
Thanks
Yannis

rbuser

> I have 2 questions on crosstabs
the

That depends upon what you want. The Cross tab will print each time the band
that owns it prints. If you only want to print it one time, put two
different sub reports on the main report, set the second one's
'ShiftRelative' property to teh other and configure the two sub reports.

Ed Dressel
Team DM

nicocizik

1. The reason you are seeing the crosstab more than once is you have the
report and the crosstab connected to the same datapipeline. Disconnect the
report from the datapipeline and the problem should be fixed.

2. Check out demo 127 in the \RBuilder\Demos\2. CrossTabs\demo.dpr project.
This should give you an idea on how to modify the text in each cell.

--

rbuser

Thank you Nico.

Refering to my first question I noticed that in demo 127 the same pipeline
is attached to the report as well as to the CrossTab component and it works.
In my case I got repeated cross tab tables. I did what you suggested and it
works.
The only problem I have now is that the caption of the columns (row zero,
column 1) is trucated to the width of the first column.
Is there a way around it (apart of enlarging with spaces the width of the
first column)?
Thanks
Yannis

digitalmetaphors

Changing the text captions doesn't change the width of the columns, because
the crosstab matrix has already been calculated. What I would do is create
an in-memory dataset that feeds the crosstab. This allows you to pre-process
the data and get it ready for the crosstab. That way you can use the
crosstab without having to try and change the data while it is generating.
This will give you the best results. There are in memory datasets available
form Torry's web pages and I believe ASTA has a freeware in memory dataset
you can download as well.


Cheers,

Jim Bennett
Digital Metaphors