Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Attaching ireports to our sysaid Derby db.  XML
Forum Index » Analyzer/Reporting
 
Author Message
HODO
SysAider

SysAider from release 5.6 United States
Joined: 04/02/2009
Messages: 4
Offline

I'm quite new to ireports(used Crystal in the past). How do I "attach" create the connection in ireports to our derby db to manipulate edit reports? Is it possible to get the table structure of the DB?
Thanks
[Email]
techguy
SysAid Mod


SysAider from release 4 United Kingdom Pathfinder Meet me in Vegas - SysAid technology Conference - 28-30/4/2010
Joined: 11/06/2008
Messages: 1451
Location: England
Offline

you first need to setup a jdbc connection to the derby database.

See http://www.ilient.com/Sysforums/posts/list/621.page#2577 for some tips on obtaining a jdbc connector

Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki
SysAid#1
SysAid Mod


SysAider from release 6.5 Pathfinder
Joined: 02/11/2008
Messages: 709
Offline

Techguy

Can you sent me a screen shot of the Connection string used in ireport for the derby database.
[Email]
techguy
SysAid Mod


SysAider from release 4 United Kingdom Pathfinder Meet me in Vegas - SysAid technology Conference - 28-30/4/2010
Joined: 11/06/2008
Messages: 1451
Location: England
Offline

Sorry, I can't as I don't use the derby database.

Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki
TracyT
SysAider

SysAider from release 7.5 United States
Joined: 05/01/2012
Messages: 2
Offline

Can anyone tell me what settings I need to use once I create the JDBC per the above link's instructions? For example, I've done the steps needed, but now I actually need to connect to the JDBC thru iReports. It is asking for the name of the database and the user name and password. I don't have a clue what this is. I've been all over this forum and I really don't understand why this has to be such a secret. I'm sort of frustrated.
Forum Index » Analyzer/Reporting
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011
   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use