Crystal financial reports from Peachtree database

Posted by pawel.pietrzak on September 28, 2006, 3:47 pm

Please log in for more thread options

Has anyone attempted to set up Crystal reports to do their basic
financial reporting like Income Statements. The Peachtree Standard
Income Statement is basically useless when you have hundreds of
accounts. I set up an income statement which uses 6 subreports with
custom groups which separate the GL accounts into a meaningful report
which mirrors the income statement we enter into Excel and use
internally and with our board.
The amounts on the report are created simply by a formula adding the
Net Per fields in the Chart Table (DDF). The issue I have is that each
month I need to re-write the report by adding to the formula an
additional Period Net from the Chart Table. Does anyone have an idea
on how to circumvent this issue and write a custom parameter which
would apply a different formula based on a time period chosen. Or a
completely other way to solve this?