Liveware Publishing Support Forum

Hello,____I was wanting to know if anyone knows how to filter out data in one field, so only certain data is given in the report.____So lets say I have a database of 2000 items that is in our item.dbf file... But I only want items that start with IA... I^m trying to run a royalties report from our Mail Order Manager database. And in the report I^m trying to run I want only all of our Iowa Hawkeye items we sold...____Does anyone know how to do this so instead of getting all the items a customer bought it will only show all the Iowa Hawkeye items a customer bought.____I just started using / learning R&R and I^ve been reading through R&R Report Writer 9 Level 1 book but have not found out how to do this..____If anyone can lend any suggestions, I would greatly appreciate it.

Ok now I think i confused, are you talking in the R&R that I do a filter?____Sorry to be a pain, just still learning R&R and not sure where exactly you are talking.... The Database filter is in the R&R, if so what under. Guess I^m just confused on the whole explaination, I^m sure I would understand you if I better knowledge of R&R..____Just to give you a big picture of what I working with..... I^m trying to run a royalties report for all Iowa Hawkeye items sold since Jan. 01, 2006.. The report must include the customers who the items where sold to, the order #, the order date, the price per unit the quanity sold to each customer, and total sold of each item.... I know the total sold of each item and the total dollar amount of each item will have to be a caluations field and will not come out of the database persay. And all of this comes from 4 different DBF files.....____I hope I explained it well.... I have all the databases linked and have the layout done. I have it to where it shows how much each customer bought, and what items the customer purchased, the invoice date, order #, price per unit.... And I guess theres another part I^m not for sure what to do, and how to create a field that calculates the total quanity sold of each item and the price per item, which would give you the total amount from each item sold.____I do appreciate all the help, and if you have any suggestion on this I would appreciate it...____Thanks,____Nathan

You use Database filter and then select ITEM as the comparison field, equal as the comparison operator and IA* as the compared to value.____This will return all records where the ITEM field begins with IA.____Kathleen__R&R Support____