Problem with a creating a formula with multiple return string

[Wilnicm]

Hi everyone I have a problem with a formula i've been trying to create for the past 6 days. I have been searching the web and have not come up with nothing. I'm trying to create a grouping formula. My first group is good, but when i go to try to create group 2 off of group 1 that is where the problem is. I'm basically trying to create a formula that says when you see this field from group 1 then that field will be equal to "XXXXX", "XXXXX" and "XXXXXX" from group 2 table field. I also tried using the selection formula nothing has worked..
This is one formula i did that does not work

If {Command_1.AL_DESCRIPTION} = "Financials (FI) " Then
"FI"
Else if
{Command_1.AL_DESCRIPTION} = "Financials (FI) " Then
"Letters DAY 1"
Else if
{Command_1.AL_DESCRIPTION} = "Financials (FI) " Then
"Letters DAY 2"
Else if
{Command_1.AL_DESCRIPTION} = "Data Interfaces "
Then
"Data Interface_Elisa"
Else if
{Command_1.AL_DESCRIPTION} = "Compliance Determination"
Then
"Audit Case Managaement"
Else if
{Command_1.AL_DESCRIPTION} = "Compliance Determination "
Then
"Blocked Claims"
Else if
{Command_1.AL_DESCRIPTION} = "Compliance Determination "
Then
"Collections Case Management"
Else if
{Command_1.AL_DESCRIPTION} = "Compliance Determination "
Then
"Lead Development"
Else if
{Command_1.AL_DESCRIPTION} = "Compliance Determination "
Then
"Protest"
Else {Command.AL_DESCRIPTION} = {Command_1.AL_DESCRIPTION}

when i do this formula it does not return the multiple parameters that are givin it only returns one of the parameter and ..I'm basically want to equal one string from one table to many strings off another table. If someone could help me figure it out.. I would greatly appreciate it since i have not been able to figure this out on my own..

 

[lbass]

You are likely approaching this incorrectly. You should be able to link the first table to the second on some field (probably an ID field). Then when you place a field from the first table on the report, a field from the second table should automatically display the multiple instances that correspond to that ID.

-LB

 

[Wilnicm]

Well the table i'm working does not have the set up to create the report without modifiying it.. The way the table and the database set up.. i had to create a tables from the command line in crystal the first table has an alias to itself to extract Parent folder names. which is {Command_1.AL_DESCRIPTION} The second table that i link the first table was to extract the child folders {Command.AL_DESCRIPTION}. The first group has all the parent fields. The second group which i call it my sub group will have both parent and child field included in them.. Its hard to explain.. I'm sorry if this might sound confusing..

 

[lbass]

I think you should show us how these two fields (labeled) display when placed in the detail section. Sort by the first column and then by the second.

-LB

 

[Wilnicm]

Lbass,
Can you see my current thread.. It goes to alittle more detail.. to show you what i'm talking about.. I hope its enough information for you to be able to understand.. Thanks..

<Will The Great>

 

[Wilnicm]

LBass the name of the current thread i'm talking about is called "Need help with Grouping formula".. Any help you might be able to offer would be great.. ..Thanks..

<Will The Great>