×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

Can't figure out this Crystal Reports issue - totalling..

Can't figure out this Crystal Reports issue - totalling..

(OP)
THis is a weird one that I can't figure out.  I have 8000 detail records in this report and here is the data in each detail record:

Jan Feb Mar     Total Units
3   6   25         Not Printing Total
4   7   12         23

For some reason the first record does not print the Total Units value and the remaining 8000 do. All the total is is a formula that adds up the other variables to its left...

ANy help would be appreciated..

Bessebo

RE: Can't figure out this Crystal Reports issue - totalling..

You should post your formulas if you have a formula question, and post the table design.

If you have fields called Jan, Feb, etc.

The formula should be simple:

{table.Jan} + {table.Feb} etc...

Perhaps your showing some totals, you've supplied too little info to take it beyond this.

-k

RE: Can't figure out this Crystal Reports issue - totalling..

(OP)
OK,
Here is the formula:

{Jan_CY_Units} +
{Feb_CY_Units} +
{Mar_CY_Units} +
{Apr_CY_Units} +
{May_CY_Units} +
{Jun_CY_Units} +
{Jul_CY_Units} +
{Aug_CY_Units} +
{Sep_CY_Units} +
{Oct_CY_Units} +
{Nov_CY_Units} +
{Dec_CY_Units}

I'm actually totalling a full year of units but I just showed 3 before just for simplicity sake. It is really straightforward.  The very first detail line does not show the total but all subsequent detail lines show the total formula. It's bizarre..

month  j f m a m j j a  s  o  n d    total

detail 1 2 7 8 2 4 5 6 12 10 11 8

detail 4 5 9 2 3 8 9 2 11 23 22 7    105

Bessebo

RE: Can't figure out this Crystal Reports issue - totalling..

One or more columns are probably null.

Try setting File->Report Options->Convert null value to default.

This means that you will NOT be able to check for nulls though.

An alternative is to make sure that you do NOT have any nulls in each column using an isnull check.

-k

RE: Can't figure out this Crystal Reports issue - totalling..

(OP)
you were right.  I figured it out earlier today.  i did not have the first record initialized and it had nulls in there.  that's why it did not total...

thanks,
bessebo

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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!