Menampilkan Report Crystal Report

crviewer.cs

public void ShowProfitLossReport(int month, int year)
{
    InitializeConnectionInfo();
    rpt = new Finance.rptProfitLoss();
    rpt.ParameterFields["bulan"].CurrentValues.AddValue(month);
    rpt.ParameterFields["tahun"].CurrentValues.AddValue(year);
    rpt.ParameterFields["span"].CurrentValues.AddValue("MONTHLY");
    SetReportLogonInfo(rpt);
    crViewer1.ReportSource = rpt;
    crViewer1.Zoom(1);
}

private void InitializeConnectionInfo()
{
    cnInfo = new ConnectionInfo();
    cnInfo.ServerName = Config.Server;
    cnInfo.DatabaseName = "accounting";
    cnInfo.UserID = "sa";
    cnInfo.Password = "*****";
}

private void SetReportLogonInfo(ReportDocument reportDocument)
{
    Tables tables = reportDocument.Database.Tables;
    foreach (Table table in tables)
    {
        TableLogOnInfo tableLogonInfo = table.LogOnInfo;
        tableLogonInfo.ConnectionInfo = cnInfo;
        table.ApplyLogOnInfo(tableLogonInfo);
    }
}