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

  1. nightelfdruidhunter

    how to calculate average percentage?

    Hi i'm trying to get an average of percentage on my report. and this is what I pupolated so far. State # of shipping % of shipping Ave. % ----- ------------- ------------- ---------- NY 4010 40% NJ 1063 11% CT 832 8% TN...
  2. nightelfdruidhunter

    Grouping question.

    G1-Purchased date (in quarter) G2 - customer Id, # (sum of product--count only if they are product group 'A' or 'B') ------------------ @ Num_of_Product ----------------- if {product} = "A" or {product} = "B" then 1 else 0 G3 - product category detail - item list (item name) ex) G1...
  3. nightelfdruidhunter

    grouping question

    G1-Purchased date (in quarter) G2 - customer Id, # (sum of product--count only if they are product group 'A' or 'B') ------------------ @ Num_of_Product ----------------- if {product} = "A" or {product} = "B" then 1 else 0 G3 - product category detail - item list (item name) ex) G1...
  4. nightelfdruidhunter

    How to display message on a main repor if a subreport has no data?

    Hi all, I have a report (main report) that has 6 subreports. I would like to disyplay a text message such as "No Discount" on the main report in the subreport section. Right now, the subreport section in the main report is suppressed if there is no data. Does anyone know if there is a way to...
  5. nightelfdruidhunter

    Searching array data

    Hi all, I have a list of customers with their name, tel, work_tel, employer_name, employer_addess in a excel file. This report will pull all customer information and hightlight their employer name if it is same as the one in our database (customer.emp_name). The problem is the employer name...

Part and Inventory Search

Back
Top