Count Records excluded by Select Expert
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22220
Printed Date: 27 Apr 2024 at 7:41am
Topic: Count Records excluded by Select Expert
Posted By: JWaldmann
Subject: Count Records excluded by Select Expert
Date 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.
|
Replies:
Posted By: DBlank
Date 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
|
Posted By: JWaldmann
Date 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.
|
Posted By: DBlank
Date 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.
|
Posted By: JWaldmann
Date 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.
|
Posted By: DBlank
Date 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
|
Posted By: JWaldmann
Date 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.
|
Posted By: JWaldmann
Date 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!
|
|