refer link,
A
Customized Crosstab Report[
^]
tips for sub columns effect
e.g.
subjects
----------------
Math | Eng | Sci
then query data should like this
MastColId SubjId SubjNm Marks StdId StdNm
1 1 Math 90 1 abc
1 2 Eng 91 1 abc
1 3 Sci 92 1 abc
1 1 Math 70 2 xyz
...
if you not have MastColId simply add it
select 1 as MastColId, subjid,subjnm...
now, in crosstab
Columns = MastColId, SubjId
Rows = StdId, StdNm
SummaryField = Mode(Marks)
Happy Coding!
:)