Recent content by adam7

Knew it was simple!!! Thanks a lot for that.

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

Ok well you asked for it!, This is very difficult to explain. Against each item under hardware there is a support cost, which when tallyed make the support total. However they wanted all support costs in one section, so I created a sub report which filters for the same items in the...

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

Thanks for that. I've got a feeling you spent about 2 mins on that, where as it'd taken me all day, so you've saved me tons! Thanks again Adam

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

Easy when you know how!! Thanks a lot for that

Easy when you know how!! Thanks a lot for this.

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

Ok, the report I need shows the last 300 records logged. I want these grouped together by how long it took them to be closed. In group one I'm using a straight forward createdate sorted. In group two I have a formula that splits these into time it took to close the record (datediff formula...

Hi, supressing the fields doesn't really help, as I also have a graph and cross-tab on there that's still looking at all of the records, not just the ones supressed. I really want the whole report to only look at the last 300 records before it starts doing any of the grouping etc... Is this...

Yes, it's the createdate field that I'm using. I just need it to display the last 300 records based on this date field.

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, thanks for your help, with a little meddling I've sussed it out. Cheers