Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Crystal Report - show total in each row Post Reply Post New Topic
Author Message
Radha
Newbie
Newbie


Joined: 11 Mar 2016
Location: United Kingdom
Online Status: Offline
Posts: 6
Quote Radha Replybullet Topic: Crystal Report - show total in each row
    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.


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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

Edited by DBlank - 31 Mar 2016 at 3:00am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.