Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Wrong Subtotal Post Reply Post New Topic
Author Message
freeinspace
Newbie
Newbie


Joined: 27 Jul 2010
Online Status: Offline
Posts: 2
Quote freeinspace Replybullet Topic: Wrong Subtotal
    Posted: 27 Jul 2010 at 9:32pm
I am new to CR and stuck with a problem. As i want to subtotal some fields depending on a group but the subtotal values are way high and not equal to the values what are visible. Data is retrieved on the basis of arabic dates. records are grouped by roads names. See the picture below. Also some records are suppressed due to duplication.
Please Help!!!
IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 27 Jul 2010 at 9:52pm
if you are supressing any records, the subtotal will count thaose also, so you plese give the supress condition in main record selection criteria too
Regards
IP IP Logged
freeinspace
Newbie
Newbie


Joined: 27 Jul 2010
Online Status: Offline
Posts: 2
Quote freeinspace Replybullet Posted: 27 Jul 2010 at 10:03pm
I created a new field by name "NEW" who's formula is

"{SECTION.SECID}&{LANES.LID}&{LANES.LANE_TYPE}"

And to suppress this i i used formula {NEW} = previous({NEW})

in section-->Details-->Supress (No Drill-Down)

Now what do you mean by suppress condition in main record section criteria. Where else should i put this formula?


And Thank for the reply


Edited by freeinspace - 27 Jul 2010 at 10:04pm
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.