Search results for query: *

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

Hi there, thanks for the response. This does seem to have limited the records but it's actually filtering out records from the start of the database, so I think it's the first 300 records where the date field exists, which would make sence. However, I need it to look at the last 300 records...

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, thanks for the response. However, creating groups by the month isn't the problem really. I'd group by say contract ID to give me a list of all. Then total each line to give me the contract value. Also add the contract length to each line. Then across the top I'd write headings of Jan...

Hi thanks for replying. It's group by the contract name which is a formula (all works fine). At the moment the End date of contract 1 is Jul and contract 2 end date is March. I'm having to write each formula to say if end date in Jan then total etc.... Currently I can get it to show each month...

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