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 TouchToneTommy 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: uachap
  • Content: Threads
  • Order by date
  1. uachap

    Do I need a subreport?

    Hello, I have a report that currently has 5 groups. Those groups are: Region Home Store Name Worked Store Timecard Date & hours Worked Store totals Name totals Home Store Totals Region Totals At the end of each break for level 2, I'd like a summary of...
  2. uachap

    Suppress group headings

    I am running Crystal v.8. I have two groups in my report. Region (1) and Department (2). My detail line will only print if the total hours for an employee in that department is over a parameter driven number. I have under detail format section > suppress > x-2 the following: {@TOTAL} <...
  3. uachap

    Query with Subquery and parameters

    I need to have this as my query in Crystal. SELECT DISTINCT A.PERSONNUM, A.PERSONFULLNAME FROM VP_DTC_BASESTORE A WHERE EMPLOYMENTSTATUS = 'Active' AND HOMELABORLEVELNM4 = 'F' AND A.PERSONNUM NOT IN (SELECT DISTINCT B.PERSONNUM FROM VP_DTC_BASESTORE B WHERE B.DATE BETWEEN fromdate AND todate)...
  4. uachap

    Using DistinctCount in a Cross Tab

    I am trying to create a cross-tab report that will only print data if employee data exists for 5 consecutive days. So I'm trying to use the distinctcount function with this format: DistinctCount({table.DATE},{table.PERSONID}) => 5 I'm doing this in the selection criteria > group function...

Part and Inventory Search

Back
Top