Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Count Records excluded by Select Expert Post Reply Post New Topic
Author Message
JWaldmann
Newbie
Newbie


Joined: 01 Dec 2016
Online Status: Offline
Posts: 13
Quote JWaldmann Replybullet Topic: Count Records excluded by Select Expert
    Posted: 02 Feb 2017 at 8:39am
I have a monthly report of work orders completed by IT. I serve 8 departments and only report on wo’s for 7 departments. (Select to exclude IT dept.) However, I would like a report line that shows the number of IT wo’s and the total number of wo’s for all departments including IT.

Example Report:
Dept 1 – 10
Dept 2 – 12
Dept 3 – 5
Total Non-IT wo’s – 27

IT WO’s - 13
Total WO’s – 40

If I have a Select for the report that states Departments not equal to IT, how can I show the totals?

I hope this makes sense. Thanks in advance for any assistance.


Edited by JWaldmann - 02 Feb 2017 at 9:22am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2017 at 3:35am
one option, rather than excluding non IT, suppress them. That way they are available for counts but are hidden for display
IP IP Logged
JWaldmann
Newbie
Newbie


Joined: 01 Dec 2016
Online Status: Offline
Posts: 13
Quote JWaldmann Replybullet Posted: 03 Feb 2017 at 3:38am
Thanks for the response! I do not know how to suppress one member of a group. IT is simply one of the departments.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2017 at 3:46am
supressing can happen in a sectino (like details or a GH or GF).
In the section expert select the formula box next to the 'Suppress no drill down' option and enter your suppression criteria here.
Something like
Table.Department = 'IT'
This will be basically the exact opposite of your current selection criteria.
Note that you will need to remove or alter your select criteria first.
IP IP Logged
JWaldmann
Newbie
Newbie


Joined: 01 Dec 2016
Online Status: Offline
Posts: 13
Quote JWaldmann Replybullet Posted: 03 Feb 2017 at 5:01am
Hey, once I picked the right @%*# Table, it worked great. Thanks a lot!

Can you assist with getting IT out of the chart at the top as well?

Thanks.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2017 at 6:07am
I assume your chart is grouping on department
create an empty formula field called NULL
create another formula field called Department
If Table.Department = "IT" then {@NULL} Else table.Department

Use this in the chart grouping
IP IP Logged
JWaldmann
Newbie
Newbie


Joined: 01 Dec 2016
Online Status: Offline
Posts: 13
Quote JWaldmann Replybullet Posted: 06 Feb 2017 at 4:30am
Morning Friend,

The Suppress worked so great! Thanks again.

I created the Formulas; however, the result was to put the IT bar first in the list and remove it's label. The bar is still there.
IP IP Logged
JWaldmann
Newbie
Newbie


Joined: 01 Dec 2016
Online Status: Offline
Posts: 13
Quote JWaldmann Replybullet Posted: 06 Feb 2017 at 10:48am
I just ended up making a couple of sub-reports to get the number I needed. Thanks a lot for the help!
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.