We help IT Professionals succeed at work.

Accessing Bloomberg data using crystal reports

spattewar
spattewar used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Obviously this site for asking questions.  I am not that familiar with other sites

The SAP/Crystal site is good once you learn how to navigate in it
http://www.sdn.sap.com/irj/boc/support

mlmcc
Thank you very much for all your information and help.

$wapnil