Solved

suppress False column in Cross-Tab table

Posted on 2007-12-05
8
1,269 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
  • 4
  • 3
8 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Can the data be filtered before it is brought into the report?

mlmcc
0
 

Author Comment

by:Forensicon
Comment Utility
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
Comment Utility
Use the select statement you have now but filter it using {YourField} = True

mlmcc
0
 

Author Closing Comment

by:Forensicon
Comment Utility
Thanks for your help with this problem mlmcc
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now