Cross-tab Group Options - Need Help please

[DallasAggie]

Hi all.

I hope some one can help me out with this.

I have a cross-tab grouped by "deployed_equipment_type" which results in:

1) New
2) Relo
3) No Relo

Well, I customized the group formula cause I want to group together Relo and No Relo. Here is what I put in the "Options - Use a Formula as a Group Name" section:

IIF ({co_deployed_equipment.deployment_type}= "New","Boeing Installed" ,"TSA Installed" )

So in essence I want my crosstab just to display counts for:
1) Boeing Installed, and
2) TSA Installed

, but what I'm getting is:

1) Boeing Installed
2) TSA Installed
3) TSA Installed

Any ideas what I may be doing wrong?

Thanks,
Robert Andrade
The Boeing Company - Homeland Security & Services

 

[DallasAggie]

Never mind. I figured it out.

Here is what I did.
1. I just created a formula first that renamed
---- "New" to "Boeing Installed" and
---- "Relo & No Relo" to "TSA Installed"

After I did this, I changed the cross-tab group from "deployed_equipment" to my formula @formula_deployed_equipment. . . .worked like a charm.

hope this helps some one out there too

Regards,
Robert Andrade