Main page

products by category report

Description

This example shows how to build a Products by Category Report.

Steps to recreate

  1. Use the Report Builder to create the store_products report based on the store_categories and store_products tables in the InternetDB database.
  2. Remove the Count_product_name Report Label from the 'Category_name footer' section.
  3. Add 4 columns after column 'Price'.
  4. In the 'Detail' section add the following Report Labels: category_run_total, report_run_total, cat_percent and rep_percent into each new cell.
  5. For the category_run_total Report Label set the Control Source property to price, Data Type to Float, Format $0.00, Function to Sum, and Reset At to Category_name Group.
  6. For the report_run_total Report Label set the Control Source property to price, Data Type to Float, Format to $0.00, Function to Sum and Reset At to Report.
  7. For the cat_percent Report Label set the Control Source property to price, Data Type to Float, Format to 0.00% and Percent At to category_name Group.
  8. For the rep_percent Report Label set the Control Source property to price, Data Type to Float, Format to 0.00% set Percent At property to Report.
  9. For the Price, Sum_price and TotalSum_price Report Labels set the Format property to $0.00
  10. Make cosmetic changes as needed by modifying the text and captions within the HTML.

Database Tables Used

Database: InternetDB

Tables: store_categories, store_products