Recent content by karengarrette

Jatsingh Sorry long time ago now can't remember what they said.

Thanks Naith I've just tried it on a colleagues machine and it's because I have crystal 8.0 not 8.5!!! strange I know but true Cheers Karen

Thanks Naith for the prompt response, no luck with that though, any other ideas

I have a crystal report which is grouped by document number which has some running totals also. I need to export the filein a fixed format to either txt or asci. Because the contents of the fields can be of variable length, the columns end up out of alignment. Any ideas how I can fix the...

Thanks Kinetic got some help from Cognos is in the end, seems that it was to do with an empty dimension.

Hope someone can help as I am being driven mad. I am building a cube with about 2.5 million rows of data. i have successfully run it here on our server but whwn trying to run on customer server I have this error. TR0220 The temprary file for demand is empty check the data source contains...

I have an excel spreadsheet which contain around 20 sheets all sheets have about 20 rows of data,(some calculations but nothing complex) the file also has an link to an external spreadsheet which it uses to update the figures in the summary sheet. Each of the sheets in the main spreadsheet has...

Thanks everyone, used a combination of VB and Naith's suggestion to write a user defined function to do it.

thanks Ken Too many variables in my report to use this, as I am doing tests on the data, to include or not include in certain circumstances already, and the different possibilities in terms of punctuation make it impossible to use replace. Thanks Anyway

Hi I have a report which takes information from a customer database and arranges it, so that it can be used by a carrier to produce despatch information. The interface that they use does not deal with punctuation, but it is possible that the data might contain punctuation. I want to strip the...

Hi I am importing some data into an inpromtu report for use in a cube which contains customer sales history. I require a sales document number in order to create a unique reference, but unfortunately this number is not available from the sales history. I wondered if anyone has a way of...

Hi all It's sorted, not quite sure what went wrong, copied the impfunct.ini file from another PC re-edited it as nagrajm suggested and I now have the required format. Many thanks everyone for the help and suggestions. Karen

Thanks all, busy today will check all later Karen

cognossolutions et all I have in essence tried this already, but the only way I can see to get the 'to' in is to convert the date to a string, if I do this I get the date format the wrong way around. I think this is the nub of the problem, and the reason why the ini file edits don't work...

I have now! but no luck, I have changed all the ini files that contain date formats. There must be some default setting that is giving me yyy-mm-dd, even if I just enter a straight calculated date field I get that format. Karen