suppress False column in Cross-Tab table

Posted on 2007-12-05
Medium Priority
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.
Question by:Yaniv Schiff
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
LVL 101

Accepted Solution

mlmcc earned 750 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

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.


Author Comment

by:Yaniv Schiff
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.

Author Comment

by:Yaniv Schiff
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.
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

LVL 101

Expert Comment

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


Author Comment

by:Yaniv Schiff
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?
LVL 101

Expert Comment

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


Author Closing Comment

by:Yaniv Schiff
ID: 31412950
Thanks for your help with this problem mlmcc

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

649 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