2 Different Groups on 1 Field??

[kmcclung]

I have a field that is type boolean. I'd like to create 2 different groups (not sections within the group) on the field - 1 for all true values and 1 for false. Is this possible?

 

[Ngolem]

let me get this straight...you want 2 separate groups ... one called True ...Followed...by one called False..

not just separating all the Trues from Falses in one Group

could you describe the situation a bit better...I cannot really understand the purpose...

if you had one group based on the formula

if {Table.booleanvalue} = True then
"True"
else
"False";

isn't this sufficient?

Jim
JimBroadbent@Hotmail.com

 

[kmcclung]

Sorry - I should have given more background....

I am writing a call center report based on a particular supervisor's team. It is a MTD report than generates all the agents who worked for that supervisor during that month. I have 5 groups - team, last name, first name, thrown out (boolean field) and the date.

The report is to show the minutes each agent worked by day. If the shift (day) was "thrown out" than I don't want to include those minutes in the agent's monthly minute total. So I have my thrown out group order by a specified order with the thrownout = false first, then all the trues. I then suppress any minutes visible under the true.

I can total these fine, but the problem comes when I'm trying to total the overall team minutes for the month. The report is currently set up so that each agent is on their own page (15 agents = 15 pages), but they want the team total listed on each page as well. The problem is I can create a running total and place it in the group footer (which only displays on the last page - by itself) with the correct amount, but can I place it in the group header?

The report looks like this:

Mins
Team 100
Agent1
ThrownOut (F)
3/1 10
3/3 15
ThrownOut (T)
3/5

--Next Page--
Mins
Team 100
Agent2
ThrownOut (F)
3/2 20
3/4 45
ThrownOut (T)

In this example, the team total should be 90 not 100. The 100 is coming from the ThrownOut(T) record on 3/5 which would be 10 minutes.

Hope this makes sense!

 

[rogar]

The "thrown_out" minutes are suppressed but are still included in the totals. Try this -- use a formula instead of the {minutes} field in your report detail:

if not thrown_out then {minutes} else 0

 

[kmcclung]

That's exactly what I needed..seems awfully simple now!!! =)

Thanks!!