iReport

From Fishbowl

(Redirected from IReports)
Jump to: navigation, search
iReport
Related Pages
What is iReport?
Setting up iReport
Does iReport require additional costs?
How do I integrate Fishbowl and iReport?
How do I use iReport for Report mods?
Is iReport similar to Crystal Reports?
What knowledge do I need to use iReport?
Can I pay Fishbowl to write a report for me?

iReport is a third-party application that can be used to create Fishbowl reports. iReport is not developed or supported by Fishbowl beyond the initial setup. iReport is a powerful and intuitive visual report builder/designer. This tool allows users to visually edit complex reports with charts, images, and sub reports. iReport is integrated with the leading open-source chart libraries for Java. In addition to many included reports, Fishbowl also offers custom reports and reports from the Fishbowl Store.

Contents

Installing iReport
Jump to top of page

To install iReport, run the installer from here or here.

NOTE: iReport has some compatibility issues with Java 8. When using Fishbowl 2016.12 or greater, follow the steps below to properly configure iReport.

  1. If iReport doesn't start, Java 7 may need to be installed from here.
  2. If iReport still doesn't start, open the iReport/etc directory (For example, C:\Program Files (x86)\Jaspersoft\iReport-5.6.0\etc) and copy the ireport.conf file to the desktop. Add the following line to the file (or remove the # and modify the line). Then save the file and paste it back into the iReport\etc directory. Modify the path as necessary to point to the Java 7 folder.
    jdkhome="C:\Program Files\Java\jre7"

Set up the classpath
Jump to top of page

  1. Open iReport and select the Tools menu then Options.
    IReport Tools.Options.png
  2. Navigate to the iReport Menu, open the Classpath tab, and select the Add JAR button.
    IReport.Classpath.Add JAR.png
  3. Browse to the C:\Program Files\Fishbowl\lib and select all of the JAR files located within that folder.
    Add JARs to Fishbowl.lib Classpath.png
  4. Click the Open button and then click OK.

Configure database service
Jump to top of page

Fishbowl includes a Small.Data.png Data module that can be used to view tables and test queries. iReport also comes with a database service that can do the same. The database service is not required to set up or create a report, although it is recommended. Firebird instructions for Fishbowl 2016.14 or earlier can be found here.

  1. Press Ctrl + 5 to open the Services pane.
  2. Expand the Databases section, right-click Drivers, and then select New Driver.
    New iReport driver.png
  3. Click the Add button, select C:\Program Files\Fishbowl\lib\mysql-connector-java... and then click Open.
  4. Enter Fishbowl MySQL in the Name field and then click OK.
    IReport driver name.png
  5. Expand the Drivers folder, right-click Fishbowl MySQL, and then select Connect Using...
    IReport Connect Using.png
  6. Enter the information shown below.
    Host: localhost (or the IP address of Fishbowl server)
    Port: 3305
    Database: Enter the actual database name
    User Name: gone
    Password: fishing
    Remember password: Yes
    MySQL server properties.png
  7. Click OK.

Create a datasource
Jump to top of page

  1. Click the Report datasources Icon Button.png Report datasources button at the top of the screen and then click the New button.
  2. Select NetBeans Database JDBC connection and then click Next.
    JDBC datasource connection.png
  3. Enter the database name and then click Test.
    Netbeans.png
  4. Click Save.

Using iReport for custom reports
Jump to top of page

These are the conventions accepted by Fishbowl for JasperReports. Using these conventions ensures that a custom report will be handled as expected and as desired.

iReport versions

Report basics

Report conventions

Hyperlink Values

You can link to records within Fishbowl from a report by using a hyperlink reference. The valid options are

Fishbowl Parameters

