p_sasko
Član broj: 47683 Poruke: 90 *.com Via: [es] mailing liste
|
Nema problema. Evo Primera:
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.JasperViewer;
.
.
.
void bwButton2_actionPerformed(ActionEvent e) {
String upit = "SELECT dmgodina, dmsifranaziva, dmui, dmdokno, dmdok,
dmdatdok, dmdatdos, dmpartsifra, dmopis, dmoper,lozime, "+
"partfirma, partpreduzece, partmesto, partposta, partadresa,
partpib, "+
"KArtSifra, Kopis, KKolicina, KJmere, KPCena, Osnovica,
KStopa, KPorez, Vrednost, ktarsifra, tarnaziv, "+
"mmesto, naziv, fzirorn, (fposta||' '||fmesto) as fmesto,
fadresa, fdir, ftel, fmbr, fsifdel, fregbr, fpib, fbrojpdv "+
"FROM " + Businessware.firma.getWorkSpace()+".DokM t1 "+
"LEFT OUTER JOIN "+
"(SELECT kgodina, ksifranaziva, kui, kdokno, "+
"KArtSifra, Kopis, KKolicina, KJmere, KPCena,
(KPCena*KKolicina-Kporez) AS Osnovica , KTarSifra, KStopa, KPorez,
(KKolicina * KPCena) as Vrednost, OID "+
"FROM " + Businessware.firma.getWorkSpace()+".Kart) t2 ON
dmgodina=kgodina and dmsifranaziva = ksifranaziva and dmui=kui and
dmdokno=kdokno "+
"LEFT OUTER JOIN "+
"(SELECT partsifra, partfirma, partpreduzece, partmesto, partposta,
partadresa, partpib "+
"FROM " + Businessware.firma.getPartneriSpace()+".partneri) t3 ON
partsifra=dmpartsifra "+
"LEFT OUTER JOIN "+
"(SELECT msifranaziva, mmesto FROM " +
Businessware.firma.getWorkSpace()+".m_naziv) t4 ON
msifranaziva=dmsifranaziva "+
"LEFT OUTER JOIN "+
"(SELECT vrsta, sifranaziva, naziv FROM " +
Businessware.firma.getWorkSpace()+".nazivi) t5 ON vrsta = 'F' "+
"LEFT OUTER JOIN "+
"(SELECT fzirorn, fposta, fmesto, fadresa, fdir, ftel,
fmbr::varchar, fsifdel, fregbr, fpib, fbrojpdv, fkplan "+
"FROM " + Businessware.firma.getWorkSpace()+".f_naziv) t6 ON
fkplan<>'' "+
"LEFT OUTER JOIN "+
"(SELECT lozid, lozime FROM micro.loza) t7 ON lozid=dmoper "+
"LEFT OUTER JOIN "+
"(SELECT tarsifra, tarnaziv FROM micro.tarife) t8 ON ktarsifra tarsifra "+
"WHERE DMGodina = "+poslGod.getValue()+" AND DMSifraNaziva = " +
sifObj.getValue() +" AND DMUI = 3 and dmdokno = "+ racunBr.getValue() +
"ORDER BY dmsifranaziva, dmui, dmdokno, t2.OID";
try {
Statement stm = Businessware.workConnection.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stm.executeQuery(upit);
if (!rs.first()) {
JOptionPane.showMessageDialog(null, "Nema podataka!","Faktura",
JOptionPane.INFORMATION_MESSAGE);
return;
}
rs.beforeFirst();
JRResultSetDataSource jrRS = new JRResultSetDataSource(rs);
Map parameters = new HashMap(); // Ovde punis ovaj Map objekat
parametrima koje prenosis izvestaju.
JasperPrint jprint = null;
try {
JasperReport jr JasperCompileManager.compileReport("nazivFilea.jrxml");
jprint = JasperManager.fillReport(jr, parameters, jrRS);
}
catch (JRException ex) {
System.out.println(ex);
}
JasperViewer.setFullScreen(true); // Uvu metodu sam ja implementirao u
JasperViewer klasu.
JasperViewer.viewReport( jprint , false); // I ovaj metod je valjda
malo modifikovan, dali da bude modalan ili ne.
}
catch (SQLException ex) {
ex.printStackTrace();
}
catch (JRException ex) {
ex.printStackTrace();
}
}
}
Pozdrav....
|