Another simple formula question-

[tinyredtornado]

Hi guys!
Another super noob question. Using CR2008

I am trying to display a different title for a group header than is shown on the database. I have 3 full titles to be shown but the database spits out a truncated version of each. Without altering the database's output, can I show the full titles?.
I thought if I just plugged into the group heading select expert

if {searchOutput_.Platform} = "xx" Then "xxxxxxx®"
if {searchOutput_.Platform} = "yy" Then "yyyyyyy®"
if {searchOutput_.Platform} = "zz" Then "zzzzzzz®"

it would work but I'm not seeming to get anywhere with that. I keep getting "result of selection formula must be a boolean". Am I just putting it in the wrong place? I'm right clicking on the group header/select expert group/selecting group/and selecting formula: from the drop down.
Any help is greatly appreciated, and thanks again for your patience.

 

[CoSpringsGuy]

insert elses as follows-

if {searchOutput_.Platform} = "xx" Then "xxxxxxx®"
else if {searchOutput_.Platform} = "yy" Then "yyyyyyy®"
else if {searchOutput_.Platform} = "zz" Then "zzzzzzz®"



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[dgillz]

This does not go in the select expert. The select expert should always be a boolean (true/false) formula that determines which records or groups belong on the report, it will NEVER affect how the records look.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[CoSpringsGuy]

My bad I should have read the post closer instead of focusing on the if statement. However after reading it again, if I understand the goal, you should be able to create a formula and use that if statement. Place that formula in the group header instead of {searchOutput_.Platform} which I assume you are grouping on.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[tinyredtornado]

You guys are amazing!!!!
Thanks so very much for your incredibly quick and completely working suggestion!!!!
I <3 Tek Tips!!