Search results for query: *

Yes incorrect syntax for the mysql version error. I hadn't tried it with the || but just have and still the same AB

Hello, It's a varchar, it's numeric and letters e.g. EN00-005-002-0000 Have tried your solution anyway but saying incorrect syntax, the issue is this is a very old version of mysql which they won't upgrade so a bit of a mare! Thanks for your help Annette Thanks,

Sorry it's a mysql version and that still hasn't done it I am getting an error saying the data types are not compatible. When I try and type the following ('EN'|| mid(`pcdesc1`.`code`,3) ) as code2 varchar (32) It is saying incorrect syntax in the mysql

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...

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

I have a command I am using on a report I need to join a field on here to a field in a table from my database but it won't let me as they are not compatible data types. The field I am trying to link to is a varchar 32 My command is as follows:- SELECT `opencall1`.`logdate`...

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...

Thank you very much, this has been a great help

Just checked and they don't always have 3 elements however I only want to show the fields that do have 3 elements

No that's great why didn't I think of split however I am getting an error message a subscript must be between 1 and the size of the array

I have a field hardware type which I need to only display the second section of the field. i.e an example of the field is:- English -> Hardware -> Computer (Handheld) -> Fan and I just want to display Hardware. I am trying to use the instr and mid functions but I can't get this to work without...

I have a report I need to do to show a crosstab of a count of calls of hardware type by country. So I have set up the crosstab with @country as the column and @hardwaretype as the row and a distinct count of callref plus a further summarised field showing distinctcount of callref but as a...

Couldn't do that as needed to show all the salespeople but needed to have a formula for the best salesperson so I could use it to show various other info but thanks anyway.

Hi, It's ok I found a solution What I've done is put a sort on the group (salesperson) which is based on the sum of sales. Then I've created a formula @bestsalesperson which is:- if GroupNumber=1 then {Database.employeename} Thanks for your help though Annette

Hello, I need help getting a formula to find the best salesperson in the company. The salesperson is a username field The formula needs to be based on a new sales formula which is a sum of another formula which corrects credits as they are not held as minuses in the database. So it is:-...

Hello, Is there a way of showing the percentages on the legend of the chart. i.e. I have a chart which shows number of meetings that salespeople have carried out on the chart. So salesperson on the x axis and count of meeting id on the y axis. Can we show in the legend what the users...

and will this be ok with all my other selection criteria as follows:- {INF_OPP_CON_EXT.INF_LOCAL} = "T" and Year({INF_OPP_EXT.SALE_DATE})in {?Reporting Year} and ({?Date Range} = "Annually" Or MonthName(Month({INF_OPP_EXT.SALE_DATE})) in {?Selected Month(s)}) and ({USERINFO.USERNAME} In...

It is a string and it's US format MM/DD/YY

Great I'll give it a go....never thought of that

Hello, I have a parameter in a report which asks the user to select a month, this is set up as a string field. The users want an All option instead of clicking the double arrows to select all the months (I know....fussy end users!!!) however if I add an All option and change my selection...