Print Page | Close Window

Annualize/Projections

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=258
Printed Date: 07 May 2024 at 10:08am


Topic: Annualize/Projections
Posted By: jdanavi
Subject: Annualize/Projections
Date Posted: 28 Feb 2007 at 11:14am

Hi,

I need to annualize/project data for the remaining fiscal year.  I am quite literate in Crystal, but I am unable to complete this task.
 
I was wondering if it is at all possible to annualize/project data in Crystal.
 
Thanks in advance!!
 
Joe


Replies:
Posted By: BrianBischof
Date Posted: 28 Feb 2007 at 11:31am
Hmmm... interesting question. Personally, I would use .NET to build a new data source that does the calculations and print that. But to stay strictly in Crystal Reports would be tough. Not knowing you database structure makes it tougher. My initial attempt would be to create a bunch of formulas to do the calculation but even that doesn't seem like it will work. I wonder if you could create a subreport and use formulas with global variables to get your subtotals from that and then use formulas on these subtotals? Still a longshot.

Another idea would be do use SQL cursors within a stored procedure to pre-process the data and do the projections. Then return all the data as a virtual table.

-------------
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