Hi,

I am using Crystal report 8.5 and SQL Server 2000

Initially I designed my report using 6 tables. It is a service details report. After some initial design, I want to display problem details (description) in the report. Service detail report have a column named ProblemId (int). It is related to its master table ProblemMaster - ProblemId (int). So I added this table, ProblemMaster into the existing report. Smartlinking is automatically linked the above two tables (equal join). It is not showing any error. But when I pulling the Problem description column from ProblemMaster table into the reprot, other columns are vanished !!! I created a view to the ProblemMaster and joined this into the report instead of the ProblemMaster table, again I get the same result. If I try to change the link joins, crystal report throwing error. What could be the problem ?? Is there any other way to display the description ???