Link to home
Start Free TrialLog in
Avatar of spattewar
spattewar

asked on

Accessing Bloomberg data using crystal reports

Hi Experts,
I have built a crystal report but there is a requirement now to include one additional column. the data for which will come from Bloomberg, into the report.

The report has the Bloomberg identifiers that are required to fetch the data from the Bloomberg but can it be done.

For e.g.
We want to get the dividend ex date from bloomberg for a securitiy. Is there any way to make bloomberg call from crystal reports OR is there a workaround for this?

Thank you very much for your time!

Regards,
$wapnil
Avatar of Mike McCracken
Mike McCracken

I am not sure if it can be done from Crystal alone.

Can you write a V program that makes the call?
If so you can build it as a DLL with a name like CRUFLbloomberg.dll
Crystal can then use the dll and the functions in it.  You can call the bloomberg function from the dll with the appropriate information from the report andreturn the value.

mlmcc
Avatar of spattewar

ASKER

This is good information. I think I can write a dll that makes the Bloomberg calls.

But then from crystal report can I call functions of the dll to get the data back? can that be done? Do you have any information links on that?

Thanks for your time.

$wapnil

This looks like a very good option. I was unaware of such things.

One more question before we close this. Can I pass an array of values and get back an array of values and then put that entire array in a column on the crystal report.

for e.g.
I have 2 columns in crystal. 1 - Security Identifiers, 2 - Prices.

Can I call my dll and pass the entire column of security identifiers and then get an array back and put that in the prices column on the report?

Thanks for your help.

$wapnil
I don't know.

mlmcc
thanks mlmcc. I will do a bit research online for the array thing.But at least now I know how this can be done using a dll.

If you can provide some good forums on websites for crystal report help, it will be great. Thanks for all your help.

$wapnil
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much for all your information and help.

$wapnil