Search results for query: *

Not sure if this is the right place to ask so here goes. I have a report with about 6 subreports and all have the same formula in it to group teams together. Whenever a team is added i need to go into each subreport and add it manually. Is there a way for me to update all instances of the...

Hello, I am trying to create running fortnight group and noticed that a similar question was answered in thread767-914201. My reports is designed to show the emplyee churn rate week-by-week. Currently i have been able to do this over a single fortnight only and i would like to be able to do...

Hi All, Using Crystal XI on SQL Heres what i need. I need to create a report that shows the true movement per week) of staff in different positions. i.e. Customer Service, Management etc I have a table that contains employee details for each week as a snap shot, so, there can be emplyees...

Hi All, Using Crystal XI on a sql database i have created a report which shows the following information on the detail line: Staff Name | Team Name | @adherence | @rank the rank formula looks like this: if {@adherence} = nthlargest(1,{@adherence}) then "1" else if {@adherence} =...

Hi All, Firstly, im using Crystal Reports XI and ODBC Now, 1. I have a running total field to calculate the Availability of each staff member. #Actual_Availability 2. I have a formula showing the Adherence percentage of each staff member. @Adherence =...

Okay, Im losing my cool here............ Using crystal XI and created a stacked bar graph with time along the x-axis. No matter how many times i resize the chart and muck about, when i select 90 degrees for the rotation of that axis, it wont work. What do i have to do to make this stupid...

Hi All, Is there a way to display all of the formulas that are created in a particular report? Both used and not used. Cheers

Hey All, Firstly im using Crystal 9. Now, i have some formulas that i have created to convert seconds to time. I have had to use the string method because the sum of the times are greater than 23 therefore i am unable to use the ctime function. The problem im facing is having these time...

Hi People, I got a bit of a problem. Firstly, im using Crystal 9.0. Now, I have a database with a whole heap of call data: Date, Duration, inbound/outbound, etc One table contains the actual call data and another table which collects other types of information such as, CATEGORY, STATE...

Hey All, Got abit of an issue with the way that Crystal displays the contents of a field. I'm using v9.0 and reading off a DB2 database. The field in question holds a unique number with is 20 numbers in length. When this field is viewed from the DB2 administration program the field displays...

Hi All, I have a report which is firstly grouped by monthtodate, then by a current week formula which looks like this. datetimevar adjusted; datetimevar date1:={iApplicationStat.Timestamp}; if dayofweek(date1)=1 then adjusted:=date1- 6 else adjusted:=date1-dayofweek(date1)+2 Now, when i run...

Hi All, Firstly im using Crystal 9.5 Now, in my report, i have staff results where the staff names are actually grouped (so i can summarise their weekly stats). The staff are then grouped under their supervisores names where again i have summaries for the supervisors. Not sure if this can be...

Hi All, I am using crystal 9 with an ODBC database. I have created a report which displayes our call centres staff statistics. These stats are in Group 2. Group 1 is the supervisors name. I have recently discovered that i am able to sort the results in group 2 by using the Report>Group Sort...

Hi All, I'm using CR9.5 In my report i want to create a graph that only displays the last 5 days on the 'x' axis. The group that the graph is located in is a datetime group that contains data recorded at 15min intervals. What can i do to have this graph only display the last 5 days worth of...

I need help in tackling a report i wish to create. Basically i want to show the following summaries: Calls Offered MonthtoDate Calls Offered CurrentWeek to date (starting Monday) Calls Offered Today Only. Im have tried all sorts of grouping and i cant get anywhere. Please help. Thanx

I have created a report which counts call stats. In the report, I have created two groups, month and week. The next group i wish to add is "today". How can i create a group that updates with only todays stats? to that tomorrow when i look at the report, it only shows that dates stats only ...

Hey All, I have exported fields (time in seconds) from crystal reports to excel. I believe the field type is integer, so after exporting to excel i cant figure out how to make hh:mm:ss out of them. I tried to change the format of the cells to [ss] but it doesnt work. How can i use the...

Hi All, Im trying to figure out why calls fall into this field. The 'Historical Reporting and Data Dictionary' document explains: "The number of local and incoming network Symposium Call Centre Server calls given Force Disconnect treatment for this application." Does this mean that somewhere...