Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: To display null value rows in crosstab Post Reply Post New Topic
Author Message
nikhil_thrissur
Newbie
Newbie


Joined: 10 Jan 2011
Online Status: Offline
Posts: 13
Quote nikhil_thrissur Replybullet Topic: To display null value rows in crosstab
     Posted: 29 Aug 2012 at 11:47pm
Hi,
 
 
I need a report something like below
 
 
Group Region Month1 Month 2 Month3 Month4
US 12 11 14 10
Canada 0 4 3 1
A India 0 0 0 0
US 25 21 20 5
Canada 1 0 4 87
B India 2 65 4 5
 
 
 
But What I actually got was like below. the region row- "India "was not present as all values were null
 
 
Group Region Month1 Month 2 Month3 Month4
US 12 11 14 10
A Canada 0 4 3 1
US 25 21 20 5
Canada 1 0 4 87
B India 2 65 4 5
 
 
Please anyone help me to resolve this
 
thanks
nikhil
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 30 Aug 2012 at 4:05am
In the Customize Style tab of the Cross-Tab Expert, try turning off Suppress Empty Rows and Suppress Empty Columns.  However, you'll also need to set up your data in such a way that you have at least one record for every Region for every Group.  This usually involves setting up some outer joins so that you get the region even if there's no record in the table that has your monthly data.
 
-Dell
IP IP Logged
nikhil_thrissur
Newbie
Newbie


Joined: 10 Jan 2011
Online Status: Offline
Posts: 13
Quote nikhil_thrissur Replybullet Posted: 30 Aug 2012 at 10:50pm
Thanks Dell..
I tried thsi option but it doesn't work
Also the table is already in left outer join
 
 
thanks
nikhil
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 31 Aug 2012 at 3:18am
What table does the country name come from?  What tables do you have and how are they linked together.  I suspect you're not seeing India because there is no India record for the group.
 
-Dell
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 31 Aug 2012 at 7:15am
see if report options and turning "convert database null values to default" and "other nulls to default" works
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