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
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
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
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
Here is a white paper on how to do it in VB
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/0024f60d-751e-2b10-dea0-b1b8f4a297cf?QuickLink=index&overridelayout=true
mlmcc
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/0024f60d-751e-2b10-dea0-b1b8f4a297cf?QuickLink=index&overridelayout=true
mlmcc
ASKER
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
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
mlmcc
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for all your information and help.
$wapnil
$wapnil
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