Search results for query: *

My other problem is not every system_id has a service_call_id and I need to report on all system_ids.

lbass, I've been working with this, but need all service_call_id to print. Your method, and mine, only lists one service call id. My group is system_id. Suggestions on how to get all service_call_ids to print? Joy

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

Thanks for pointing me in the right direction. I went with: If Month(Today) >=1 and Month(Today)<=3 then totext(cdate(Year(Today)-1,10,1))+ 'to' + totext(cdate(Year(Today)-1,12,31)) Else If Month(Today) >=4 and Month(Today)<=6 then totext(cdate(Year(Today),1,1))+ 'to' +...

DUH!!!! Way too easy. Had been making this harder than necessary. Thanks for your help, Dave.

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

Thanks for the reply. I created a formula called @Quarter: if Month(currentdate) in [1,2,3] then Month({SERVICE_CALL.CREATE_DT}) in [10,11,12] and Year({SERVICE_CALL.CREATE_DT}) = Year(currentdate)-1 else if Month (currentdate) in [4, 5, 6] then Month({SERVICE_CALL.CREATE_DT}) in [1,2,3]...

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

Thanks for your FAQ. I ended up doing the following as it is a numerical parameter: whileprintingrecords; stringvar Output:=""; numbervar Counter; numbervar uboundminusone; uboundminusone:=ubound({?Part numbers}) -1; For Counter := 1 to uboundminusone do(Output:= Output& totext({?Part...

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

Cancel this post. Resolved on own (hanging my head in shame). maximum ({@vendoronsite},{SERVICE_CALL.SERVICE_CALL_ID})

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

Thanks. I will put in a minimum. I was hoping to have an open start date so that I wouldn't miss any historical data. LastFullMonth works great for month to month data with my formula. I was hoping that AllDatesToToday would do the same. Oh well. :)

Let's assume my database's first date is Jan 01, 2000. However in the report I'm running the record selection criteria hits a match on April 01, 2004. By first date used I mean April 01, 2004 not Jan 01, 2000. Sorry for the confusion. Thanks for posting.

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

Report should look like: Call # Metric Vendor Reason 7032 Scrub Smith Defective Part Smith1 7055 Scrub Smith Warranty

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