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 Mike Lewis 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. Shtinky

    db2 overview

    Go out and buy Understanding DB2, learning visually with examples from IBM press. It has exactly what you need.
  2. Shtinky

    divison by zero

    Another way would be: if {@BottomNumber} = 0 then 0 else {@TopNumber}/{@BottomNumber}
  3. Shtinky

    Font in formula

    Nice! Thanks
  4. Shtinky

    Font in formula

    CR 8.5 SP3 Interbase Formula: if {@DaysToBill} = 0 then "0" else "NA" Is there a way to alter the formula so that "NA" appears in red font, while "0" remains the default color? Thanks Martin
  5. Shtinky

    Bold text in StringVar

    Hi, Crystal 8.5/Interbase Formula: StringVar Str; Str:= {COMPANY_INFO.NAME} + CHR(13)+CHR(10); Str:= Str + {COMPANY_INFO.ADDRESS_1} + CHR(13)+CHR(10); Str:= Str + {COMPANY_INFO.CITY} + ', ' + {COMPANY_INFO.PROVINCE} + ' '+ {COMPANY_INFO.POSTAL_CODE}; Str; Is there a way to make...
  6. Shtinky

    Restore warning

    thanks for the info, it looks like I'm okay then. I appreciate the insight. Shtinkster
  7. Shtinky

    Restore warning

    DB2 7.2 FixPak11, Windows 2K server I received the following warning after restoring a backup image of one database to another: "SQL2540W Restore is successful, however a warning "2528" was encountered during Database Restore while processing in No Interrupt mode." I haven't been able to find...
  8. Shtinky

    Conditional Formula

    That worked great, thanks!
  9. Shtinky

    Conditional Formula

    DB2/Crysal 8.5 SP3 Hello, I am working on a delivery receipt report for a transportation company. I am having a little bit of a problem with a Hazardous materials description that I'm trying to create. Each and every good that is defined as Hazardous by the United Nations is given a unique...
  10. Shtinky

    TRIM Formula

    Hello everyone, CR 8.5/Access DB I am writing a report for our Sales team. The report is basically a listing of our Sales Reps, and the customers assigned to each rep. The report is based on a single table, {Customerlist1} I am having a problem displaying the customer name for each customer...
  11. Shtinky

    Running Total/Distinct Count issue

    Thanks lbass and Madawc for your comments and ideas shtinky
  12. Shtinky

    Running Total/Distinct Count issue

    CR 8.5 INTERBASE I'm having an issue with running totals using distinct counts. I am writing a report that includes running totals based on freight bill numbers in order to find the number of shipments per customer in our database for a selected year (parameter). I have created a RT for the...

Part and Inventory Search

Back
Top