<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to wiki</title><link href="https://sourceforge.net/p/jasviewer/wiki/" rel="alternate"/><link href="https://sourceforge.net/p/jasviewer/wiki/feed.atom" rel="self"/><id>https://sourceforge.net/p/jasviewer/wiki/</id><updated>2011-12-19T12:21:54.988000Z</updated><subtitle>Recent changes to wiki</subtitle><entry><title>WikiPage Adding new Database Drivers modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Adding%2520new%2520Database%2520Drivers/" rel="alternate"/><published>2011-12-19T12:21:54.988000Z</published><updated>2011-12-19T12:21:54.988000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.nete10496ba80fb1683e7fc266a8b54675bc731429a</id><summary type="html">&lt;pre&gt;&lt;/pre&gt;</summary></entry><entry><title>WikiPage Adding new Database Drivers modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Adding%2520new%2520Database%2520Drivers/" rel="alternate"/><published>2011-12-19T12:21:40.658000Z</published><updated>2011-12-19T12:21:40.658000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.netd1d099854599253957884a463881d1a5eddad901</id><summary type="html">&lt;pre&gt;&lt;/pre&gt;</summary></entry><entry><title>WikiPage Connecting to other databases modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Connecting%2520to%2520other%2520databases/" rel="alternate"/><published>2011-12-19T12:15:55.242000Z</published><updated>2011-12-19T12:15:55.242000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net05d3bd2fe46cebf58fed101d74c938c0fc1a4b5f</id><summary type="html">Follow the steps:

1 - Download the jdbc Driver for your database
2 - copy the jdbc driver to the folder lib/
3 - Open the JasViewer.jar with a valid compressing program (such as 7-zip)
4 - Edit the file located at /META-INF/manifest.fm (example bellow)

(...)
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.7.1
Created-By: 20.1-b02 (Sun Microsystems Inc.)
Main-Class: jasviewer.Main
Class-Path: lib/jasperreports-applet-4.0.2.jar lib/jasperreports-fonts-4.0.2.jar lib/jasperreports-javaflow-4.0.2.jar lib/ant-1.7.1.jar lib/antlr-2.7.5.jar lib/barbecue-1.5-beta1.jar lib/barcode4j-2.0.jar lib/batik-anim.jar lib/batik-awt-util.jar lib/batik-bridge.jar lib/batik-css.jar lib/batik-dom.jar lib/batik-ext.jar lib/batik-gvt.jar lib/batik-parser.jar lib/batik-script.jar lib/batik-svg-dom.jar lib/batik-svggen.jar lib/batik-util.jar lib/batik-xml.jar lib/bcel-5.2.jar lib/bsh-2.0b4.jar lib/commons-beanutils-1.8.0.jar lib/commons-collections-2.1.1.jar lib/commons-digester-1.7.jar lib/commons-javaflow-20060411.jar lib/commons-logging-1.0.4.jar lib/groovy-all-1.7.5.jar lib/hibernate3.jar lib/hsqldb-1.8.0-10.jar lib/iText-2.1.7.jar lib/jaxen-1.1.1.jar lib/jcommon-1.0.15.jar lib/jdt-compiler-3.1.1.jar lib/jfreechart-1.0.12.jar lib/jpa.jar lib/jxl-2.6.10.jar lib/log4j-1.2.15.jar lib/mondrian-3.1.1.12687.jar lib/png-encoder-1.5.jar lib/poi-3.6.jar lib/rhino-1.7R1.jar lib/saaj-api-1.3.jar lib/serializer.jar lib/servlet.jar lib/spring-beans-2.5.5.jar lib/spring-core-2.5.5.jar lib/xalan-2.7.1.jar lib/xercesImpl-2.7.0.jar lib/xml-apis-ext.jar lib/xml-apis.jar lib/AbsoluteLayout.jar lib/jcalendar-1.3.3.jar lib/sqlitejdbc-v056.jar lib/postgresql-8.2-507.jdbc4.jar
X-COMMENT: Main-Class will be added automatically by build

(...)

5 - add your jdbc driver (jar file) at the end of Class-Path.



</summary></entry><entry><title>WikiPage List of parameter types modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/List%2520of%2520parameter%2520types/" rel="alternate"/><published>2011-09-19T16:19:14.655000Z</published><updated>2011-09-19T16:19:14.655000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.neta5a20c863d52bfe3c02e736672b771e7861362ee</id><summary type="html">&lt;pre&gt;--- v1 
+++ v2 
@@ -5,4 +5,5 @@
  - Integer
  - Number
  - String
