I am trying to create a cross tab in CR2008. I can get the field in the details but cannot choose it when trying to create a cross tab. Please help.
Thanks.
Shared numbervar MonHrs;
Shared numbervar TueHrs;
Shared numbervar WedHrs;
Shared numbervar ThuHrs;
Shared numbervar FriHrs;
Shared numbervar SatHrs;
Shared numbervar SunHrs;
If dayofweek(today) = 1
then {@CapacityTeamCount} * SunHrs else
if dayofweek(today) = 2
then {@CapacityTeamCount} * MonHrs else
if dayofweek(today) = 3
then {@CapacityTeamCount} * TueHrs else
if dayofweek(today) = 4
then {@CapacityTeamCount} * WedHrs else
if dayofweek(today) = 5
then {@CapacityTeamCount} * ThuHrs else
If dayofweek(today) = 6
then {@CapacityTeamCount} * FriHrs else
if dayofweek(today) = 7
then {@CapacityTeamCount} * SatHrs