TppCrossTab and sorting on columns

rbuser

The crosstab that I am trying to create has two "fixed" columns that are to
display a description (which may or may not have a vlaue) and then a point
number (which will always be populated). The columns after that will
display date specfic information for each point.

The problem I am having is that I would like the report to sort on the
second column (the point number; so that it goes 1, 2...9, 10 and not 1, 10,
2...) rather than the first column (the description). Is there any way I
can do this?

I have already set up my query (Oracle dataset) to order by the point
number but no luck. If I remove the first column I get the correct order of
the point number column.

We are using RB 7.02 in Delphi 6.

Thanks

Mark

nicocizik

Hi Mark,

By definition the crosstab will order the data based on the first column or
row of the component. Unfortunately there is no current feature to order
the crosstab on a column or row other than the first displayed.

--
Regards,

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