I have to formulate a report to depict the Items sold for a particular date range according to quantity or value, depending on the choice of the user (the user will choose the Date-range and the Quantity/Value option, maybe through a dialog box). The table being referred to is the “InventTrans” Table. The critical aspect is that the data is to be represented in the matrix form – the Items sold must appear as rows and the dates (to be obtained from the range chosen) as columns. The Quantity/Value for a particular Item sold on a particular date is to appear at the cell formed at the intersection of that Item row and Date column. Also, the same item may be sold more than once on a particular date, thus the Quantity/Value for a Item sold on a particular date needs to be added before it is placed in the Report. The structure of the report is shown below for convenience. Please deliver an early solution. Regards, Joydeep Ghose. REPORT DESIGN. Date(DDMMYY) 30.6.03 1.7.03 2.7.03 3.7.03 4.7.03 5.7.03 MON TUE WED THU FRI SAT G.Total Avg/Day ITEM (Qty-wise) CR 39 34 45 54 60 78 0 271 5.17 Transsitions 50 50 60 0 20 0 180 30 Glass PGX 0 0 0 0 0 0 0 0 Glass PBX 100 40 100 0 0 0 240 40 Glass White 60 120 50 70 0 0 300 50 CR Trans 0 0 0 0 120 60 180 30 Plastic 1.60 30 30 20 40 30 30 180 30 Glass White 1.70 0 60 120 0 50 70 300 50 Spectralite 34 45 54 60 78 0 271 45.17
I am not a programmer, so I can’t give you programming advice; but I suggest that you take a look at Sales Ledger/Reports/Status/Aging Report. Maybe it will inspire you as to how you could build up your report. The report contains open transactions, instead of items, but I think that in structure and function it is basically what you want.