Search results for query: *

Hi Tek-Tips I have a little issue with display formula in chart. Formula works fine on report; however, it is not displayed in chart. Formula: {#Running TOtal}/Count ({SiteComments.account}, {CONTACT1.KEY3}) I am running Crystal Reports 11. Please advise.

Thank you. Great info!

In general, user should have 7 options: column1 to column6 and n/a If user selects none then column should be blank or display "n/a". Cheers

Hello Thank you for reading. I have a requirement to create a report where I need to select a value from either 6 columns. Then the selected column should appear in the report. User should be able to ignore selection too. Is it something Crystal is capable of doing? e.g. Table: Budtet1...

Hello I have a formula that looks like: if (distinctcount({ttcalls.calltype},{ttcalls.empID}) = 2 and (count({ttcalls.calltype},{ttcalls.empID}) = 2 or count({ttcalls.calltype},{ttcalls.empID}) = 4)) and (({ttCalls.calltype}=1 and next({ttCalls.calltype})=2) ) then "n/a" else "wrong" My...

Please see a required sample below. I have managed to find a script online that satisfies my requirements: select pin, MAX(CASE WHEN ACTVCODE ='AP1' THEN convert(varchar,(convert(date,ONDATE,12))) END) DateAppointment1 Is it a good solution and is there a better way to do it. pin...

I want AP1, AP2, AP3 & HRT. I could get data for either of values. All data is based on user's input; therfore, I cannot confirm that AP1 would always exist.

Please see a sample below. Data is not very clean It is the best case scenario. it is possible to have "be 5 visits and you only want 3 etc." However, currently it is not the biggest issue. Major concern is convert to "wide" table so i could easily link with with other tables around the...

Hello I am working on transations table that logs staff appointments. There can be three appointments (AP1, AP2, AP3) and termination. Each appointment has a date. My objective is to physically convert Staff Rows into columns in the the table e.g. Staff Appointment1 Date1 Successful1...

It worked well! Please can you advise to transform tables physically?

Hello I am working on transations table that logs staff appointments. There can be three appointments (AP1, AP2, AP3) and termination. My objective is to convert Staff Rows into columns e.g. Staff Appointment1 Date1 Successful1 John AP1 12/01/2011 No John AP2 12/02/2011 No...

Hello Tek-Tips'ers I am working on three tables that contain employee information. I have joined table1 (demographics, all employees table) to table2(where employees are working) via outer left join because I want a full list of employees and site if any. Also, I need to join table3...

Unfortunately there is not another field. The only way know related two date values that they would fall under the same jobid.

Morning LB, Thanks for you continues support. recordType holds values of calltype 1 or 2. It is recordtype column in my 1st post. I was not aware of next() and previous() function. I will google them in the meanwhile.

The report is based on time & attendace table where staff clocks in & clocks out. Staff can work at different sites (field jobid) and staff can have multiple positions within the same same. Table in the post below shows this particular example where staff with ID 12345 worked 3 shifts at the...

Thanks lbass, it worked well! I have discovered another challenge. What can i do to discover hour differences if single id has multiple of type 1 & 2 row recordType Time id date 1 1 1PM 12345 24/06/2011 2 2 2PM 12345 24/06/2011 3...

Resutls: id hours action count of issues 12345 2 na 0 12347 0 fix hours 1 12348 1 retrain 1 if there is only single rectype then hours always default to 1 and action retrain if there are same 2 rectypes then fix hours and hours...

Hello, If you are happy with report struture in Excel I would just add logo manually or create a macro to add it for you when you open a workbook.

Hello Tek-Tippers Is it possible to create a formula that would manipulate data among rows. Please see example below: row recordType Time id date 1 1 6PM 12345 24/06/2011 2 2 8PM 12345 24/06/2011 3 1 6PM 12346...

Select Statement: SELECT "Fortnightly_Wages"."KEY3", "Fortnightly_Wages"."COMPANY", "Fortnightly_Wages"."UTOTALWBUD", "WagesSpent"."Wage Total", "WagesSpent"."payWeek", "Fortnightly_Wages"."CurrentDC", "WagesSpent"."Deep Clean", "Fortnightly_Wages"."HOliday Budget" FROM...