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!

Recent content by jchriste

  1. jchriste

    Capping a derived Field

    Here is the SQL that includes the derived fields. SELECT DISTINCT SUM(DISTINCT @NULLVALUE(REPORTS.V_CHK_VW_HOURS.CHECKVIEWREGHOURS,0) ) , '' , '' , '' , REPORTS.V_CHK_VW_HOURS.CHECKVIEWPAYDATE-20, @LEFT(REPORTS.V_EMPLOYEE.JOBTITLEDESCR,1) , SUM(DISTINCT...
  2. jchriste

    Capping a derived Field

    I have a derived field which calculats total hours worked. I would like to create a field that looks at that field and if the amount is over a set amount 80 it returns 80, but if it is less it returns the calculated amount. I am using ReportSmith and don't have case statement available I can...
  3. jchriste

    Page Break on specific field

    What I NEED to do is have each PO print on it's own page, not just the header. So all the details the page footer, etc. need to print individually. Example: PO #: 500 Details Page Footer New Page PO #: 501 Details Page Footer
  4. jchriste

    Page Break on specific field

    I have created a purchase order form report and I can't seem to get the report to break on the P.O. number which is located in the Page Header area.
  5. jchriste

    Derived Field

    I am trying to take a report that has multiple rows per employee because of education, e.g., 3 degrees and show the data in a single row for each person, how do I do this?
See more

Part and Inventory Search

Back
Top