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
  • 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.
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

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…
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 …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses
Course of the Month8 days, 4 hours left to enroll

616 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