How to Store the Data from a Column from a database into an array 1

[CrystalMule]

Hi,

I Had Problem with the Arrays.If any one can Help that will be Great.

Problem :
I have to move all the data from the datacolumn into the Array and then How to use the IRR function in Crystal Report.


Thanks,

Ravi

 

[synapsevampire]

You can generate the array using a formula in the details section (assuming that you have all of the unique values in the details):

whileprintingrecords;
numbervar array MyValues;
redim preserve MyValues[ubound(MyValues)+1];
MyValues[ubound(MyValues)]:={table.value};
1

The last value is simply to get around the fact that Crystal can't return an array in a formula.

Then in the report footer try:

whileprintingrecords;
numbervar array MyValues;
IRR(MyValues)

-k

 

[yardigal]

Hi Everyone,

I am working on what sounds like a similar project. I am also having a lot of trouble. I used your suggestion (above) but am running into errors:

"numerical method did not converge; try another value for guess"
&
"The values array argument of IRR must have both positive & negative entries"

The first error message, I think I've worked through - but the second one is proving to be a challenge. How do I test for cash flows that do not include at least one positive and one negative, with out eliminating those cash flows from the report entirely (I still need them to calculate other summaries within the report)?

Any help would be greatly appreciated!!

-SB