Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Crosstab diagram should not show 0 fields Post Reply Post New Topic
Author Message
RickVan
Newbie
Newbie
Avatar

Joined: 19 Oct 2016
Location: Netherlands
Online Status: Offline
Posts: 1
Quote RickVan Replybullet Topic: Crosstab diagram should not show 0 fields
    Posted: 20 Oct 2016 at 10:22pm
Hello fellow Crystal members,

I created a crosstab showing montly revenue over a couple of years. Since november and december are still to come, 0 or - is shown in the table for those months.

I created a diagram based on the crosstab and want the diagram not showing the 0 fields in the crosstab, do you have any suggestions on how can I do that?

Thanks a bunch!

Rick

Edited by RickVan - 20 Oct 2016 at 11:02pm
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 02 Nov 2016 at 6:09am
HI Rick,

Do you have November,2016 and December,2016 columns in your database ? If this data is not available then you will not get this information in your cross tab.

You can go for below work around :

Create a excel, with all years and months and left outer join with your database table.

Now use excel Month column as a column values in your cross tab, rows and summarized columns can be from your tables.

This will display 0 values for November and December.

Thanks,
Sastry
Thanks,
Sastry
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.015 seconds.