Search results for query: *

Hi Bob thanks for your reply A time sheet record is only created when a time sheet is submitted, so there are not any NULL records. The data required for the report is the employee table "EMP" (emp no, name, pay location, department, etc.). The time sheet data has been collected with a command...

I think what I need is a variable to collect all of the employee numbers in the main report, and then the sub report to only display employee numbers that are NOT present in the variable from the main report....... Not sure how to achieve this or if this is the best method.

Hi Tek-heads I have a crystal report based on Time sheet data, but I also need to include in the report the names of employee's who have not yet submitted a time sheet. I was thinking of using a sub report to show all employees without a time sheet. Is it possible to create the sub report...

Thanks Pete, I anticipate that records will be sorted by Position number, hopefully wont require grouping either. appreciate your reply and will create report as per your suggestions and see how I go! Thanks again, Sam.

Hi, I have been asked to create a report with a feature that i am not sure how to achieve. we are reporting on position codes and often there is more than one employee using the same position code as another. I have been asked to auto increment any position code which appears more than...

Thanks Pete, this works, thanks for your help and prompt response. Sam

Hi again I want to use a summary field as part of a formula to calculate a variance figure. I have a grouped by Employee number, and applied a summary of the "net hours" which sits in this group header. I have a second field in the group header which is called "monthly hours" (which is a...

thanks, that was very simple but worked very well. Sam

Hi all firstly I apologise in advance for my lack of crystal knowledge! I am using crystal reports 2008 The purpose of the report is to find which employees have had more than 173.33 hours paid to them. There may be anywhere from 1 row or data per employee to 50 rows per employee. I need to...

Thank You that worked[dazed]

Hi smart people! I cant quite get the syntax of the following formula correct. I want to say if {PERSON.PERSON_POSITION} = 'Law Clerk' and {PERSON.EMPLOYEE_NO} is not either '252' OR '296' OR '336' then "LC" else "XX" seems really simple but just cant get it to work. I tried - if...

Hi LB, thanks for all your help. I still have questions, so I have reposted. I didn't want to keep bothering you, but have been very helpful thus far. (feel free to answer the new post if you want) Sam

Hi smart people, I have a report which I am nearly there with but need some help to get it over the line. kindly someone has helped with the record selection formula, but because I don't understand it, its making the rest of the report formulas difficult for me. the reports purpose is to allow...

Ok, have played with it some more. Changed the future anniversary milestone formula to: numbervar j := ubound({?Anniversary}); dateadd("yyyy",j,{PERSON.START_DATE}) which I have no idea if its right or not (just trying to make sense of your formula). Saves the formula without error, but when...

Hi LB thanks for this but I am still getting errors. At this line x[i] := {PERSON.START_DATE} it errors with "A date is required here". I attempted to amend so it became- x[i] := date({PERSON.START_DATE}). which allowed the formula to save but then got an error saying "this array must be...

Hi LB, thought i'd give your formula for less than 1000 records a try. it errors initially with what I think is an additional bracket at )); When I remove a bracket it then errors and says I need an array at the {milestone} in the line "numbervar j := ubound({?milest});" Sam

Hi Ken, its actually at the parameter stage. The user selects a start and end date, both of which fields have a calendar to select from. but if the want to use the quicker option and just key in the date ranges it needs to be mm/dd/yyyy, which is not natural for Australians! Sam

Hi Ken, I mean Crystal Reports 2008. Thanks for the assistance on the second question. Do you have any suggestions for the parameter date display? Sam

Hi, I have a couple of questions about report format in CR 8, I'm wondering if anyone can help: 1: using date paramaters and I want to change the display of the date to the user. currently its mm/dd/yyyy and I want dd/mm/yyyy 2: using cross tabs in report header, want to have page number etc on...

Thanks so much LB, I cant guarantee that there will be less than 1000 records so can you tell me what's required in that instance. I really appreciate your help.