I am trying to create a stock status report that shows all items grouped by item group, their quantity on hand, item cost, and total value. We need to have a subtotal by item group. I thought that XL Reporter would do this easily, but I am having difficulty.
In the Report Composer, I can create the listing of items with descriptions, quantities, and item costs, grouped by item group. Of course, I cannot perform the calculation to get the value of each item (quantity * cost). When I generate the report into the Report Designer, there are no errors and the design appears to be created OK. But when I run the report, the spreadsheet comes up completely blank except for column headers.
Can anyone tell me what the problem is?