Solved

suppress False column in Cross-Tab table

Posted on 2007-12-05
8
1,290 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
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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

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…
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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