CODEWITHSUNDEEP
sql-serversql-server-2008crystal-reports
Jonair
Jonair

Reputation: 1

Two tables in one Crystal Report

I have 2 database tables (MSSQL SERVER) which are CM (Name of Table 1) and REM (Name of Table 2). Is it possible to make it in Crystal Reports just like in the below image?

sample display ex in crystal report

Upvotes: 0

Views: 1206

Answers (1)

jambonick
jambonick

Reputation: 716

Using subreports does not gives you the ability you to use common columns, so you must figure out how to use ONE select statement from database to report.

From your snapshot it seems that your tables have 6 common columns (Control,ClientName,DateReceived,RequiredDocs,UploadStatus,Remarks) which you wish to show, and the first 3 of them are used for grouping. So you could use UNION between two SELECT of these 6 columns of your two tables and then implement the grouping in your report designer.

e.g

"SELECT 
Control,ClientName,DateReceived,RequiredDocs,UploadStatus,Remarks
FROM CM
UNION
SELECT 
Control,ClientName,DateReceived,RequiredDocs,UploadStatus,Remarks
FROM REM"

Upvotes: 1

Related Questions