Crystal Report

[Guest]

Hi,

I'm using this code to export a crystal report to pdf and its working fine
with fields from one table called "Evaluation":

string SQLSearchText = "Select * from Evaluation WHERE ID =275";
daCache.SelectCommand = new CacheCommand(SQLSearchText, cnCache);

if (dsCache.Tables["Evaluation"] != null)
dsCache.Tables["Evaluation"].Clear();
daCache.Fill(dsCache, "Evaluation");

O_Report.Database.Tables[0].SetDataSource(dsCache);
O_Report.ExportToDisk(ExportFormatType.PortableDocFormat,
"C://AuditReport.pdf");

But the issue is, how can I include other fields from other tables, knowing
that have already set the connetion and included the tables in my Report
manually


Thanks.