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.

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

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

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

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

Hello Tek-Tips I have been using Crystal Reports for about a year now; however, I have never used SQL Expression Fields. It just sounds so interesting. Please advice what & how they do. Thanks

hello, I am new at sql & appologies if it is a too basic question; however, i am still working on it: select * from CONTACT1 inner join CONTSUPP on CONTACT1.ACCOUNTNO= CONTSUPP.ACCOUNTNO where CONTACT1.KEY1='Client' and (CONTSUPP.RECTYPE = "P" )=False I want to display records where...

Hello I have a very simple report that groups : a) manager b)weeks c)Contracts John Week 1 - £200 a site b site c site Week 2 - £300 a site b site c site d site weeks variable is filename of an import file. Val(Mid({WagesSpent.Manager}...

Today I discovered that it is possible to do group selection. I have never used group selection before. What are the main differences between record & group selections. Many thanks

Hi Tek Tips I am working on KPI project. In general, i link shared variables into main report to do formulas & calculations and it works fine. Howeve,r I cannot create any charts with those variables. What can I do about it? Crystal Reports 11 & using basic many thanks

Hi, I need some help on calculating averages of managers and their clients. 1st calculation is simple - average of all records 2nd calculation - I want to calculate average on values that are above zero. I cannot find out how can i do it. The only way i could see the result is this: sum of...

Hi, The purpose of report is to generate audit results for clients for quarter. Audits can be done monthly, bimonthly or quarterly. I have manage to get those results by grouping clients, assigning variables for each month in quater and using max summary in the group. Results are calculated...