Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Show crosstab even with empty cells Post Reply Post New Topic
Author Message
Andre
Newbie
Newbie


Joined: 10 May 2012
Online Status: Offline
Posts: 2
Quote Andre Replybullet Topic: Show crosstab even with empty cells
    Posted: 10 May 2012 at 4:18am
Dear,
 
I am creating a CRXI report. I use a parameter field. If there are values for a date period for that parameter field I get my values in the crosstab. However if for the date period I do not have any data the crosstab is empty and nothing is visible on the report.
 
I would like that even if there are no values, the Crosstab should be  visible and that the columns have "0" inside.
 
How can I do it?
 
Thanks for your help.


Edited by Andre - 10 May 2012 at 4:19am
IP IP Logged
creportsuser
Newbie
Newbie


Joined: 18 May 2012
Online Status: Offline
Posts: 3
Quote creportsuser Replybullet Posted: 22 May 2012 at 1:01am
Hi, I'm facing a similar problem. Were you able to solve it? How do we display "0" in empty cells?
IP IP Logged
Andre
Newbie
Newbie


Joined: 10 May 2012
Online Status: Offline
Posts: 2
Quote Andre Replybullet Posted: 22 May 2012 at 8:35pm
no I am still looking to find a solution
 
if someone could help me please. thanks
IP IP Logged
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Posted: 22 May 2012 at 10:26pm
I'm not sure if this will work for you, but can you create a formula that says something like  'If isnull(date) then 0 'and use that in the crosstab in place of the actual date.?
 
 
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.