INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

*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.

Jobs

Crystal 2013

Crystal 2013

(OP)
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
0
else
{field}

RE: Crystal 2013

(OP)
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:

CODE

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.

Cheers
Pete

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!

Resources

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