Skip to Content
0
Former Member
Jan 14, 2011 at 05:42 PM

Creating a Cross tab that contains fields with shared variables

254 Views

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