I am using the following formula to populate a 'Data Date' range: formula = "Data Dates from " + totext(minimum({@closed time})) + totext(maximum({@closed time}))
When I run it in Crystal and exprt to pdf the date format is MMDDYY hh:mm but when I run the report using vs.net 2003 the date format...
I am using the following formula to populate a 'Data Date' range: formula = "Data Dates from " + totext(minimum({@closed time})) + totext(maximum({@closed time}))
When I run it in Crystal and exprt to pdf the date format is MMDDYY hh:mm but when I run the report using vs.net 2003 the date format...
I am trying to sort a field in a pivot table. The field values are: '< 24 hours', '1-7 days', '8-14 days', '15-30 days', '> 30 days'.
I have only been able to figure out how to sort by asc or des, neither are helpful or what I am looking for. I want to sort either from top to bottom or reverse...
Version CR9
Database Oracle 8i
@4 hr sla >>
{#4 hr}/{#Count CaseID}*100
(These two above are Running Total Fields)
SLA - Status >>
If {@4 hr sla} < 85 then "Failing" else
If {@4 day sla} < 90 then "Failing" else
If {@14 day sla} < 99 then "Failing" else "Passing"
So what I have is an sla that...
I have this formula:
If {@4 hr sla} < 85 then "Failing" else
If {@4 day sla} < 90 then "Failing" else
If {@14 day sla} < 99 then "Failing" else "Passing"
What I need to do is sum the number of Passing and Failing from this field.
I tried to assign a Num (1) if Passing and then sum that field...
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.