Search results for query: *

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

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

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

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

I have a report where I have a parameter that asks the user for the year required. This is set up as a string. I want to allow multiple values which I have set in the parameter but then I'm falling over with the selection criteria Year({INF_OPP_EXT.SALE_DATE})in tonumber({?Reporting Year}) It...

Hello, I have had a request to add a further bar to a graph which is ran as a sub report on a main report. This sub report is ran on a command as the graph is rather complicated. The graph shows a count of calls by priority and then a count of on hold calls and it is now required to show open...

Hello, I have a mysql statement that works fine in my query programme (Navicat) however when I try and put this in a command in crystal it is throwing an error The statement is set @rownum=0 Select @rownum := @rownum +1 as ranknum, cust_name, count(distinct callref) as rank from opencall...

Hello, I have tested this in Navicat and working fine but it is throwing an error when putting this into a command in crystal reports. It is saying there is an error in the sql syntax. If I take out this section set @rownum=0; Select @rownum := @rownum +1 as ranknum, then fine but I...

Hello, I have a subreport with 3 groups and titles in the GH1 and then the details in GF3. I need to put vertical lines to seperate the columns and to outline the info but these are not showing. It seems to be connected to the new page after option I have ticked as I am wanting a new page after...

Hello, I have a report which is a sub report in a main report. It displays calls from third party organisations in priority order. I have done this using the third party as a group. I then needed a crosstab to show the summary of the calls by priority. This is in the group footer as there is a...

hello, I need a column in my crosstab to show the rank number based on calls in a given month which is a column in my crosstab. Is there a way of doing this?

Hello, Is there a way of having an average of 2 other columns in a crosstab. I have a crosstab which shows a count of calls handled by particular departments in a given month and the previous month and then the difference between these columns. I need to add a column which shows the average of...

Hello, I have a report and in this report I have had to create a subreport which gives me 2 running totals of number of calls from specific helpdesk group members one for month selected and one for previous month. I have to also report these on a summary in my main report. So I have created 2...

Hello, I have a report which I've posted about before it is a subreport within another report. It shows the calls that were still open at the end of each day for a period of the last 8 days. It shows these by priority. i.e. High, Med, Low and calls that are on hold. The report is selected from...

Hello, I have a formula which is @customersite {opencall1.cust_name} +" "& {opencall1.site} However I want to right align the {opencall1.site} I have to put this into a crosstab so I can't do this in 2 fields and have to use a formula. Is this possible either using something in the...

Is there a way of showing the difference between 2 columns in a crosstab. I have 2 columns that show the number of calls for various departments in the month selected and previous month and want a column for the difference between the 2 months. Is this possible?

Hello, I have a crosstab that requires a column for dates in a particular range i.e. last 8 days even if there are no calls in those dates. I have sorted this however am getting a column at the beginning of my crosstab for all dates that are before the date specified and I need to hide this...