Why does a Cross tab component not have the option to sort its rows in the SQL order they are retrieved? There's two speedbuttons for sort ascending / descending and I can't seem to turn them both off. I want my data as I asked for it.
The CrossTab component is designed to always automatically sort your data. There is currently no way to turn this sorting off. The sorting is a fundamental part of the crosstab solution in ReportBuilder.
Comments
The CrossTab component is designed to always automatically sort your data.
There is currently no way to turn this sorting off. The sorting is a
fundamental part of the crosstab solution in ReportBuilder.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
field to my table, writing to it and then doing this:
procedure CrossTab1OnGetDimensionValue(aDimension: TppDimension; var aValue:
Variant; var aSkip: Boolean);
begin
if aDimension.fieldname = 'PROJ_TITLE' then
aValue := IntToStr(TMS_Proj_Hours['TMS_PROJ_HOURS-Sortorder']) +': ' +
TMS_Proj_Hours['PMS_PROJECT-Proj Title'];
end;
Not a perfect solution, but workable for now. Thanks.