Executing a forumula on break in Group Header

[jakecolman]

Crystal XI with Oracle 9

I have a group header, grouped by currency, that sums up numbers and displays some indicative data. I need to fetch an exchange rate from an unrelated table (linked by a pseudo-key created via a formula), once per currency, so that I can display the exchange rate for that currency as of a specified date. This will allow me to convert the summed up numbers into an equivalent currency using that exchange rate.

What is the best way to achieve this? Is there a way to specify a formula that will be triggered when the group header breaks on currency?

Thanks.

...Jake

 

[dgillz]

Your comment about group header concerns me. Why not in the group footer?

Just create the formula needed:

Sum({YourField},{YourCurrencyField})*{YourCurrencyXchgRate}

And place it in the group footer.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Or you could place Don's formula in the group header.

-LB