Hi
This will helpful for u
protected void Page_Load(object sender, EventArgs e)
{
SqlServer server = new SqlServer("Data Source=KSHIT6773-G13\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True");
string[] sql = { "SELECT E.Name, D.Name FROM Employee E, Department D WHERE D.DepartmentID = E.Department" };
string[] table = { "EMPDEPT" };
DataSet ds = new DataSet();
ds = server.GetDataSet(sql, table, false);
ReportCRtoPDF rptObj = new ReportCRtoPDF();
rptObj.SetDataSource(ds);
DiskFileDestinationOptions dsk = new DiskFileDestinationOptions();
dsk.DiskFileName = Request.PhysicalApplicationPath + "files\\CrtoPDF.pdf";
ExportOptions ex = new ExportOptions();
ex.ExportDestinationType = ExportDestinationType.DiskFile;
ex.ExportFormatType = ExportFormatType.PortableDocFormat;
ex.ExportDestinationOptions = dsk;
rptObj.Export(ex);
}