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 Chriss Miller 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. yctsai1

    Crystal 10 Variable Question

    Thanks... found it.
  2. yctsai1

    Crystal 10 Variable Question

    I am looking at a report with following formula Formula Name: SalesTaxClassDisplay Formula: WhilePrintingRecords; CurrencyVar curSalesTaxClass; WhilePrintingRecords and CurrencyVar is system function but where did curSalesTaxClass come from ? there are no formulas or fields with that exact name.
  3. yctsai1

    Lookup Tax Rate

    got it use select expert to make db1 state = db2 state
  4. yctsai1

    Lookup Tax Rate

    I've tried to link the two tables with all different ways but result still same, multiple records for each state in command.statecode db1 and db2 name state wage tax% state What I needto see: NY Name Wage Tax% tax State person1 1000 1%...
  5. yctsai1

    Lookup Tax Rate

    I need to lookup tax rate but not sure how to go about it. DB1 Info.Name, State, Wage DB2 Rate.State, RatePercent On report: Name State Wage Tax Tax = db1 info.wage * db2 Rate.ratepercent there are multiple states in db2 and not sure how to lookup the rate and use it for...
  6. yctsai1

    1 to many table exception Report

    Thanks lbass, 1 more issue, If {table.state} = "NY" and there are no deductions at all, it needs to appear. With the above conditions, where {table.state} = "NY" and there are no deductions to compare to, it is skipped. and doesn't show on report. Tried to add "or {table.state} = "NY" and...
  7. yctsai1

    1 to many table exception Report

    I have two tables Table1.applicantid Table1.state Table2.applicantid Table2.deductions applicantid State deductions (a-z) 1 NY D < hide 1 NY N < hide 2 NY N < hide 3 NY O < show 4 NJ D < show 5...

Part and Inventory Search

Back
Top