Skip to Content
0
Former Member
Apr 01, 2011 at 02:00 PM

MySQL multiple datasources

14 Views

This is a little complicated so please bare with me. I have never created a report with MySQL and am a little unsure how to approach this issue.

I have 7 Databases all on the same server with the same table names and column names. I have already made the database connection with two of them in Crystal Reports X and have made their links the same, but the datasources are not linked together.

Here is where it gets interesting. The requester would like the combined list of all rows found in the forum_id field from all the database and which database each forum_id came from. The forum_id are also under a list of parent_id's that could be the same for all the databases or could not be, and they have to sorted under their respective parent_id's.

Any suggestions how I can combine these databases? And still show where the Forum_id is being pulled from?