I declare a method in my class
public static object ConnForReport(ReportDocument objReport)
{
SqlConnection cn = null;
cn = new SqlConnection(Properties.Settings.Default.CMScon);
CrystalDecisions.Shared.TableLogOnInfo logOnInfo = null;
logOnInfo = objReport.Database.Tables[0].LogOnInfo;
logOnInfo.ConnectionInfo.ServerName = cn.DataSource;
logOnInfo.ConnectionInfo.DatabaseName = cn.Database;
logOnInfo.ConnectionInfo.UserID = "sa";
logOnInfo.ConnectionInfo.Password = "SQLadmin";
objReport.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
return objReport;
}
then i use this method in my button click event like this:
protected void CmdPreview_Click(object sender, ImageClickEventArgs e)
{
try
{
InquiryReports objReport = new InquiryReports();
string vSelectionFormula = null;
ReportDocument objReports = (ReportDocument)MethodClass.ConnForReport(objReport);
vSelectionFormula = "{CompalintView.ComplaintStatus}='" + CboCompStatus.Text + "'";
InquiryRptViewer.SelectionFormula = vSelectionFormula;
InquiryRptViewer.ReportSource = objReports;
Session.Add("CR_Session",objReports);
}
catch (Exception ex)
{
}
}
Do Not forget to write these code on your page_load event:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Session.Remove("CR_Session");
CboComplaintStatusFill();
}
else
{
InquiryRptViewer.ReportSource = Session["CR_Session"];
}
}
If any Query so comment me... i have try these code in my project it works perfectly. Thanx