Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Generation of new tables

Good morning

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.

Ricardo Suarez

Former Member
Former Member replied

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

Dom

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question