This means that Fishbowl recognizes a report by where it is physically stored. Any reports within that folder will appear in the matching folder of Report Module. For example, if a folder named Customer exists in the reports directory, then there will be a Customer folder in the Report Module. The hierarchy/organization of reports in the Report Module matches the file structure of Fishbowl/Server/reports. Custom reports added to this folder or any subdirectory within this folder will be used by Fishbowl. The root report directory is Fishbowl/Server/reports.
![fishbowl inventory mysql connection fishbowl inventory mysql connection](https://windows-cdn.softpedia.com/screenshots/Fishbowl-Inventory_21.png)
Using these conventions ensures that a custom report will be handled as expected and as desired. These are the conventions accepted by Fishbowl for JasperReports. Enter the database name and then click Test.Select NetBeans Database JDBC connection and then click Next.Click the Report datasources button at the top of the screen and then click the New button.Host: localhost (or the IP address of Fishbowl server)
FISHBOWL INVENTORY MYSQL CONNECTION DRIVERS
Expand the Drivers folder, right-click Fishbowl MySQL, and then select Connect Using.Enter Fishbowl MySQL in the Name field and then click OK.Click the Add button, select the C:\Program Files\Fishbowl\lib\mysql-connector-java-5.Expand the Databases section, right-click Drivers, and then select New Driver.Open iReport and press Ctrl + 5 to open the Services pane.This file can then be unzipped and placed in the C:\Program Files\Fishbowl\lib\ folder. If the lib folder only has a mysql-connector-java-8 file, the mysql-connector-java-5 file can be downloaded by clicking here. Browse to C:\Program Files\Fishbowl\lib\ and locate the mysql-connector-java-5.The database service is not required to set up or create a report, although it is recommended. iReport also comes with a database service that can do the same. Click the Open button and then click OK.įishbowl includes a Data module that can be used to view tables and test queries.
![fishbowl inventory mysql connection fishbowl inventory mysql connection](https://www.fishbowlinventory.com/w/images/3/36/Logging_level.png)
![fishbowl inventory mysql connection fishbowl inventory mysql connection](https://www.fishbowlinventory.com/w/images/9/98/QB_salesrep_error.png)
FISHBOWL INVENTORY MYSQL CONNECTION INSTALL
To install iReport, run the installer from here.