Print Page | Close Window

Comparative Income Statement

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2628
Printed Date: 02 May 2025 at 12:37am


Topic: Comparative Income Statement
Posted By: bucky7199
Subject: Comparative Income Statement
Date Posted: 17 Mar 2008 at 6:43am
I have built an income statement using the crosstab object.
 
Now I need to build a comparative income statement, showing deltas (changes) from prior year, month to month, quarter to quarter and year to date. I know that's alot. How do I go about doing this? Can I use the crosstab report object to make this kind of report? I have been scratching my head on this one.
 
Thanks.


-------------
Dan S.


Replies:
Posted By: bonsmcook
Date Posted: 09 Apr 2008 at 7:31am
Hi Dan,

I would build formulas for the deltas--an actual vs budget formula, a current yr vs last yr formula and so forth.  Then, select these as columns into your crosstab just as you would do your actuals, budgets and prior year amounts.

Sandra


-------------
SMCook

Posted By: BrianBischof
Date Posted: 09 Apr 2008 at 11:03am
I actually have an entire chapter dedicated to creating financial reports (income statements and balance sheet). I have each step listed out and explained in full detail. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window