Search results for query: *

Aha, that'll teach me to make assumptions about how that was going to work - perfect now, cheers.

That looks like it should do the job, however the formula editor doesn't recognise From as a function (i.e. it doesn't go blue) when I check the formula I get a remaining text does not appear to be part of the forumla error. Any ideas?

That looks like it should do the job, however the formula editor doesn't recognise From as a function (i.e. it doesn't go blue) when I check the formula I get a remaining text does not appear to be part of the forumal error.

Using Crystal Reports 8.5. I want to display the date range that is used in a report at the bottom of the page. I have found the special function that displays the record selection criteria formula but this is no use to me as I want to show just one of the criteria that is set rather than all...

Excellent, sorted now, I was playing with IF statements but not being aware of the ISERROR function couldn't get them to work. Cheers Tim

I have a problem with the use of the getpivotdata function in a spreadsheet I've just created. =GETPIVOTDATA("Sum of DOZENS",Pivot!$A$3,"REP",B11,"SUPPLIER",$A$6) For the most part it's working fine, using the cell references to retrieve the data I need on another sheet. However I've now run...

That just occurred to me and it solved the problem, however I don't understand why the problem only arose this time around. Both times I've been exporting from a string field but with seemingly different results.

Not sure if this is a Crystal or and Excel problem. Essentially I have been asked to populate someone elses spreadsheet with some data I can get via an existing Crystal report. To do this I have exported the report to an Excel file and then created VLookup formulas in the existing spreadsheet...

Spot on, Cheers, Tim

Thought this would probably be fairly simple, thanks. I now realise I forgot a potentially more complicated part. Where products come in more than one size i.e. halves, bottles, magnums etc. then the last digit depicts this, e.g 2 for 24 halves and E for 12 halves. Can someone offer a formula...

I am using Crystal Reports 8.5. I am writing reports to analyse sales of wines generally using their bin number to sort/group. Each product has a unique first 5 digits 12345 then the next three digits are the vintage e.g. 01 and a letter/number related to the case/bottle size 1 / A. Can...

My company has recently moved to a new set of computer systems and is using Crystal Reports 8.5 to generate reports. I am trying to build reports that show sales by Rep, Customer, Product, Supplier etc. I have managed to build basic reports to do this but have another problem. The computer...