Solved

Crystal Reports Balance Sheet

Posted on 2014-03-26
3
226 Views
Last Modified: 2014-04-03
In writing a Balance Sheet with Crystal Reports, due to rounding, Assets and Liabilities/Equity do not equal.  What functions or formulas can be suggested to address the difference between Assets and Liabilities/Equity?
0
Comment
Question by:garyjgs
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
ID: 39958465
Well, how do you want to "address" the differences?  Ignore them?  Try to "adjust" some figures to compensate for them somehow?  Something else?

 How different are they?  A few pennies?  Thousands of dollars?

 Are the figures in question totals that the report is calculating from a series of detail records (in which case, maybe you want to round some of those detail amounts), or is the report just getting a lump sum for each figure?

 CR has functions like Round that will round a figure up or down, but, at this point, I have no idea if those will help you.

 James
0
 

Author Closing Comment

by:garyjgs
ID: 39972302
This answer reinforces what I have been trying to communicate to a client that I was working with.  Thank you.
0
 
LVL 34

Expert Comment

by:James0628
ID: 39974560
You're welcome.  Glad I could help.

 James
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Store total calculated duration sessions. 44 91
Crystal Reports 11 Multiple Parameters on same field 9 67
Crystal Reports last day of month 2 62
Crystal Reports 12 41
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question