public void generaReporteMedicamentos(VentanaReporte vr)
{
String consulta = "SELECT M.ID,M.NOMBRE_COMPUESTO,M.PRESENTACION,M.CONTENIDO,SC.DEMANDA "
+ "FROM (SELECT MX.ID_MEDICAMENTO, COUNT(MX.ID_MEDICAMENTO) AS DEMANDA "
+ "FROM MXRF MX GROUP BY MX.ID_MEDICAMENTO ORDER BY COUNT(ID_MEDICAMENTO) DESC) SC,MEDICAMENTOF M "
+ "WHERE SC.ID_MEDICAMENTO = M.ID AND ROWNUM <=10";
dsReportes ds = new dsReportes();
crMedicamento cr = new crMedicamento();
CrystalReportViewer crv;
OracleDataAdapter adapter = new OracleDataAdapter();
vr = new VentanaReporte();
crv = vr.dame_viewer();
adapter.SelectCommand = new OracleCommand(consulta, conexion);
adapter.Fill(ds, "Medicamentos");
cr.SetDataSource(ds);
crv.ReportSource = cr;
crv.Show();
vr.Show();
}
public void generaReporteMedicamentos(VentanaReporte vr)
{
String consulta = "SELECT M.ID,M.NOMBRE_COMPUESTO,M.PRESENTACION,M.CONTENIDO,SC.DEMANDA "
+ "FROM (SELECT MX.ID_MEDICAMENTO, COUNT(MX.ID_MEDICAMENTO) AS DEMANDA "
+ "FROM MXRF MX GROUP BY MX.ID_MEDICAMENTO ORDER BY COUNT(ID_MEDICAMENTO) DESC) SC,MEDICAMENTOF M "
+ "WHERE SC.ID_MEDICAMENTO = M.ID AND ROWNUM <=10";
dsReportes ds = new dsReportes();
crMedicamento cr = new crMedicamento();
CrystalReportViewer crv;
OracleDataAdapter adapter = new OracleDataAdapter();
vr = new VentanaReporte();
crv = vr.dame_viewer();
adapter.SelectCommand = new OracleCommand(consulta, conexion);
adapter.Fill(ds, "Medicamentos");
cr.SetDataSource(ds);
crv.ReportSource = cr;
crv.Show();
vr.Show();
}
