Print Page | Close Window

Crystal Report - show total in each row

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21922
Printed Date: 27 Apr 2024 at 7:50pm


Topic: Crystal Report - show total in each row
Posted By: Radha
Subject: Crystal Report - show total in each row
Date Posted: 31 Mar 2016 at 12:49am

This is my data

Product Name     Quantity    SaleDate

A                         2               2016-01-01

A                         3               2016-02-01

B                         5               2016-02-01

C                         7               2016-02-02

A                         6               2016-02-02

A                         2               2016-02-05

B                        15              2016-02-06

C                        10              2016-02-07

 

Now I want to create a report like this:

 

Product Name     Quantity         SaleDate

A                         13               2016-02-05

B                         20               2016-02-06

C                         17               2016-02-07

 

Quantity = SUM(Quantity) for every product

SaleDate = Max(SaleDate) for a product

How do I group it by product and also is there a way where I can get the max date? Since this is my first Crystal report please explain it with steps.


Replies:
Posted By: DBlank
Date Posted: 31 Mar 2016 at 3:00am
click on group expert
select productname as the group on field
select insert summary
select quantity field as a sum for the group level 1
insert summary and select salesdate as a max at the group level 1
move the summary fields to the group header
suppress the detail and group footer sections


Print Page | Close Window