Create a form with:
[items] listview, [Groups] listview , [Add item] button, [Add Group] button, [preview list] button, [generate report] button. FromDateTimePicker, ToDateTimePicker
Add item Button: allowes user to select items based on UPC or Name [ from Inventory table ] then add them to items listview
Add Group button: allowes user to select groups from inventory table then add them to group listview
Preview List button: will generate a report in report viewer of all items in listview
generate Items Sales Report Burron: will generate a report [in report viewer] from [sales table] with details and totals of all items listed in items listview containing sales graph for the selected dates.
generate group sales repport button: will generate a report from [sales table] for all items which their upcs match the upcs in inventory table for all groups codes listed in groups listview
Reports will have print, Save AS (xls, pdf, csv) option
program developed in Visual basic 2005 and sql 2005
database tables will be provided.