Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cross tab Post Reply Post New Topic
Author Message
Set_Shot
Newbie
Newbie
Avatar

Joined: 14 Jun 2011
Location: United States
Online Status: Offline
Posts: 3
Quote Set_Shot Replybullet Topic: Cross tab
     Posted: 15 May 2013 at 10:08am
Good Day To All,
I have a cross tab report that is not working properly.
I have many categories but I only want to be able to do my cross tab on only one.
 
 
 
Agent Name     sub_category                Category 1         Category2    Category3
                       sub_category2                  5
                       sub_category3                  6
                       sub_category4                  1
 
I just want to have Category1, don't want Category2 or category3
 
Any suggestins?
 
Thanks
David Martinez
Dmarz
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 15 May 2013 at 10:31am
Hi David,
 
If Catergory2 and Category3 dont have any values(Empty columns) then Right click on the Cross tab  --> Crosstab Expert --> Customize Style --> Check Suppress Empty coloumns
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Set_Shot
Newbie
Newbie
Avatar

Joined: 14 Jun 2011
Location: United States
Online Status: Offline
Posts: 3
Quote Set_Shot Replybullet Posted: 15 May 2013 at 11:23am
Yes Praveen they do have value, can I supress if he the column header has no value? Is there a way just to filter in catagory 1?
Dmarz
IP IP Logged
bwsanders
Senior Member
Senior Member


Joined: 05 Sep 2012
Location: United States
Online Status: Offline
Posts: 177
Quote bwsanders Replybullet Posted: 16 May 2013 at 2:11am
you can still right click columns 2 and 3 and format them to suppress. cross tabs are tricky. when they do work they are pretty awesome though.  good luck. 
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.