creating profit/loss statement with crystal report. 3

[New2CR]

Hi,

let's say i have a report that looks something like this :-

Description Value
INCOME
Income1 1000.00
Income2 1000.00
2000.00 ---> subtotal

COST
Cost1 500.00
Cost2 500.00
1000.00 ---> subtotal

OTHER COST
OtherCost1 100.00
100.00 ---> subtotal


???? --->cost + other cost (only)


???? --->Income - (cost + other cost)

so, how do i get the value for those marked with "????"

need help,
New2CR

 

[dgillz]

As a former accountant, I must opine that crystal is a terrible tool to use to create a financial statement. I would highly recommend F9 or FRx as the proper tool for this.

If you are determined to do this with crystal, I would recommend a main report for Income, 2 supreports for cost and other cost, and use shared variables to total the amount from the various reports as needed. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[alley211]

Hi,

I second dgillz's answer.

I have worked with someone that created a financial report.

The report contained over 10,000 formulas in order to generate the report and required an upgrade to 8.5 just to do it.

Buy another program that was specifically built for financial statements and you will be much happier.

alley

 

[chelseatech]

The problem is not so much CR as the fact that Financial Reports and a chart of accounts do not relational DB's and their rules - they are hierachical sets of data.

For one client, my P & L Report was entirely in the Report Footer and was a lot of Running Totals, and formulas adding up running totals.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[New2CR]

Hi...
First of all, thanks a lot for the reply.
I'm sorry but i'm really new to this (CR) and i have no accounting background.
my boss insists that i use CR to create the statement and i think i should take dgillz suggestion. (Income as the main report and subreport for cost & other cost). But the problem now is, (this may sound like a silly question) how/where to declare shared variables? Can you show me one example? I tried to look in the CR Help file but I didn't find anything about shared variables.
thanks in advance... your help is very much appreciated.

really need help
New2CR

 

[dgillz]

Declare all your variables, shared, local or global in formula fields. If you do not specify, they will be assummed to be global.

It may be a dead issue, but point out to your boss that F9 and FRx are partnered with many of the leading business applications today - Macola, Mas90, Solomon, Great Plains, Made2Manage, etc. The reason they exist it because they fill a need and do a better job of it than crystal. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[LMCRYER]

if you still need step by step help with creating your shared variables, let me know and I will send you an example.

 

[New2CR]

hi,

LMCRYER, yes, i'd really apreciate it if you can send me the shared variables example. my e-mail address is q_amidala934@hotmail.com.

Thanks a lot dgillz and LMCRYER

New2CR

 

[Mar101665]

You can also refer to this kbase on Crystal's support site:

http://support.crystaldecisions.com/library/kbase/articles/c2007600.asp

Monica

 

[Nuffsaid]

HEY... HEY...

The Finance Guy here....

If you can't do it with Crystal there's something terribly wrong with your database!!!

Oh Yeah.. dgillz, Frx.. let's talk, would like to see a forum on this topic.

Variables, subreports, A REPORT WITH OVER 10,000 FORMULAS!!!! ... What's up with this??????????

You have to have a table such as {GENERAL_LEDGER_TRANSACTION_DETAIL}

This table should contain all the fields required to prepare your report. (if it doesn't, it should be easy to link to the tables that will provide all pertinant info)

Simply create formulas to "capture" the info you need, i.e. @Income1, @Costs1, @Othercosts, then create a formula such as @total_income - @totalcost.

We use Crystal to prepare some financial statements currently, (Some of us are still "Stuck" on Frx).

New2CR, provide us with a little more info on the the tables you're working with. Perhaps help is not that far away..

Nuffsaid.

 

[dgillz]

I second the idea of a FRx forum, and I will email dave at Tecumseh group suggesting this. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office