Crosstab report

rbuser

Just to clarify a couple of points on the RB7.02 crosstab report.

1. Does the crosstab report perform it's own sorting? It seems that it
ignores the "ORDER BY" clause contained in the underlying dataset.

2. Is there any way to change the caption of a row header at runtime? I
tried the OnGetCaptionText" event and set aText :=
PipeBody['employee_name'], but that did not work.

3. You suggested, "Try not using a CrossTab. Try creating a regular report
that emmulates a grid and performs summary calculation on the dataset using
calc fields.". However, I do not know how many columns there will be at
design time. Do you have a sample of a report that emulates a grid with a
amount of variable columns?

4. The height of the rows in the crosstab do not shrink if I set the font to
any size smaller than 10 pt. Is there a fix for this planned for the next
version?

Thanks,

nicocizik

Yelena,

1. Yes, the Crosstab component does its own sorting independent of the
dataset. There are two speed buttons to control whether the order is
ascending or descending.

2. Check out the Crosstab demo #127 (ct127.pas) located in the
\RBuilder\Demos\2. CrossTabs\... folder for an example of changing the
caption of a certian cell in a Crosstab.

3. The following link shows an example of a report that emulates a grid at
run time. The lines can be added every time a row is printed.
http://www.digital-metaphors.com/tips/CreateReportFromDataset.zip

4. Thanks for the suggestion.