Search results for query: *

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

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

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 I am trying to combine two date columns in impromptu to give the result series 7 by the way for example 01-01-2000 to 02-02-2002 it is important that I see the word 'to' in the column, so have converted the date to a string using date-to-string (Valid from) + 'to'date-to-string (Date of...

Hi Had anyone ever come across DMS-E-SS_INCONS_Logical error in Impromptu. It happened when the database I am connecting to was updated, it appears to have solved itself in all but one report. Wondering firstly why it fixed itself and why if happened! Thanks

Hi I want to split a postcode field in inpromptu, the postcodes can be anything from 5 to 8 characters in lenght with no fixed format in terms of letter number number letter letter etc. I want to seperate them up so that I have the first part ie, PR, or M, then the number which follows, 23...