Search results for query: *

Sorry for not making it clear. Actually, the data displayed in my origianl posting is a crosstab in the report footer section. There's no data in detail section. What I am working on w/ this report is calculate average shipping percentage for shipped items (2nd column) by State. "% of...

Thanks Turkbear. Average % of "% of shipping" (3rd column) for each state (1st column). Thanks again. :)

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...

Thank you lbass and Madawc. I tried that both group sorting and TOP N to see but didn't work. What I'm trying to do in the report is I'd like to add one more group that show numbers (1 to x) in betwwen G1 and G2. So all the G2 are placed under the numbers based on the @ Num_of_Product formula...

Sorry Madawc, I didn't mean to post twice. I realized that I posted my question in wrong forum but I didn't find option to delete my posting in the other forum.

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...

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...

Hi, You can use IF...THEN statement as well. ex) if PX="02" or PD ="04" or PF ="44" then "AUTO" else if PX="08" or PD ="14" or PF ="42" then "TRY" else " " something like that. Hope it helps..

It works!! Thank you Madawc.

Madawc, please ignore my previous posting. I just understood what you meant. I'm not a morning person!! :) I will go ahead and try your advise. Thank you again!!

Thank you Madawc! Honestly, I don't quite understand what you meant by "not isnull({your.field})". Did you mean I have to do for each data field that I used in the subreport? for ex) 4 fields are used in the sub-report: x.name, x.discount type, x.AMT, x.product so the formula in the section...

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...

Thanks Madawc, since i need to lookup data value customer.emp_name to see if there is anything same or similar to values in employer_name field from excel spread sheet, I am not sure how i'm going to use "like". for example, a formula {customer.emp_name} like "*{sheet1.employer_name}*" will...

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...