Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Excluding ***Grand Totals*** Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: Excluding ***Grand Totals***
    Posted: 16 Jan 2013 at 1:48pm
I have a question to ask Crystal Report expert!!!
I have just start using Crystal a month ago. my question is, Can I create a formula to excluded some descriptions that i dont need?

I have a ***Grand Total*** that has appearing in my description table. So there for it make my reports look silly also it created a total amounts even though i didnt even make a group total or sub total.

ex. job#   Description     labour $$     Overhear$$
     1234 Car              200.00        100.00
     3456 Truck            345.00        150.00
    ***Grand Total***       545.00        250.00

I ***Grand Totals*** is under the E_DESC table just like description. Is there anyway to hide it or get rid of it?
I would like to create a group by jobs number and then sub total each job, but the ***Grand Totals*** keep appearing at the top of the reports.

Any help would be nice
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 17 Jan 2013 at 4:59am
Go to the Select Expert.  Select the the field where "*** Grand Totals ***" appears, then "is not equal to", then "*** Grand Totals ***".  This will filter those records out of your report.
 
-Dell
IP IP Logged
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Posted: 17 Jan 2013 at 12:28pm
Thanks you so much!!!!! it works like a charm!!!

if I need to excluding more than just the rand totals in the same table like INDIRECT LABOR how do I do that? the same procedure?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 18 Jan 2013 at 3:13am
In the Select Expert, change the field to "in list" and then enter or select all of the options you want to exclude.
 
-Dell
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.