private void frmReport_Load(object sender, EventArgs e)
{
CrystalReport1 rep = new CrystalReport1();
rep.SetDatabaseLogon("sa", "sa2012");
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
rep.SetParameterValue("MaHDB", _maHD);
}
public ReporteClientes()
{
InitializeComponent();
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(Controlador.getControlador().obtenerListaClientes());
cr.SetDatabaseLogon("user", "user");
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
CrystalReport1 rpt = new CrystalReport1();
//login
rpt.SetDatabaseLogon("proyekpcs", "proyekpcs");
ParameterDiscreteValue paramKode = new ParameterDiscreteValue();
paramKode.Value = kodeht;
rpt.SetParameterValue("kodehtrans", paramKode);
//sambungkan ke crystal report
invoice.ViewerCore.ReportSource = rpt;
}
public ActionResult ExportReport()
{
CrystalReport1 rd = new CrystalReport1();
rd.Load(Path.Combine(Server.MapPath("~/Reports/CrystalReport1.rpt")));
rd.SetDatabaseLogon("sa", "p@ssw0rd");
rd.SetDataSource(context.Positions.ToList());
foreach (Table tbl in rd.Database.Tables)
{
tbl.LogOnInfo.ConnectionInfo = connectInfo;
tbl.ApplyLogOnInfo(tbl.LogOnInfo);
}
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
ExportOptions CrExportOptions;
PdfRtfWordFormatOptions pdfFormatOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = "D:\\";
CrExportOptions = rd.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = pdfFormatOptions;
}
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream str = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
str.Seek(0, SeekOrigin.Begin);
string savedFileName = string.Format("CrystalReport1_{0}", DateTime.Now);
return(File(str, "application/pdf", savedFileName));
}
