public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportPass rpt = new CrystalReportPass();
rpt.Site = this.Site;
return(rpt);
}
public Report1()
{
InitializeComponent();
this.MyCrystalReportViewer.BackColor = System.Drawing.Color.AliceBlue;
crystal = new CrystalReportPass();
load_db(crystal);
load_pass(crystal, "66003");//variabel yang di passing
load_view(crystal);
}
public Report1()
{
InitializeComponent();
this.MyCrystalReportViewer.BackColor = System.Drawing.Color.AliceBlue;
crystal = new CrystalReportPass();
load_db(crystal);
load_pass(crystal,"66003");//variabel yang di passing
load_view(crystal);
}
private void load_pass(CrystalReportPass crystal, string val)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = val;
crParameterFieldDefinitions = crystal.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["idresep"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
private void load_pass(CrystalReportPass crystal, string val)
{
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = val;
crParameterFieldDefinitions = crystal.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["idresep"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
}
private void load_db(CrystalReportPass crystal)
{
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = "127.0.0.1";
crConnectionInfo.DatabaseName = "";
crConnectionInfo.UserID = "basdat";
crConnectionInfo.Password = "******";
CrTables = crystal.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
}
private void load_db(CrystalReportPass crystal)
{
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = "127.0.0.1";
crConnectionInfo.DatabaseName = "";
crConnectionInfo.UserID = "basdat";
crConnectionInfo.Password = "******";
CrTables = crystal.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
}
private void load_view(CrystalReportPass crystal)
{
MyCrystalReportViewer.ReportSource = crystal;
MyCrystalReportViewer.Refresh();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CrystalReportPass rpt = new CrystalReportPass();
rpt.Site = this.Site;
return rpt;
}
private void load_view(CrystalReportPass crystal)
{
MyCrystalReportViewer.ReportSource = crystal;
MyCrystalReportViewer.Refresh();
}