From Fishbowl Inventory

[edit] Updating Reports to Work with Fishbowl Inventory 2009.2

With Fishbowl Inventory version 2009.2 the database structure has changed and most custom reports, or reports that have been modified in older versions, will not work. This is something that Fishbowl lets all customers know before a custom report is created or a report is modified. The standard reports that come with Fishbowl will work just fine.

The process to update these reports can range from very simple to very complex. This document will guide you through converting the simple to moderately simple report to the new version. If for any reason, you choose to not follow this document, or if this document is not sufficient to update your report, Fishbowl does offer a service to update your reports. The fee for this service begins at $75.00 per report (or 1 Support Incident) and will be no more than $750.00 per report. Please call 1.800.774.7085 ext 3 to request this report updating service.

[edit] Setting Up iReport

To update a Fishbowl report, you must have iReport 2.0.5 installed on your server computer. If you do not have iReport 2.0.5 installed please go to the following link to download the iReport installer. http://www.fishbowlinventory.com/files/release/iReport.exe. Once you download the installer follow the on screen instructions to install iReport.

1. If not already open, open iReport 2.0.5 by clicking on Start | All Programs | iReport |iReport.exe.
   
2. In iReport, click Options | Classpath.
   
3. If anything is found in this list, highlight them and click “Remove”.
   
4. Click “Add JAR” and browse to C:\Program Files\Fishbowl\lib (or the path where Fishbowl Inventory is installed).
   
5. Highlight all files in the “lib” folder and click “Open”.
   
6. Click “Add JAR” again and browse to C:\Program Files\Fishbowl\Client\lib.
   
7. Highlight all files in this “lib” folder and click “Open”.
   
8. Click “Save Classpath.”

[edit] Updating your custom reports to work with Fishbowl Inventory 2009.2

1. Click File | Open and then browse to the C:\Program Files\Fishbowl\Server\reports folder. Once there, you will have all the modules that contain your report files. Open the custom reports or report files that have been modified that you are trying to update. These files will have a .jrxml extension. In this example we will be updating the file in the SalesOrder folder called SOReport.jrxml.
   
2. Once the report is opened, click Data | Report Query.
   
3. Uncheck the box in the middle that says “Automatically Retrieve Fields” and then check it again.
   
4. With “Automatically Retrieve Fields” checked again wait 10 seconds and then click OK.
   
5. From the menu bar click Build | Compile.
   
6. At the bottom of the iReport window you will see a tab labeled “Problems”. Click on the “Problems” tab.
   
7. Each row in the “Problem” tab represents a change that needs to be made for the report to run in Fishbowl Inventory 2009.2.
   
8. Double click on the first error message.
   
9. If it opens a window titled “Add/modify variable” follow steps 11 through 15.
   
10. If it does not open a window skip to steps 16 through 21.
    
11. In the “Add/modify variable”window change the field labeled “Variable Class Type” from “java.math.BigDecimal” to “java.lang.Double”.
    
12. In the field labeled“Initial Value Expression” replace the “new BigDecimal(0)” to be “new Double(0)” (without the quotes).
    
13. Click OK.
    
14. From the menu bar click Build | Compile.
    
15. Repeat steps 8 through 14 until no errors exist.
    
16. If the “Add/modify variable” window does not pop up, a field in the report design window above will be highlighted with a box.
    
17. Right click on the highlighted field and choose “Properties”.
    
18. Click on the “Text Field” tab of the properties window.
    
19. Change the field labeled “Text Field Expression Class” from “java.math.BigDecimal” to “java.lang.Double”.
    
20. Click the “X” in the top right corner of this window (not iReport) to close it and record the changes.
    
21. From the menu bar click Build | Compile.
    
22. Repeat steps 6 thru 21 until there are no more errors when you compile the report.
    
23. Once the compile finishes without returning any errors, your report is ready to run in Fishbowl Inventory 2009.2.
    
24. Restart the Fishbowl Server and run the report.

If the report is still not running in version 2009.2 please call 1.800.774.7085 ext 3 to request our report updating service.

Back to Support