Liveware Publishing Support Forum

I^m trying to create a report where:____- a particular Code is assigned to each inventory item. There would be multiple inventory items associated with each code. I believe this code would print out in a category header field.____- The category footer field would contain the description a description of the code, and then it would print a sum of the total inventory items currently associated with that code. (we do not want a detail of the inventory items)____- We also want the report to print out the codes when there are no inventory items associated with it (so we know when something is out of stock) ____- We also want the report to sort all of the codes in a particular fashion.____It would look something like this:____Code: A__Description: Red Oak Total in inventory: 600 board feet____Code: B__Description: Cherry Total in inventory: 0 board feet____Code: C__Description: Poplar Total in inventory: 1000 board feet____Right now I can only get the report to print the codes when there is something in stock associated with that code. I can^t get the codes to print out when inventory is zero for that code.____I would greatly appreciate help with this!__Thanks!

Do you have both a code table and an inventory table and a relation from code to inventory? If so, make sure that the failure action on the relation is Blank rather than Skip so that codes with no corresponding inventory records are retained in the composite result set.____Kathleen__R&R Support

We created the codes in Report Writer (they don^t have a table in the database). So, a product in our inventory database will have a tag assigned to it, which contains all of the information on that product. We manually add this new code to the inventory tag (they are then in the same table), then Report Writer knows which products fall into which code.____We want the report to print codes, even if they don^t have an inventory tag/item associated with it.____Is this possible?

Do the codes need to be setup in a table (in the database)seperate from the inventory tags, in order for this to work as we want it to?

Yes if there are codes that have no inventory items.____Kathleen__R&R Support