Solved

Creating a financial median function in Crystal Reports.NET

Posted on 2006-06-14
3
260 Views
Last Modified: 2006-11-18
The median function built into Crystal Reports.NET uses a statistal median where the lessor of the middle values is discarded. I need to use a finanical median in my report. The financial median takes the two middle numbers and divides by 2 to get the median.

Does anybody know if there is a function to calculate the financial median in CR.NET?

Any help is greatly appreciated.

-Eddie

0
Comment
Question by:FastEddie___
  • 2
3 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 16907051
There isn't a built-in function however you can use formulas to calculate it yourself.  There is a sample crystal report that contains the formulas to do this: http://support.businessobjects.com/communityCS/FilesAndUpdates/median.zip.asp

frodoman
0
 

Author Comment

by:FastEddie___
ID: 16907567
Thanks frodoman.

I downloaded the zip but I couldn't get the .MDB database file to open. It is either an old version that can not be converted or corrupt and the readme.txt file has a lot of strange charactors in it.

But this does get me going in the right direction.

You wouldn't happen to know of any other resources?

-Eddie
0
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 16910686
Eddie -

I wouldn't even worry about the .mdb database.  Just open the .rpt file and look at the formulas that are in there - that's really all you need.

frodoman
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A short film showing how OnPage and Connectwise integration works.

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now