cancel
Showing results for 
Search instead for 
Did you mean: 

Using two table

Former Member
0 Kudos

Hi

I need to know, how to create reports using two tables. The result should be coming from two table.

Any help on this please?

Regards

Cauvery

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Select those two tables from Database Exprert.

In Designer> Field explorer> you will get two tables.

Drag and drop wanted feilds in to the particular sections

Or else create a join SQL query and add it as a "Command" through "Add Command" option in Databse expert.

Or else make the join SQL query as 'view' or 'stored procedure' in your database and select those as data source from CR

Regards,

Salah.

Answers (0)