I have upgraded Quick Reports for DOS from 6.1A to 6.5A. I am having trouble making a report from IC6.5A. We have 14 inventory locations set up in IC. I can not generate a report with multiple location Qty on Hand listings on a single row. The report displays each quantity on hand in a different row.

Hello Tom,

This is due to the structure of the Qty by location file. To get quantities for each location listed side by side, you must create formulas to test the location code field for each location. For example, for Location VAN, the formula would be:

if Location code = "VAN" then Qty on hand else 0

Once the formulas are created, subtotal each one on change of item number. Because this report will print a detail line for each item/location, the final report should be a summary report. Go to Edit, Sections, Details? and set Print section to no. This will limit the report to one line of information per item number.