Sorting Order in TfxMasterData

Monte Carver

In a given TfrxMasterData, I need three columns, which is easily set. However I require that the data sorts TOP-DOWN, then LEFT-RIGHT. How can I achieve this objective?

Thanks,
Monte

gpi

You should resort your dataset. For example, close query, change SQL and open query again

Monte Carver

gpi wrote: »

You should resort your dataset. For example, close query, change SQL and open query again

Yes.. that is one obvious solution. But it would require a very tedious algorithm to determine the "proper" sorting based on the number of records for the three columns. I simply want the data to sort much like a newspaper column does. How can I structure the report to offer such feature? Where each each column and the equivalent number of rows.

Thanks
Monte

gpi

Attach a sample what you want to get here

Sean Palmer

I also need three (or more) columns with the data sorted TOP-DOWN, then LEFT-RIGHT. There can be any number of records in the dataset so the sorting needs to continue on to the next page. Dataset is sorted in 1,2,3,4, etc order.

example:

1 11 21
2 12 22
3 13 23
4 14 24
5 15 25
6 16 26
7 17 27
8 18 28
9 19 29
10 20 30

---

31
32
33
...

Please also see Fast Report .NET help for an example. Fast Report .NET Help. I want to use the "DownThenAcross" mode!
If it can be done in the .NET version why can't it be done in the VCL version???

Thanks,
Sean