MySQL multiple datasources

[Former Member]

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?

[Former Member · Accepted solution]

are you creating a stored procedure in the sql server management studio?

[Former Member · Accepted solution]

No I am not.

[Former Member · Accepted solution]

You are doing this directly in crystal reports?

[Former Member · Accepted solution]

Yes, that is where I am doing it because I only have read writes to these databases.

[Former Member · Accepted solution]

who created the xml file? i would speak with them about adding your data

im not an xml person, but i recall having to add subsets in the main xml to get all my data.