I have this 12 month unit sales report that is helpful in my business. It deos great job but would be much more helpful if i could have option to see few more fields
Here is a link to the report fil
formatting link
I would like to add the option to add following fields /columns
Edit the report with notepad and join the ITEM table to ViewItemMovementHistory so it reads:
TablesQueried = "FROM ViewItemMovementHistory LEFT JOIN Department ON ViewItemMovementHistory.Department = Department.ID LEFT JOIN Category ON ViewItemMovementHistory.Category = Category.ID LEFT JOIN Supplier ON ViewItemMovementHistory.Supplier = Supplier.ID LEFT JOIN Item ON ViewItemMovementHistory.ItemLookupCode = Item.ItemLookupCode"
Then add Item.Price and Item.Cost to your GROUP BY clause so it reads:
I have tried to add those in but i get an error once i try to run the report,
It gives me a line number but than i don't see anything wrong with the line and and its content The line it refers to does not even contain the formulas and text contained in error message.
Any chance you can add those and email me the report. snipped-for-privacy@usa.com
Thank you Much Robert
"c> Edit the report with notepad and join the ITEM table to
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.