Search results for query: *

Hi ther,e been using crystal for years so why don't I know this!!!! Anyway, using crystal 8.5, and in a formula I want to say NOT LIKE, so for instance {field.bob1} NOT LIKE "Customer*" So it picks out everything other than the records starting with Customers. Using SQL 2000 I'm sure it's...

Hi there, I'm using Crystal 8.5 with SQL 2000. The problem I have is gaining a count of unique contacts. I'll explain. I have one table for this report, which contains contacts. It has the company name against each contact, but each contact doesn't have a commen link other than the company name...

Hi there, I'm looking for help with a problem I have. using SQL and Crystal 8.5. I have a report that is basically a quote. I have grouped the report by the product type and currently it works fine and looks a little like this.... Hardware (Group 1) Item Item Name Unit Price...

Hi there, I currently have a table that has a field which represents the log in times of a system. it reports this to a string field in this format.... YYYMMDD_HH:MM The underscore is not there, but it's a space. So at the moment it looks like '20060308 11:22' I'm sure it's not difficult but...

Hi there, I'm using CR 8.5 and I have a table with fields on that make up the address of a company. I have put these fields into a formula which seems to work quite well.... if not isnull ({ADDRESS_shipping.ADDRESS1}) or {ADDRESS_shipping.ADDRESS1}<>"" then...

Hi there, probabley a simple one but I can't for the life of me figure it out. I using SQL 7 CR8.5. I'm trying to show the last 300 records logged onto our system based on the creationdate of the record. I'm having problems limiting them to 300 with counts etc... as I think I'm getting in a...

Hi there, I'm sure this is really simple but for the life of me I can't figure it out. I have a report whist basically just lists records in a table (8.5 SQL2000). I want to be able to say "only show the last 300 records, based on a date field". Obviously when this is run ever few minutes it...

Hi there, I'm using crystal 8.5 with a SQL 7 backend. I'm currently trying to obtain figures for a management report and am having difficulty getting my head around this issue. I have multiple records for a product, each with a value and a start and end date. If I had a contract worth £12000...