Access Koha database tables for Crystal Reports
Dear all, Has anyone succeed in using Crystal Reports with Koha? I am trying to create various Koha reports using Crystal. I have successfully installed an ODBC connection to the database via MySQL. When I try to create a new Crystal Reports using the report wizard, none of the Koha database tables are loaded (though I have selected Koha has the data source). Is there something else that I need to do? Thank you for your assistance. Kind regards, Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Access-Koha-database-tables-for-Crystal-Re... Sent from the Koha-general mailing list archive at Nabble.com.
On 7/18/2013 1:51 AM, Iming Chan wrote:
Dear all,
Has anyone succeed in using Crystal Reports with Koha? I am trying to create various Koha reports using Crystal.
I have successfully installed an ODBC connection to the database via MySQL.
When I try to create a new Crystal Reports using the report wizard, none of the Koha database tables are loaded (though I have selected Koha has the data source).
Is there something else that I need to do?
Hi, We use Crystal Reports standalone and Crystal Server with Liblime Koha, but it really shouldn't be any different for connecting to mainstream Koha, as you're not really connecting CR to Koha, but rather to MySQL Server. The Koha software has no role in this connection. Just guessing (because this was a headache in our testing) that your problem may be related to Windows bit depth issues. It's definitely an issue for Windows 7 or Server 2008 that are native 64-bit. Because Crystal is 32-bit software it requires that your ODBC connection be set up in the 32-bit version of the Windows ODBC Data Sources control panel. The version of this panel that opens from the Start menu is the 64-bit version. To launch the 32-bit ODBC Data Sources panel, open a Windows command line and enter: c:\windows\sysWOW64\odbcad32.exe Then create your Koha ODBC DSN. During the DSN setup procedure, you should have an option to Test the connection. If MySQL Server can be connected to over the network, and your SQL user name and password are accepted by the server, then you should be able to pass this test. If you cannot pass this basic ODBC configuration test, then Crystal Reports will surely not work. If you pass the test, Crystal should have no problem. Again, be sure you're testing a 32-bit DSN for use with Crystal. Other issues that we bumped into with CR: * be sure to select the utf8 character set under the "Details" section of your Windows ODBC DSN configuration * you may want to also choose "Allow big result sets" * you may want to also choose "Don't cache results" (especially if you get "out of memory" errors) Hope that helps, -- Greg Barniskis, Computer Systems Integrator South Central Library System (SCLS) <gregb at scls.lib.wi.us>, (608) 242-4716
Iming, You need to configure Crystal Reports with a connect string to the database that you are using. Typically that would include the server name or IP address, ID to log in to the database, and the password. This will connect to the database and allow you to view the tables and columns. There should be an option under a tools or other menu selection. Hope this helps. Jerry Brock e-Libris Technologies, LLC 877-723-9447, Option 1 On Thu, Jul 18, 2013 at 1:51 AM, Iming Chan <imingchan@yahoo.com.au> wrote:
Dear all,
Has anyone succeed in using Crystal Reports with Koha? I am trying to create various Koha reports using Crystal.
I have successfully installed an ODBC connection to the database via MySQL.
When I try to create a new Crystal Reports using the report wizard, none of the Koha database tables are loaded (though I have selected Koha has the data source).
Is there something else that I need to do?
Thank you for your assistance.
Kind regards,
Iming
-----
Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Access-Koha-database-tables-for-Crystal-Re... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerry Brock e-Libris Technologies, LLC email: elibris.helpdesk@gmail.com <elibrishelpdesk@gmail.com> phone: 1-877-723-9447 ext. 2
Thank Greg and Jerry for your assistance. My primary goal of using Crystal Report is to reuse a spine and book (dual) label template that has worked well for us in the past (while using previous ILMS). I have found a way to use Crystal Report without resolving the ODBC connection issue I had. Koha's label generator can output selected (batched) items in CSV format. After adding column names using MS Excel and then saved as CSV file format, I am able to use Access/Excel connection protocol and pinpoint to the specific file concerned within Crystal Report. As I have modified the report template with new field names, I simply "refresh" the report before each printing. Now the full call numbers (eg. REF 123.456789 ABCD) are displayed as: ** On the spine label ** REF 123. 456 789 ABCD ** On the book label * REF 123.456789 ABCD (like the example above). Thank you again for your reply. Regards, Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Access-Koha-database-tables-for-Crystal-Re... Sent from the Koha-general mailing list archive at Nabble.com.
participants (3)
-
e-Libris Helpdesk -
Greg Barniskis -
Iming Chan