cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to connect to Mysql multiple databases?

Former Member
0 Kudos
52

Hi all,

Is it possible to connect to 2 or more Mysql databases from a single report using Crystal report and if yes, then how can I do that ??

Thanks,

Prashant

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prashant,

you can user Business view manager to connect to more than one datasource using Dynamic data connection.

here is the link for a PDF which contains all the details

[BVM|http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bv_admin_en.pdf]

hope this helps

Regards

Aditya Joshi

Answers (2)

Answers (2)

ido_millet
Active Contributor
0 Kudos

You can simply use the Add Database option to add more data sources to a single report. The limitation is that joins across data sources must be limited to a single column.

Another option is to use subreports and instead of joining, use a subreport link.

Former Member
0 Kudos

Hi Prashant

You will have to create a Buiness View in which you can connect to more than one database and create a Crystal Report based on it.

Regards

Ashwini Yadav