REPORTS FROM MULTIPLE DATA SOURCE?

[cgl88]

How do you do this: Create a report from multiple database sources. Can this be done using VB? Or do you have to pull out information manually and then do it that way?

Please advise! I just need ideas, and possible solutions.
Does crystal reports writer allow for access to multiple db's CONCURRENTLY??

[damonous]

Yes, I know for a fact that this can be done with Crystal Reports. It's pretty self explanatory if you use CR. All you need to do is add another database to the report and then select the table and fields you want to use.

[cgl88]

Can you create reports if the database source is different? IE pull tables from an oracle db AND an SQL 7 DB concurrently? I tried that and it wouldn't work.

[damonous]

OK, I misunderstood you. Well, let's see. You could code the data portion of the report one database at a time and then use textboxes on the report to display the data. I.E. Open and extract records from SQL Server then close it. Then open and extract data from Oracle then close it. Unfortunately, if you had very large reports to generate, this process would be some what inefficient. You could have Crystal Reports generate some of the report using one database and you could code the other database. Then, like above, display the data using textboxes. But as far as using two seperate database sources with one CR, I'm not really sure...

[Serge]

You can indeed use Crystal Reports to do what you want.
You would have to use Crystal Query Designer which comes with Crystal Reports.
Also, if you have SQL Server 7.0, you can link other servers like Oracle, SQL Server, Sybase, Access etc and then create your sql statement like this:

Select ServerName.Owner.TableName.FieldName From ServerName.Owner.TableName Where ServerName.Owner.TableName.FiledName = OtherServerName.Owner.TableName.FiledName