Project Description

a sample collection of sales analysis reports to give you a taste of what we can do for you and how we can help you to better analyze your sales figures

Crystal Reports, Microsoft SQL

one period

columns

code, description, quantity, cost amount, sales amount, gross profit and gross profit percentage

parameters

period selection, multiple grouping options, multiple records selection criteria

two periods

columns

code, description, quantity, cost amount, sales amount, gross profit and gross profit percentage for the two periods

parameters

two periods selection, multiple grouping options, multiple records selection criteria

four periods comparison

columns

code, description, selected value (quantity, cost amount, sales amount, gross profit)

parameters

periods selection, multiple grouping options, multiple records selection criteria

12 months

columns

code, description, selected value (quantity, cost amount, sales amount, gross profit) for 12 months and total

parameters

periods selection, multiple grouping options, multiple records selection criteria

top 10

columns

code, description, quantity, cost amount, sales amount, gross profit, graph based on selected value

parameters

period selection, multiple grouping options, multiple records selection criteria, selection of graph value