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 derfloh 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: *

  1. AussieLad

    Select once >=5th record reached for Employee

    Thank You both to 'lupins46' and 'lbass'... simple when you know how, isn't it. Much appreciated.
  2. 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...
  3. 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...
  4. 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...
  5. AussieLad

    Group Footer 'Sum Formula' resets at Page Break

    Thanks Madawc, Will gladly accept tips from "the regulars" in this forum !
  6. AussieLad

    Group Footer 'Sum Formula' resets at Page Break

    Thank You (x3) LB !!! You've made all the detailed explanation of my problem worthwhile. (This has been my "You learn something new every day" for today).
  7. 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...
  8. AussieLad

    Group 2 summary totals in Group 1 Footer ?

    Appreciate your help, Madawc and Tomerotum. I used Madawc's suggestion. Many thanks !
  9. 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...
  10. AussieLad

    Uppercase last line of an address field ?

    Thanks for all your input... one feels it's time for some data cleansing, or convincing 'Finance' to uppercase the entire field, (as per Jim Broadbent's very first suggestion). I'll pass on the sentiments to our software vendor's developer as suggested... or maybe not ;-) Cheers
  11. AussieLad

    Uppercase last line of an address field ?

    Me again... sorry to be a pain, but I've struck another scenario with my data. There are instances where there is only one line in the address field, and therefore no Chr(13)'s. (Don't ask me why this is so... I'm not in the Finance Dep't) The latest incarnation of the formula now handles...
  12. AussieLad

    Uppercase last line of an address field ?

    Thanks, gurus... you've been a great help !
  13. AussieLad

    Uppercase last line of an address field ?

    I thought I'd brought closure to my query, but not so just yet. Naith's "WhilePrintingRecords..." formula works fine when my test range of records has data in the address field. However, (and don't ask me why), there are instances where the address field is blank/null. When I run the...
  14. AussieLad

    Uppercase last line of an address field ?

    Thanks to all who responded - &quot;Naith&quot; has given me my solution with his &quot;WhilePrintingRecords...&quot; formula ! Sorry if my initial query was ambiguous, but for those who are interested, the address is in one field as per my original example, ie... 8 Hart St <CR> Newtown...
  15. AussieLad

    Uppercase last line of an address field ?

    Thanks, but wouldn't this make the whole field uppercase ? If this is the only solution, I'll have to advise my management of same... but their spec was for only the last line to be &quot;upped&quot;, eg &quot;NEWTOWN&quot;, and the &quot;8 Hart Street&quot; to remain Proper Case. (Note that...
  16. AussieLad

    Uppercase last line of an address field ?

    Our Creditors system allows for free-format entry of data into our &quot;Address&quot; 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...
  17. 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 - &quot;If NumericText {field} then ToNumber({field}) Else 0;&quot;]... 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