Recent content by sprog

I have a report that shows lieu days owing, average hourly rate and average hours per day. My last formula is the total value of days owing (eg days x average hours per day x average hourly rate). I want to put a sub total at the end of each group. I would normaly insert "sum", but because...

Wow, so simple - why didn't I think of this? Thanks so much for your help.

I have a list of data, and only want records that have a number in one of the cells. Some cells have zero values, and I don't want any of this data to show on my report. Example of report: Name Total Days Owing Hrs Worked Value of Hrs I only want information to show up if there...

Thanks for your replies. Yes, it just comes back with this: "Error" under that is X.1 Rounded and then under that is {@Balance} 11.1304945055 and under that is var result:9.5 Thanks Julie

When I hit refresh, the first two pages of my report are fine, and then when I go to page 3 onwards it automatically flicks back into the Formula Workshop Area, and over on the left hand side there is a Folder called "Error" under that is X.1 Rounded and then under that is {@Balance}...

Hello there I have a formula in one of my reports: whileprintingrecords; numbervar result; result := truncate({@Balance}); if {@Balance} - result >= 0.5 then result := result +0.5; result; I have been using this report for a couple of years now and just "refresh" after each pay fortnight...

Thank you very much for both of your replies. Your CountIf function has worked perfectly John. I guess this was rather simple. Sorry am a bit of an amatuer and spent many hours in the Excel help, but still not able to find the answer. Your help is much appreciated. Julie

I have a spreadsheet with 5 columns for each day of the week. The rows are student names, and for each student I have numbers of hours that they attended a holiday program. Somedays have no value. We need to charge $10 per day for those who attended for 4 hours and less and $15 per day for...

Thank you very much. This worked perfectly! Julie

Hi there I have written a very simple report listing total staff and if they are full time or part time. My 2 formulas are: if {Employee.HoursPerPeriod} >= 60 then "Full Time" and if {Employee.HoursPerPeriod} < 60 then "Part Time" I need to calculate percentage of Full & Part time. When...

Thank you for all of your replies. I am sorry that I have missed out information. I am using Crystal 9.2 and my report is a crosstab. I want it to look like: P/E 01/07/07 P/E 15/07/07 Ordinary Time 250 253 Orientation 12...

Hi there I have written a report, where I am wanting to show all "Payment Names" and the hours paid for each pay period. Because all payments are not used every fortnight, the payment name is omitted, but I would like it to show up with a zero value. Example of my current formula: if {pay...

Thanks very much for your help. However, I don't know how to do "Left Outer Join". I've checked the Crystal Help, and it tells you what the function does, but not how to set it up. Is it simple enough for you to tell me? Thanks Julie

Hi I have written a crosstab report which needs to show all types of payments per pay period. It is working okay, but because I export it to excel and from their copy the info into another report, I need the lines to stay the same. So how do I get it to print a payment which has no info in it...

I just basically need to know if an employee has been with us for 4 months or more, then they will be entitled to a discount scheme we have. I have their start date. So need to ask if the difference between their start date and 1st of Jan 07 is 4 or more months, then "Yes" else "No". I...