maiskip
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by maiskip
-
-
I tried that thanks and watched the Podcast and I seem to be doing everything right but I still don't get any data back. My test connection is successful though. If I use the query wizard it does nothing. However if I type in a simple SQL statement like "Select * from Supplier" directly in the query window I then get a list of fields from my supplier table?! Weird. I can then select the fields I want and it says congratulations, you've created you report. Unfortunately, there is nothing in it.
I have also tried getting the Sample database working but when I do the Help- Samples - Run Sample Database bit I just get an error message there too: "An error occurred whle starting up the sample database. Database not running. Check the log from the ......." I viewed the log which means precisely nothing to me.
Thanks for the reply.
-
Hi again, I have been on holiday and come back and still have not managed to find my way around this problem - getting a bit fed up with it now.
If no-one has any ideas for a fix, could someone suggest another reporting tool with a more simple ODBC connect method please. I already have an Access DB but it is not cost friendly for us.
-
Hi, I have just downloaded iReports and I have fallen at the first hurdle as I can't get my database connection to work properly. When I click 'Test' it tells me that the connection has been succesful. I can also see the tables in my database in the next screen but I can't select any of them or anything from them.
I want to connect to our main system database which I normally connect via SQL, Access or Excel, etc. I have a DSN set up which uses a Visual FoxPro Database driver. Could someone give me an example of how to set up an ODBC connection through Jasper reports. (I assume I should be using the "Database JDBC connection" but I really could do with some syntax help from this point.
I also can't find where to edit a connection once I have made it.
I managed to create a report by pointing iReport at a csv but I cannot get it to talk to my visual foxpro database.
Any advice very greatfully received please.
Post Edited by maiskip at 06/29/2011 12:19
Newbie User - ODBC connection help - it shouldn't be that hard!
in Products
Posted
Thanks for that. I fianlly got around to giving it another go and I did actually think I was getting somewhere at one point but it was not to be. I have fields on my report but there is still no data despite the software having congratulated me on creating many reports. I have no problem with Crystal, Cognos, Access, Excel and others but this one just isn't having any of it. If I have problems at this stage then I don't really hold out much hope for my users so I think I am going to give this one a miss.
Thanks anyway.