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...
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...
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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.