Code for select data from database
CR_visitor_Pass cr = new CR_visitor_Pass();
search_Record SR_obj = new search_Record();
DataTable DT = new DataTable();
DT = SR_obj.Search_Record_For_PrintPass(pass_obj);
cr.SetDataSource(DT);
MemoryStream oStream;
oStream = (MemoryStream)
cr.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Cache["testr"] = oStream.ToArray();
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('Pdfconvert.aspx');", true);
In Pdfconvert.Aspx following code
protected void Page_Load(object sender, EventArgs e)
{
ArrayList ary = new ArrayList();
ary.Add(Cache["testr"]);
Cache.Remove("testr");
BinaryFormatter f = new BinaryFormatter();
MemoryStream ms = new MemoryStream();
f.Serialize(ms, ary);
CR_visitor_Pass cr = new CR_visitor_Pass();
cr.Load(Server.MapPath("~/CR_visitor_Pass.rpt"));
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(ms.ToArray());
Response.End();
}