Transpose data

[varunmathur]

Hi
I need to print a report with figures laid horizontally instead of vertically, is there any way of doing it. (Similar to what paste special- Transpose does in MS Excel).
Thanx in anticipation
Varun

 

[David R]

Are you familiar with Crosstab Queries?

 

[varunmathur]

Thanks,
but crosstab queries dont solve my problem-
The report is require to output a list of successful roll numbers sorted subjectwise.
The result requires that they be printed in ascending order 10 Roll numbers to a line from left to right.
tricky but I am sure is possible
varunmathur