Search results for query: *

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

I have to provide a report showing length of service of employees over the last two years. I have used the following: if{EMP_RECORD.E_DATE_LEFT}<DateValue (1967,12,31) then datediff (&quot;y&quot;,CurrentDate,{EMP_RECORD.E_DATE_JOINED}) else {EMP_RECORD.E_DATE_LEFT}-{EMP_RECORD.E_DATE_JOINED}...

User keeps spreadsheet for leases. Would like to sort by using the first date in the Lease Commence column. Please Help Thanking you in anticipation. CEG

I have columns in Excel, and there is a need to make all the text uppercase. If I copy the column to word and then back again, the height of rows etc is different. Ultimately this will become an import file for a sql table. Any advice will be greatly appreciated.

Can anyone please tell me where I can sample tests for MOUS exams. Some sample papers would be ideal. Thanking you CEG

Essentially the report uses the Nominal Ledger, and is grouped by a Category name, showing last 12 process periods in columns. The detail is suppressed. Only Group Hdrs & Ftrs showing values are displayed in rows. I have put the Category name as the count field.The back end is Sql 2000. The...