Recent content by khekking

Gmmastros, After applying the suggested coding I basically get the same results but with NULL rather than '' in the OpenQuote Column. Additionally, removing the discrete function before CUSTID_32 has added what I believe are duplicate rows. Here are the results: CUSTID_32 MonthlyRentals...

SQLBill, Thank you for the response. I did a poor job of explaining my issue. When distinct is removed I get more rows returned. I was trying to eliminate the "dupes" (I hope that is the correct jargon) by using distinct. Thanks, Ken

Gmmastros, Thanks for the response. Sorry the jargon I used was incorrect. I want to keep the rows that have the date value. Thank you in advance for your help. Cheers, Ken

I'm new to SQL and need help. The table below duplicates the row when there is a value for "open quotes." I'm using SQL 2008 and accessing it with SQL server management studio by Microsoft. Here's the query: select distinct CUSTID_32, MonthlyRentals, DailyRentals, FreightCharges, Total...

Ian, Thanks for the quick response. I had a typo on the date select formula list above (typing to fast). The corrected formula is below: if {KH_LastRCSActivityDate.LastRCSContactDate} in dateserial(year(currentdate), month(currentdate)-7,1) to dateserial(year(currentdate)...

Using: SQL Database Crystal Reports 11.5.1 Using the following formula I'm getting returns outside the requested scope for {LastRCSContact}. Can someone take a look at this and let me know if additional information is needed and what I need to do to fix my formula. Many thanks in advance...

INFORMATION: Helping a friend who is using a client side scheduler to run a crystal report of rentals initiated to his field sales team. The scheduler emails the report each day at 3:00 pm. Their end of business is at 5:00 pm. THE PROBLEM: There have been rentals initiated between 3:00 and...

Using Crystal 11.5 accessing SQL server 2008 Problem: Same formula appears in 75+ reports. The formula has changed and needs to be updated in all reports. Questions: 1) Is there a method to locate all reports that use the formula? 2) Is there a method to batch update the formula in all...

My firm uses one database for sales, one for equipment tracking, and one for its CRM. I've been tasked with compiling a report that looks at the sales database and the CRM database. When I try to link fields from one database to the other Crystal presents an error that states different drivers...

Forgot to include the revised formula that Crystal doesn't like. If {Invoice_Detail.INVDTE_32} in dateserial(year({@last visit date}), month({@last visit date}){?Number of months prior to visit},1) to dateserial(year({@last visit date}), month({@last visit date})-0,0)-1 then {@Ext. Price}

I have a report that looks at six months prior and six months after one of our sales people have visited the account. I would like to make the report dynamic, that is I would like to pass a paremeter to the formula so I can adjust how many months prior and post visit the data looks at. My...

Thanks for the fix. I'm being forced to write more and more Crystal and I'm struggling with date issues. Does anyone have a resource, i.e., book, online tutorial, dvd, anything.... they would recommend so I can get a better handle on dates. Thanks in advance for your suggestions. I'm in a...

Crystal 11 SQL Disclosure: rookie with dates. I have a sales force who visits customers. I want to query the customer activity 6-months prior to the month they visited, and then six months after the month they visited. My prior to visit formula appears to be working. If...

Thanks, lbass, I'll give that a try tomorrow. Very much appreciated.

Dgilz, Thanks for the response. The goal is to run the report following month end and gather information for the lastfullmonth and the eleven previous months and report by category for last 12 months on a month by month basis. I understand the lastfullmonth, but you lost me on.. "If you want...