Search results for query: *

{OrderDate} <= {CustomerCommencementDate} + 60 Worked out great. Thanks Pete.

Hi All I'm trying to display all orders for the first 60 days only, for each customer. For example Customer A started ordering in June 7th, 2010 Customer B started ordering in November 4th, 2010 Customer C started ordering in July 18th, 2011 How can I have crystal display only data while...

Hi lbass The only ID field that I can think of is the customer number - everything else is different. There are many customers with the same names - just not always spelled the same. I have something similar that already groups by Name and suppresses the same exact spellings already just...

Hi BrianGriffin I'm using sql as my database. That's a good start. I have thousands of different names so how can I go about this easily all across the board? Thanks again

Hi Is there a way to suppress similar names in Crystal Reports XI? It can be either the first name or last name. The number of letters is usually the same just in the wrong places but not always. There are names with middle initials and there are some without. My database contains a lot of...

Hi Madawc That's exactly what I was looking for. I never even thought of using DatePart. Many Thanks

Hi Is it possible to create a date formula to run the previous work day's date that can exclude weekends? For example, if today is Monday and you run the report, it'll show Friday's data. Tuesday show Monday, Wednesday show Tuesday, ect. without having to manually click and select a date...

Many thanks. I've never used that Group selection before but both solutions worked great. Kind regards

Hi I need help with a formula that can suppress an entire order if it contains a certain item. For example, I'd like to suppress the entire order if it contains a TV. Order # 1 item 1: CD Player Item 2: DVD Player Item 3: TV Order # 2 item 1: CD Player Item 2: DVD Player Order# 3...

Thanks TeyBrady and lbass - both formulas work great. I just couldn't figure out how to do it. Many thanks

Hi all I'm trying to sort numbers in crystal report xi but having problems getting it to sort correctly. I have aisle numbered from 1 - 300. For example, I need to sort aisle 5, 54, 80, 128 and 208. It should sort the records like this 5 54 80 128 208 but instead it's sorting it like...