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!

Register Log in
  • Congratulations bkrike 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: AussieLad
  • Content: Threads
  • Order by date
  1. AussieLad

    Select once >=5th record reached for Employee

    Our HR Manager would like a report listing reasons for 'Unpaid Absenteeism' in a financial year, once an employee has totalled 5 such days. Layout is as follows... Grp1 = Department Grp2 = Section Grp3 = Employee Name, (showing Job Title, etc) Dtls= Absenteeism Description, Date, Hours The data...
  2. AussieLad

    Multiple date fields using common parameters

    I'm obviously not a Crystal expert, so here's my CR8.5 query... I've created a SQL view from our employee d'base which lists the Emp No, Name, and six separate 'Significant Date' fields. (eg, 'End Probation Date', 'End Temp Status Date', etc). I created '?Date Start' and '?Date End' Parameter...
  3. AussieLad

    Suppress/Exclude records in another group ?

    We have a report that extracts stats from our Document M'ment system. An incoming document is assigned to a Workflow... within the workflow, there are various stages, called "Tasks". (eg, If a document if not actioned within 7 days, it moves from a "Due for Action" to an "Overdue" Task). My...
  4. AussieLad

    Group Footer 'Sum Formula' resets at Page Break

    I am trying to display the "Hours Worked" for Fleet items which are grouped by 'Vehicle Category' [Grp1] then by 'Fleet Item', [Grp2],(to get summary totals of fuel Qty & $ transactions). (n.b. Details section is suppressed). I have also placed the 'HrsMeter' field onto GH2, (ie, along...
  5. AussieLad

    Group 2 summary totals in Group 1 Footer ?

    Probably a simple answer, but help ! (This is as brief as I could be, sorry)... I need to produce a report showing our fortnightly salary info grouped by month, (ie, Grp2), for each employee, (ie, Grp 1). Simple enough. Further though, I also have to EXCLUDE any 'Months', (Grp2), if the sum of...
  6. AussieLad

    Uppercase last line of an address field ?

    Our Creditors system allows for free-format entry of data into our "Address" field... eg, 8 Hart St Newtown What I am trying to do is to create a formula to display the last line of each Address as Uppercase, (as our data has a mixture of Uppercase and Propercase). ie, in short...
  7. AussieLad

    Report containing sub-report with Dummy records

    I have to produce a report based on a range of data from a formula field, [which is in a format - "If NumericText {field} then ToNumber({field}) Else 0;"]... no problem. To do so, I have created parameter fields to select the start/end range based on this numeric formula field... no...

Part and Inventory Search

Back
Top