Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Crystal 2013

Crystal 2013

Crystal 2013

Is there a way to show a zero in a column that is based on a subreport if there are not amount returned?

Customer 2016 total 2015 total
abc co 5,000 2,000
def co 3,000
jed co 0 1,000

The subreport is to 2015 total column and it does not return any value if there are not any records for that company in 2015.

RE: Crystal 2013

I only worked in 2013 for a few hours. We tested it and will get it "sooon". In previous versions create a formula:
If IsNull({field}) then

RE: Crystal 2013

Where do you put that formula? I have the sub report as a column in the report.
Main report:
Customer 2015 2016
abc Info from main report info from sub-report

RE: Crystal 2013

In the absence of specific details I am assuming that the Sub Report uses a Summary in the RF section to display the total for the previous year.

I would then replace the Summary field in the Sub Report with the following:


If      ISNULL(SUM({Table.Field}))
Then    0
Else    SUM({Table.Field}) 

If my assumption is incorrect, please provide specific details about the structure of the main report, the sub report and how they are linked.

Hope this helps.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close