sorting records

rbuser

I created a report that is grouped by a custom field (ie. Label2).

When I run the report, it doesn't group all of the same values together. Is
it possible that I need to sort also by label 2? And if so, how do I. Any
help would be greatly appreciated.

digitalmetaphors

You'll need to order the data so that it is sorted before it is fed into the
report. When the report generates, it will not reorder the data. The group
will break based on the label text value.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Maybe I am not clear but I don't think it is breaking based on the label
text value. Let me give an example:

The report will list 5 detail records associated to value=A in my group.
Then it will list 3 detail records associated to value=B. Then it will list
another 4 records associated to value=A.

Any help would be appreciated.

Thanks,

Aaron

digitalmetaphors

When are you assigning the text to the label. Use the OnGetText event to
assign the text of the label.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

It works a lot better if the data is sorted in a dataset (like using a
TQuery that is grouped and sorted by the value you are interested in),
rather trying to do it programatically.