Parameter Name Class Type Default Value About
module java.lang.Object Not Used Used to pull Information from Fishbowl. Common uses are: Company Logo and Tracking Information.
path java.lang.String Not Used Is populated with the Current Path of the Report. This is needed for any Sub-Reports that the Report uses. The Sub-Reports Require the full path to the Sub-Report, this helps to complete that task.
currentUser java.lang.Integer Not Used Used to automatically populate the user ID for the person running the report.
Parameter Name Class Type Default Value Description About
accountID[Title] java.lang.String {Default Account ID} Not Used Provides a Search Option for Accounts.
{Boolean Name} java.lang.Boolean {new Boolean(true) or new Boolean(false)} Not Used Displays a simple Check Box with the Parameter Name.
carrier java.lang.String {Default Carrier name} Not Used Displays a list of all Carriers in the system. Returns the Carrier Name.
cb[Title] java.lang.String {Default Value Return} {Comma separated choices like this: "Value Return 1, Value Show 1, Value Return 2, Value Show 2".} Allows a list of Items to be Displayed. First Value in list is Returned to Report, the Second Value is Displayed in the Combo Box. This allows a Readable Value to be Displayed while a more useful value is passed to the report.
ck[Title] java.lang.String {Default Value Return} {Comma separated choices like this: "Value Return 1, Value Return 2".} Allows a Check Box to be displayed and Return of String of One of Two Values.
customerID[Title] java.lang.String {Default Customer ID} Not Used Provides a Search Option for Customers.
customerGroupID[Title] java.lang.String {Default Customer Group ID} Not Used Provides a Search Option for Customer Groups. Caution! This parameter works differently due to security restrictions. Fishbowl will return a list of Valid Customer Group IDs instead of a '%' if no Customer Group is selected. Example for WHERE Clause: (accountgroup.id IN ($P!{customerGroupID}))
{Date Name} java.util.Date {Default Date Value} Not Used Displays Room to enter a Date. Also provides a Button to a Calendar Display.
dateRange1[Title] java.util.Date {Default Value for From Date} Not Used Populates 2 Parameters together to provide a Date Range. Gives a Combo Box of common Date choices - Today, This Week, Last Year, etc. Use the same [Title] for dateRange2.
dateRange2[Title] java.util.Date {Default Value for To Date} Not Used Does nothing by itself. dateRange1[Title] populates this Parameter.
{Double Name} java.lang.Double {Default Double Value} Not Used Display a standard Form Box to add a Double (Number with Decimals). Checks to makes sure Input is Valid.
{Integer Name} java.lang.Integer {Default Integer Value} Not Used Display a standard Form Box to add an Integer (Number without Decimals). Check to make sure Input is Valid.
kitNum[Title] java.lang.String {Default Product Number} Not Used Provides a search option for kit numbers.
locationGroupID[Title] java.lang.String {Default Location Group ID} Not Used Provides a Search Option for Location Groups. Caution! This parameter works differently due to security restrictions. Fishbowl will return a list of Valid Location Group IDs instead of a '%' if no Location Group is selected. Example for WHERE Clause: (locationgroup.id IN ($P!{locationGroupID}))
locationID[Title] java.lang.String {Default Location ID} Not Used Provides a Search Option for Locations
moNum[Title] java.lang.String {Default MO Number} Not Used Provides a search option for MO numbers.
partNum[Title] java.lang.String {Default Part Number} Not Used Provides a Search Option for Part Numbers
paymentMethod[Title] java.lang.String {Default Payment Method ID} Not Used Provides a Search Option for Payment Methods.
pickNum[Title] java.lang.String {Default Pick Number} Not Used Provides a search option for pick numbers.
poNum[Title] java.lang.String {Default PO Number} Not Used Provides a Search Option for PO Numbers.
productNum[Title] java.lang.String {Default Product Number} Not Used Provides a Search Option for Product Numbers.
productTree1[Title] java.lang.String {Default Product Tree Node ID} Not Used Provides a Product Tree that users can select a node to filter by. Returns a list of the ID of the selected node, plus the ID of its children categories.
productTree2[Title] java.lang.String Not Used Not Used Does nothing by itself. When coupled with the productTree1 parameter, it will allow users to view products that are not in the product tree. It returns either % or the selected node ID. Example for WHERE clause: AND ((COALESCE(producttreeid,0) IN ($P!{productTree1})) OR ((COALESCE(producttreeid,0) LIKE $P{productTree2})))
qbClassID[Title] java.lang.String {Default QuickBooks Class ID} Not Used Provides a Search Option for Quick Book Classes.
receiptID[Title] java.lang.String {Default Receipt ID} Not Used Provides a Search Option of r a Receipt. Displays the order number to the user, but passes the ID to the report.
rmaNum[Title] java.lang.String {Default RMA} Not Used Provides a Search Option for RMAs.
salesPerson[Title] java.lang.String {Default Sales Person Name} Not Used Provides a Drop Down of Sales Persons
shipID[Title] java.lang.String {Default Ship ID} Not Used Will Display the SO/PO Number with the Date and give the User a Search for a Ship. Passes the Ship ID to the Report.
soNum[Title] java.lang.String {Default SO Number} Not Used Provides a Search Option for SO Numbers.
sort[Title] java.lang.String {Default Sort Values. Comma separated.} {Comma separated choices for sorting like this: "SQL Name 1, Show Name 1, SQL Name 2, Show Name 2".} Allows a list of items to be displayed in a combo box. Additional sort boxes can be added from the parameter dialog box. The first value is added to a list to return, while the second value is displayed in the combo box. This allows a readable value to be displayed while the SQL value is passed to the report.
{String Name} java.lang.String {Default String Value} Not Used Display a standard Form Box to add a String.
toNum[Title] java.lang.String {Default TO Number} Not Used Provides a Search Option for TO Numbers.
vendorID[Title] java.lang.String {Default Vendor ID} Not Used Provides a Search Option for Vendors.
woNum[Title] java.lang.String {Default WO Number} Not Used Provides a Search Option for WO Numbers.
colName java.lang.boolean {Default true or false} Not Used Adds a table column to the column selector tab of the reports dialog.

iReport is sometimes mistakenly referred to as iReports

Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate