Solved

suppress False column in Cross-Tab table

Posted on 2007-12-05
8
1,299 Views
Last Modified: 2010-04-21
I am using Crystal Report XI and am trying to create a cross-tab report where the column is showing the results of a formula and the rows are months. The formula returns a boolean variable. The summary field is a distinct count. Right now i have a column for those results returning False and a column for True. I only want to show the True column. I can't figure out how to suppress the False column. Additionally, i have 3 diffferent cross-tab reports each using a different formula in the columns and a date field sorted by month for the rows. I would like to combine these 3 into 1 cross-tab. When i try this though, the columns become nested somewhat. I just want them to go straight across. Is this possible or am i confusing the functionality of the cross-tab. Thanks.
0
Comment
Question by:Forensicon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 20416938
For the first can you restrict the data the cross-tab uses through the select expert?

Another idea is to have a formula
If ({YourField} = TRUE) then
   1
else
   0

Insert that formula into the cross tab as a sum rather than a count

On the other issue, I think you are confusing how a cross tab works.

mlmcc
0
 

Author Comment

by:Forensicon
ID: 20420582
I'm still getting two columns. Here is what it looks like now.


          0.00       1.00
        ------------------------
1/2007      0.00      425.00
2/2007      0.00      378.00
3/2007      0.00      438.00
4/2007      0.00      411.00
5/2007      0.00      395.00
6/2007      0.00      373.00
7/2007      0.00      475.00
8/2007      0.00      411.00
9/2007      0.00      339.00
10/2007      0.00      367.00
11/2007      0.00      387.00
12/2007      0.00      64.00
Total      0.00      4,463.00

Here's what it looked like before:


             False    True
      ____________      
1/2007      1,856      372
2/2007      1,592      351
3/2007      1,983      402
4/2007      1,932      375
5/2007      1,810      354
6/2007      1,623      332
7/2007      1,360      364
8/2007      918      318
9/2007      846      253
10/2007      809      282
11/2007      799      289
12/2007      122      47
Total      15,650      3,739


Also, i'm getting different results for some reason. But i'm not going to worry about that for right now, all i care about is getting the display working properly. So how do i get rid of the FALSE column?

As for the second part of my question, so is what i want to do impossible, could i combine my three formulas into one formula. I would really like to combine all my data into 1 table.
0
 

Author Comment

by:Forensicon
ID: 20420750
ok, i was able to combine my three formulas into one formula so that all my records appear in one table. Here is my result:

            Call Answered      Inbound Call      Voice Mail
Jan-07      1,090      372      793      211
Feb-07      924      351      700      176
Mar-07      1,174      402      829      223
Apr-07      1,112      375      866      192
May-07      1,015      354      832      231
Jun-07      961      332      701      149
Jul-07      827      364      575      103
Aug-07      497      318      435      101
Sep-07      524      253      342      75
Oct-07      456      282      372      83
Nov-07      471      289      343      62
Dec-07      68      47      59      12

I still have the column on the left side that shows all the results that were False. I need to get rid of this.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 100

Expert Comment

by:mlmcc
ID: 20432941
Can the data be filtered before it is brought into the report?

mlmcc
0
 

Author Comment

by:Forensicon
ID: 20442139
You mean by using a stored procedure or something? I suppose it could be. They way i have it now is i have a select statement that selects all the inbound calls (by the way, i am accessing my phone system if you didn't guess alread), then i am using formulas to show the answered calls, calls that went to voice mail and unanswered calls. I'm also going to be showing data for my outbound calls. It would be nice to be able to show the two data sets on one report but if i use a stored procedure or a select statement on the front end this means i won't be able to.

Mlmcc, what do you recommend?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20454678
Use the select statement you have now but filter it using {YourField} = True

mlmcc
0
 

Author Closing Comment

by:Forensicon
ID: 31412950
Thanks for your help with this problem mlmcc
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question