Cross Tab - help

[saran26]

Hi all,

I have two fields in my table

one is whether is he a friday tester or a saturday tester

and the other is saturday location and Friday location.

I have to display ,

if the tester is a friday tester

then

Friday Location

Name --- Team


if the tester is a saturday tester then

Saturday Location

Name --- Team

if the tester is both Friday and Saturday tester then his name and team should be displayed in both .

please help me out.

Thanks
Saran

 

[lbass]

Please show us a sample of multiple records in the detail section. Label each field.

-LB

 

[saran26]

Thanks LB here are the details

isFridaytester - field in the table (Possible values - yes or No)
FridayLocation ( possible values - A - B - C)
Testername ( Sam, Santhosh, Saran)

Testing Team (Z,X,Y)

isSatTester - fild in the table (possible values - yes or no)

Saturday location ( B, C D)



I want to use a cross tab to count no of people in a location based on their team for friday and saturday seperately using a cross tab and display the details using grouop by.


I created a cross tab,

used the following fields
fridaylocation
testerteam
testername

It displays like this

Team Location A Location B Location C Empty column
Z 1 2 4 7

It is displaying the empty column because for some testers
isFridaytester is No, so I have to use a conditional group and select the records to display only if isFridaytester is yes

Please help me out ?

Thanks
Saran