Crystal financial reports from Peachtree database

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?
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.