Generation of new tables
Recently I am working with Crystal Reports and I have the following questions:
1. With the BD1 generate another database (BD2) and in another report linking the BD1 and BD2.
2. I have 3 Databases (BD1, BD2, BD3) and I need each select the same information and then joining the result of each BD to form a BD4 and generate this report.
The previous BD are in SQL SERVER 2005 and the idea is that the end user does not have to perform additional processes.
By programming that Crystal Reports can make all of these processes and which serious.
A hug and thanks for the cooperation.
not too sure what you're after but on the face of it I think you may have to create a View in SQL Server using the UNION command that will combine the results of a number of queries.
You can then query the view via Crystal Reports