Modification to custom report in aspdotnetstorefront. Programmer must have previous aspdotnetstorefront experience.
## Deliverables
I have a report that shows sales by Section in aspdotnetstorefront. Some products are in two sections. You must understand the underlying database structure to bid on this project.
The issue with the report, is that if a product is in more than one section then the sales get reported twice (once in each section). This is due to the join on the table productsection between product and section.
I need the query modified so that the report will only show the sale of the product in the first section found.
I will provide the original report and you will be delivering the corrected version of the report. You will need access to aspdotnetstorefront 8.0.1.2 as I cannot provide access to our secure server to outside users.