is it possible to put a calculated column as crosstab level?
Suppose a crosstab report is like this:
----------------------------------------------------------
YesFlag NoFlag
----------------------------------------------------------
col1 col2 total col1 col2 total
----------------------------------------------------------
DtField xxx xxx xxx xxx xxx xxx
YesFlag and NoFlag are calculated column which are displayed depending on condition.
The condition is :
Suppose we have two query items : qrysub1.ID1 and qrysub2.ID2 where qrysub1 and qrysub2 are two Query subjects.
Take one value of qrysub1.ID1 and check in qrysub2.ID2 values. If found, then display 'YesFlag' and if qrysub1.ID1 is not present in the list of qrysub2.ID2's, then display 'NoFlag'.
I want to know how to creat of the 'YesFlag' and 'NoFlag' tabs in hierarchy?
Suppose a crosstab report is like this:
----------------------------------------------------------
YesFlag NoFlag
----------------------------------------------------------
col1 col2 total col1 col2 total
----------------------------------------------------------
DtField xxx xxx xxx xxx xxx xxx
YesFlag and NoFlag are calculated column which are displayed depending on condition.
The condition is :
Suppose we have two query items : qrysub1.ID1 and qrysub2.ID2 where qrysub1 and qrysub2 are two Query subjects.
Take one value of qrysub1.ID1 and check in qrysub2.ID2 values. If found, then display 'YesFlag' and if qrysub1.ID1 is not present in the list of qrysub2.ID2's, then display 'NoFlag'.
I want to know how to creat of the 'YesFlag' and 'NoFlag' tabs in hierarchy?