Recent content by CEG

ColumnG =Group2 Summary of ({@ActualIncomeCostsDiff}-{@BudgetMargin£}) Column H Group 2 (this formula in Group 2 footer (Sum ({@BudgetIncomeVar£}, {@CostCentreSort}) *{@BudgetMargin%CC} /100) Column I Group 2 (This formula in Group 2 footer) Sum ({@MarginVarianceTotal}, {@CostCentreSort})...

Unfortunately this does not work. The result of the Summary is Group 2 Total Sales - Group 2 Budget Sales. Thanks for your help CEG

Hi, Crystal Reports Version 9 The number is a number (Insert summary in Group 2 footer) The data source, ODBC Sql 2000. Kind regards CEG

There are two groups in a report Group 1: Region (ie, HomeCounties,Midlands,Scotland) Group 2: Costcentre (ie, Bracknell,Maidstone,Birmingham,Edinburgh) One column (shows the cost centre summary) has a summarised field with values 6059 -3643 -288 -11710 60 11164 This should give me a...

Thanks, Geoff. Appreciate the advice Here goes. The database is in Sql 2000. The version of Crystal is V8 CEG

Hello, Need help with the following: There are sites, and people work on them. Each employee has a unique number for the duty performed on that site (showing date etc). How can I report the Last Duty Number for either the site or the employee? Thanking you all in anticipation.

Thanks for your help guys. It works great!!! Will just have to get my head around all the logic in the formulae. CEG

Have tried the new formulae but still come up with the same message A subscript must be between 1 and the array. Appreciate your help CEG

Thanks Rosemary, I can see the plot. The purpose of the split is that in the address data if used for mailing labels etc. there are a lot of blank space, if I could split this and put them in as lines with suppress if blank etc. I opted for the first formula which said No errors found, but...

I am trying to use the formula Split on an Address field. In the database the whole address is held in one field, using the Manual Line Break, to separate the lines.Hence the following formula to provide 3 address lines. Address1: split ({SL_Account.Cuadress],chr(13),1) Address2: split...

Thanks for your help. DB is now functional.

Thanks Andy, I have tried this, but it just does not complete. Is this because the db is updated using the Intranet, so there is always a job running? Thanks

Please Help! I have a Server Mars1 which has active databases, users logged on, reports request, etc. Have been given another Server Mars2 on which to create a test bed environment. Created an empty db on Mars2 Copied the Backup file (.BAK) from Mars1, to Mssql/Backup on Mars2 Message...

The db is Sql2000. There are letters in required folder. The function is to send either a single letter or multiple letters. User selects a recipient, then the letter ie 'This office is relocting etc.....' Message reads 'Starting Mail Merge' Started Word. The mail merge data set returned was...

Many thanks. Why I could not see it is a mystery. Thanking you once again.