+ - Collection
 
&lt;/pre&gt;</summary></entry><entry><title>WikiPage List of parameter types modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/List%2520of%2520parameter%2520types/" rel="alternate"/><published>2011-08-24T14:01:45.493000Z</published><updated>2011-08-24T14:01:45.493000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.neta9074469d54e5379bc1623883f2b0afeca2bf66b</id><summary type="html">Not all parameters types are include so here is a list of the parameter types so far:

 - Boolean
 - Date
 - Integer
 - Number
 - String

</summary></entry><entry><title>WikiPage Getting Started modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Getting%2520Started/" rel="alternate"/><published>2011-07-31T11:20:06.144000Z</published><updated>2011-07-31T11:20:06.144000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net6440ed347c5b338ea04456c771e987475e7f8590</id><summary type="html">&lt;pre&gt;&lt;/pre&gt;</summary></entry><entry><title>WikiPage [Home] modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/%255BHome%255D/" rel="alternate"/><published>2011-07-31T11:19:36.537000Z</published><updated>2011-07-31T11:19:36.537000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net7d0ecd6c586968c46641fc5050283b1645918242</id><summary type="html">&lt;pre&gt;&lt;/pre&gt;</summary></entry><entry><title>WikiPage Getting started modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Getting%2520started/" rel="alternate"/><published>2011-07-28T20:46:42.927000Z</published><updated>2011-07-28T20:46:42.927000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net47e894dbceb861d73b71e4ea58db5943007542b2</id><summary type="html">Getting started:

 1 - Althought this is graphical application, connection to database is done throw arguments example "java -jar JasViewer.jar -c jdbc:odbc:DSNAME" (hint create a shortcut with the parameters to the database connection)
 2 - Press File &gt; Open 
 3 - Select your .jasper file
 4 - Fill the parameters
 5 - See your report, if you want you can export it to pdf, xls, odt, word and many other formats</summary></entry><entry><title>WikiPage Home modified by Daniel F</title><link href="https://sourceforge.net/p/jasviewer/wiki/Home/" rel="alternate"/><published>2011-07-28T20:45:17.073000Z</published><updated>2011-07-28T20:45:17.073000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net7d27a0a31d529e348ac2aff4f24b5638bb06d7cb</id><summary type="html">&lt;pre&gt;--- v1 
+++ v2 
@@ -1,5 +1,7 @@
-Welcome to your wiki!
-
-This is the default page, edit it as you see fit. To add a page simply reference it within brackets, e.g.: [SamplePage].
-
-The wiki uses [Markdown](/p/jasviewer/wiki/markdown_syntax/) syntax.
+Getting started:
+
+ 1 - Althought this is graphical application, connection to database is done throw arguments example "java -jar JasViewer.jar -c jdbc:odbc:DSNAME" (hint create a shortcut with the parameters to the database connection)
+ 2 - Press File &gt; Open 
+ 3 - Select your .jasper file
+ 4 - Fill the parameters
+ 5 - See your report, if you want you can export it to pdf, xls, odt, word and many other formats
&lt;/pre&gt;</summary></entry><entry><title>Discussion for Home page</title><link href="https://sourceforge.net/p/jasviewer/wiki/_discuss/thread/1c10a34f/" rel="alternate"/><published>2011-07-26T11:27:25.250000Z</published><updated>2011-07-26T11:27:25.250000Z</updated><author><name>Daniel F</name><uri>https://sourceforge.net/u/jasviewerd/</uri></author><id>https://sourceforge.net2b5fdf7ee69a554f77c0cd7287ac81d0fcdb3f3d</id><summary type="html">Dynamic Parameters (Single Select):

On ireport create a new parameter for your report, the name of the parameter must start with sql_ example of a name for a parameter would be "sql_Car" on the (default value Expression) of your parameter place your sql query, it must return only 2 columns on "id" other "nome" example of a query "SELECT idcar AS id, license_plate AS nome FROM cars ORDER BY license_plate"

So for the table Cars

idcar | license_plate
---------------------
    1 | 12-43-re
    2 | 23-tr-99
    3 | 54-ee-65

and Persons

idperson|name       | idcar
---------------------------
      1 | Jack      |    2
      2 | Marie     |    3
      3 | Jonh      |    1


The user would be asked to select on of the license_plates from a combobox the value returned from the parameter will be the idcar.

So for your report query you would have something like:

SELECT * FROM persons WHERE idcar = $P{sql_Car};

Giving you a list of persons associated with a car.




</summary></entry></feed>