Search results for query: *

I want a formula in CR9 that is a distinct count of {service_call.service_call_id} for each {part.service_part} The tables have a nice clean join. The only group of the report is {part.service_part}. I suck at writing formulas and need some help. Thanks, Joy

My Crystal Report (v9) is a distinct count of service call ids per month. Group Name 1 is Service_Call.Create_Dt Group Name 2 is @Vendor @Vendor is: if {PART.PART_VENDOR_ID}=109 then "NETWORK" else "UNIX" Group Name 3 is Service_Call.Service_Call_ID In the Cross Tab I use a formula to break...

Crystal Reports 9 Group Name One is: {Company.Company_ID} Group Name Two is: {Service_call.Service_call_id} Group One Footer has a Distinct Count of {Service_call.Service_call_id} I want my report to print the service call history for the given date range based on 3 or more service call ids...

In CRYSTAL REPORTS 9, I am using the following formula (@lastquarter) to select records based on true: f Month(Today) >=1 and Month(Today)<=3 then (Year({SERVICE_CALL.CREATE_DT}) = Year(Today)-1 AND Month({SERVICE_CALL.CREATE_DT}) in [10,11,12]) Else If Month(Today) >=4 and Month(Today)<=6...

In Crystal Reports 9, there are predefined functions such as "LastFullMonth" and "LastFullWeek". However, there is not a "LastFullQuarter". I am looking for a formula that would be hands off (ie: no manual date range entry) that I can use when I schedule the report with Visual Cut. I don't...

In Crystal Reports 9, on oracle/sql/unix, I have a parameter that lists part ids: (Part.Part_id). When I run the report I enter a list of part numbers I want to query. Works great. However I want to have that list of part numbers display in my report title. I have done this with date ranges...

I have a formula in the detail section of CR9: if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="VENDONSITE" then {SERVICE_CALL_EVENT.ACTION_DT} I cannot place this in my group footer section. However, for reasons I don't want to get into now, I need to have this in group footer. The only way I...

ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatestotoday)) I am using the above formula to convert dates to text. The output I get is: -47 13-01-01 to 2005-01-24 How do I get the firstdate that a record is used vs the first date in my DB? Crystal Reports 9. SQL and Oracle 8.

I have a cross tab report where I have editted the column headers using EDIT TEXT to be more meaningful for my audience (they are formulas...removed the @ sign). When I export to Excel, the @signs reappear. Why? How to I get the editted text to export. I am also curious to know why the...

I am running CR version 9 on SQL (not sure of the version) and on Oracle. My main table in linking is: SERVICE_CALL Linked off the SERVICE_CALL table is the SERVICE_CALL_XREF table. These two tables are an equal inner join using the SERVICE_CALL_ID field found in both tables. Within my...

Crystal Reports 9. I need assistance writing a formula where I select records where SERVICE_CALL.SERVICE_CALL_ACTION_DT is current date less 3 days (ie: 3 days ago), and print the SERVICE_CALL.SERVICE_CALL_ID. I am having syntax issues and need perspective/help from others. Thanks. Group is...

In Crystal reports 9, I have the following in my "Show SQL Query" <snip> ("SERVICE_CALL"."CREATE_DT">={ts '2004-06-19 00:00:00'} AND "SERVICE_CALL"."CREATE_DT"<{ts '2004-07-31 00:00:00'}) <snip> Everytime I run my report (daily) I have a different date range automatically entered from the...

My CR9 report requires unique date ranges every month. For eg: July31-Aug27; Aug 28-Sept 17; Sept 18-Oct 29...and so on. I've been playing with various formulas to plug in as a record selection formula with no success. Mainly with select and case statements. My database element is...

My tables store 'create date' as a DateTime field. eg: 2004-06-21 10:55:16PM I want to do an if statement that basically says: if the action was created between 5:01PM and 5:59AM then "print text" How can I do this? Crystal Reports Version 9.

I have a CR9 report that has a group, ie: not just header and detail. Group Header = location detail = system info (id, serial number, contract, etc) Group Footer = Distinct Count of system id When the report is run there are multiple groups (ie: lots of locations). My client wants an excel...

Before I go into all the details of my report I want to find out if Crystal will allow a user to create a report based on: Report Footer section: running total (average time) vs Date Range Parameter Neither option appears in Chart Expert as a 'clickable' option.

Crystal Reports version 9 on SQL/Oracle My formula starts out as: if {SERVICE_LEVEL.RESPONSE_TIME}="8 HR" then "00:08:00:00" else if {SERVICE_LEVEL.RESPONSE_TIME}="4 HR" or {SERVICE_LEVEL.RESPONSE_TIME}="4hr" then "00:04:00:00" else if {SERVICE_LEVEL.RESPONSE_TIME}="2HR-PHONE" then...

My post is similar but not exact to http://www.tek-tips.com/viewthread.cfm?SQID=773091&SPID=767&newpid=767&page=1 I have the following formula that finds the difference between two DateTime fields and converts it to XX:XX:XX:XX format (string): //Convert Total Seconds to DD:HH:MM:SS //Remove...

This forum is awesome. I've learned so much, and yet have so much left to learn! My problem of the day is: I have a table (SERVICE_CALL_EVENT) with field (SERVICE_CALL_EVENT.NOTES). This is where my technicians enter the notes of an action performed on a call. It can be up to 4000...

In Crystal Reports version 9, I'm working with a call tracking database (SQL/Oracle). On my detail line (group=call id number), I have the following formula to tell me what time(s) the call was escalated to a vendor (note: it returns accurate data): if...