Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SamLN
  • Content: Threads
  • Order by date
  1. SamLN

    Sub Report Question

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

    auto increment code

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

    Using a Summary field as part of another formula

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

    using a calculated figure in my selection criteria

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

    formula syntax

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

    Help!! - Parameterised Report with Arrays and formulas

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

    nagging report setup issues

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

    help with report format

    Hi Tek Heads! needing some advice on the simplest way to construct a report on Employee Service Milestones (Anniversary's). Essentially the end user will use parameters to select a start date and end date, and a service milestone (5 yes, 10 yrs etc) and all staff who have a service anniversary...
  9. SamLN

    date formula

    Hi all tek heads I need to report on the day of the week that a birthday will fall in the current year. something like birthday is 18/04/1971 which becomes 18/04/2013 therefore day displayed in the report is THURSDAY. if I ran the report next year, the day would be FRIDAY (if the 18/4/2014 is a...

Part and Inventory Search

Back
Top