Alter String to change grouping order (MAGIC)

[JeepStone]

Hi guys,

I'm running 8.0.1.0 with Magic HelpDesk. I'm trying to run a report of Ticket Calls (grouped) by Subject ID. In Magic, although the Subject ID's have a parent/child relationship, they come over to Crystal as a flat list.

I need to be able to separate my report to show all Subject IDs that contain "_" (underscore) and order them alphabetically and then list all the remaining Subject IDs alphabetically below them.

I could do this by altering the Magic Subject ID's and simply appending them with "A" for instance, but there's more than 400! I've tried doing something similar in Crystal:

if "_" in {Help_Desk.Subject ID} then
{Help_Desk.Subject ID} = "A" & {Help_Desk.Subject ID}

but it didn't seem to work.

Thanks in advance

 

[Naith]

Group on

if '_' in {Help_Desk.Subject ID}
then "_"+{Help_Desk.Subject ID}
else {Help_Desk.Subject ID}

Naith

 

[JeepStone]

Cheers Naith!

Worked a treat. I needed the 'else' bit obviously

 

[rosemaryl]

Dear JeepStone,

Do you need to show the Subjects with the parent child relationship? I have a report I can send you that does this. I wrote the report for the Crystal book that NAI uses for their Crystal courseware!

It shows the exact relationship as if you are looking at the old subject tree in Magic (and the new one available in 7.5)

Send me your email address and I will forward you the report,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.