Search results for query: *

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

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

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

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

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

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

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

Hi there I am trying to put a simple formula into my worksheet to say: If the number of months between cell A2 and 1st Jan 07 are greater than or equal to 4, then "Yes", else "No". Could anybody help me with this please. Thanks Julie

Hi, I have a stand alone Crystal Reports 9 programme and am wanting to save some of the reports that I have written to a file that my assistant can open. I need her to be able to open the report and refresh it, before printing, with out needing to use my computer. Is there a way of doing this...

Hi there I am writing a report from my payroll system. I need dollar figures of different payments made in the last quarter. When I enter the "Period End Date" into the filter, I am asking it to calculate on the Period End Date "between" 01/01/06 and 31/03/06. My answers are correct, but it...

Hi, I have written a report with column headings. These appear on page one, but I can't get them to appear at the top of all pages. There is probably a simple command for this, but I can't find it anywhere. Any help much appreciated. Thanks Julie

Hi I am trying to make a table using "Cross Tab". The columns are names of unions and the rows are the cost centre of each employee. I want all the people from one cost centre in a particular column to be listed, but when I finish the report, I only get one employee's name in the data field...

Hi I am trying to make a table using "Cross Tab". The columns are names of unions and the rows are the cost centre of each employee. I want all the people from one cost centre in a particular column to be listed, but when I finish the report, I only get one employee's name in the data field...

Hi there I am trying write an IF function that will calculate the number of years between a particular date and an employee's start date. If they have been employed for 2+ years then I want "Yes" to appear. I have put =IF((01/05/05 - C6)>=2, "Yes", "No") C6 being the cell with the start date...

Hi there I have 5 hourly rate fields, as one employee can have many hourly rates for different types of work. My report requires that I pull data for only people getting paid at say $10.00 per hour. This could be in any of the hourly rate fields 1 to 5. If I try a filter on each field - the...

Hi I am struggling with this one and cannot get my report finished. I have a crosstab where my row names come from a formula, splitting payment types into six areas, (ie; Wages, Annual Leave, Sick Leave, Training etc) My columns along the top are pay period dates. I need these six rows to...

I have a cross tab report with fortnightly pay dates running across the top, as column headers. I need to pluck the very last date (from the last column) out and put it into the details section. When I refresh every fortnight another column will be added and this will be date required. Thanks

I have a crosstab report with 6 rows where my data is broken down into. Occassionally there isn't any data relating to one of these rows, so my report drops the row off altogether. I need the row name to still appear, and the column data can just show $0.00 figures. Any help would be...

I have a report which is updated fortnightly with a new column of information. How do I tell a particular cell to read a row in the last column of information. eg: This fornight it will read cell D5 and next fornight it will need to read cell E5, then next fortnight, cell F5 etc. etc. Any...

Hi My lines of data in the details section of my report are still repeating all the time. I have tried to change my linking options, but this is not helping. I have 3 tables linked (all linking at the same point). Thanks