public void crystalrpt(string parametro)
{
//Variable cliente
CrystalReport2 crystalreport = new CrystalReport2();
//ReportDocument crystalreport = new ReportDocument();
//crystalreport.Load(@"C:\Users\LUISE\documents\visual studio 2013\SISJAG\SistemaAlmacen\SistemaAlmacen\CrystalReport2.rpt");
//crystalreport.DataSourceConnections[0].SetConnection("WIN-SERVER\\JAGUARIRA", "SistemaAlmacen", "sa", "Jaguar1");
crystalreport.SetDatabaseLogon("sa", "Jaguar1", "WIN-SERVER\\JAGUARIRA", "SistemaAlmacen");
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = cbxcliente.Text;
crParameterFieldDefinitions = crystalreport.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[parametro];
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crystalReportViewer1.ReportSource = crystalreport;
crystalReportViewer1.Refresh();
crystalReportViewer1.RefreshReport();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport2 rpt = new CrystalReport2();
rpt.Site = this.Site;
return(rpt);
}