is there any method to "New Column After"?

[Caltang]

Hello all,

I have a table that 20(10 boys and 10 girls) students' total mark in final exam, and now i want to print a report such that it will show 2 columns grouped by sex and start a new group in next column. Graphically,
Sex = M Sex = F
Student001 1000 Student 011 926
Student002 998 Student 012 920
Student003 978 Student 013 915
. .
. .
Student010 930 Student 020 870

 

[FoxG]

Hi,
what you may be looking at is to set up two subreports

the first will select only students with sex="M",
the second will select only students with sex="F"

Add the subreports into the detail section.

Good luck,
Geoff