changing crosstab row group header on creation [message #1307588] |
Mon, 21 April 2014 17:12 |
Haider Ali Messages: 7 Registered: January 2014 |
Junior Member |
|
|
I am creating a report in which i am showing all areas school activities during the month, i am using the crosstab to show this data e.g
----------------------------------area1----area2-----area3----area4
no of new student in lower group---7--------5---------4---------8
no of new student in upper group---5--------4---------6---------2
and i am using following query
select studentID,'no of new student in lower group' as grphead from tbl where classID <= 5
union
select studentID,'no of new student in upper group' as grphead from tbl where classID >= 5
is it possible that instead of returning 'no of new student in lower group' i return grplower and replace this header with 'no of new student in lower group' in crosstab during cross tab creation.
please not that - is used only for formatting
[Updated on: Wed, 23 April 2014 17:37] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03456 seconds