New field in command

[AnnetteB1305]

Hello,

I am trying to create a field in the command that I am using to run a report from. The field I require is as follows:-

select ("EN"& mid(`pcdesc`.`code`,3) ) from pcdesc

Basically I want the pcdesc.code field from the 3rd letter onwards but I want to attach EN to the start. It lets me run this in the command but I'm just getting 0.00 in the results

Any help would be appreciated

Thanks,

Annette

 

[jmd0252]

are you doing this in your command?? I would cretae a formula in CR, doing this function after reading the data.

 

[RTag]

What is the database type?

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[AnnetteB1305]

The database type is mysql and is a really old version that can't be updated due to insurance!

 

[AnnetteB1305]

I need to do it in the command as the pcdesc table contains codes which have country codes in front of them and all codes are the same except they have a different country code. I need all of the codes but the descriptions need to all be in English and therefore I am using this formula in the command so I can then link this to another instance of the pcdesc table enabling me to pull through all the codes but show them in English.

Thanks,

Annette