StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5243365
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-03-09T09:00:04.717
FavoriteCount
0
LastActivityDate
2011-03-09T10:00:53.037
LastEditDate
2011-03-09T10:00:53.037
LastEditorUserId
507099
OwnerUserId
507099
ParentId
5243059
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Here is the code you need in order to get two values from two combo-boxes, add them to a HashMap and pass the map to iReport. These paramaters, for this example "storeName" and "actionCode", are used to specify values for the query which is stored inside the iReport. The report jasper file is "../ireps/AccessCounter.jrxml". The viewer is a JDialog. If you have no parameters to pass to your report just skip the map.put. con is the connection to the database. Make sure that you include the necessary jar file to your path. <pre><code>try { String shopName = jComboBox1.getSelectedItem().toString(); String actionCode = jComboBox2.getSelectedItem().toString(); HashMap<String, Object> map = new HashMap<String, Object>(); map.put("storeName", shopName); map.put("actionCode", actionCode); URL reportFileURL = getClass().getResource("../ireps/AccessCounter.jrxml"); File reportFile = new File(reportFileURL.toURI()); JasperDesign jasperDesign = JRXmlLoader.load(reportFile); JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, map, con); JasperViewer jv = new JasperViewer(jasperPrint); JDialog viewer = new JDialog(this, "Batch Report", true); viewer.setBounds(jv.getBounds()); viewer.getContentPane().add(jv.getContentPane()); viewer.setResizable(true); viewer.setIconImage(jv.getIconImage()); viewer.setVisible(true); } catch (JRException exc) { System.out.println(exc.getMessage()); } catch (URISyntaxException exs) { System.out.println(exs.getMessage()); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow I can join compiled jasper file and my project in java?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCostis Aivalis
UserOwnerUserId
1. USCostis Aivalis
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.