Jump to content


  • Posts

  • Joined

  • Last visited

inki's Achievements


Apprentice (3/14)

  • First Post Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges



  1. Hi! I am getting started with the Jasperserver (Version: 7.8.0 Build: 20200807_1412). I have installed the server on both Ubuntu ver. 20.04.2 and Windows 10. I am using the community edition and the chapter starts with this caution: " If you don’t see some of the options described in this section, your license may prohibit you from using them" So my guess is ofcourse that the features below, like the 'create'-menu' is not available for the Community-Edition - in that case , what path should I take in the Guide to get aquinted with the functionalilty etc ? I am going through the TIBCO JasperReports Server Ultimate Guide (js-ultimate-guide-7.9), as well as the 'JasperReports-Server-User-Guide' located in the '/docs'-folder I am logged in as the user 'jasperadmin' or 'joeuser' - to see the difference. In chapter 2.1 'The Report viewer and Conditional Text' The only menus I see are the following: 'Library'/'View'/'Manage' - there is no 'Create'-menu. So I cannot follow that step-by-step guide starting with (1) Select Create > Ad Hoc View from the menu. In chapter 2.2 I am running into discrepancies and this section " JasperReports Server has several report templates in the Public/Templates folder of the repository." I don't see that 'Public/Templates'-folder. I hope that you are able to help me out here, so that I can get started with the Community best, Ingimar
  2. Hello! Using Jaspersoft Studio 6.14.0, running on Windows 10. To start with , I have been able to create a PDF-report using MySQL version '8.0.21'. I am able to connect to a local MySQL version 8.0.21. I am having problem with the Data Adapter for Microsoft SQL Server. I want to create a DataAdapter for Microsoft SQL Server, I start with my local instance to have full control. I have the following settings for the Data Adapter. JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriverJDBC Url: jdbc:sqlserver://localhost:1444;databaseName=NorthwindUsername: NRMa-ingierliPassword: <correct password>I have downloaded the mysql-connector-java-8.0.21.zip and I am using the 'mssql-jdbc-8.4.1.jre8.jar'-file ( in the 'Driver Classpath'). Running the SQL Server Configuration Manager I can see that (1) TCP/IP is enabled (2) IPALL has the settings (2.1) TCP Dynamic ports = 53777 (2.2) TCP Port = 1444. The Exception I get when pressing the 'Test'-button is net.sf.jasperreports.engine.JRException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'NRMa-ingierli'. ClientConnectionId:162824a3-5529-4491-bfc1-3cf8c4d02eeb at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:126) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:120) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.lang.Thread.run(Thread.java:748)Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'NRMa-ingierli'. ClientConnectionId:162824a3-5529-4491-bfc1-3cf8c4d02eeb at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5233) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3988) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3932) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3206) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2713) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2362) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2213) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1276) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:164) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:124) ... 4 more[/code]I am also getting the same error-message trying to connect to our central database with the same user. Q: could the error be linked to the username having a 'backslash' in it ?
  3. Hello,I am about to take over an old VB6-project (Windows Forms) and turn it into a VB.NET project. The old VB6-IDE has a PDF-designer, that looks a bit like a japserreports-designer (!?) - where you are able to create a layout and link fields/labels to a database-table. That old VB6-project that uses the pdf-'template' to generate a PDF when the printout-button is pressed. Could someone give me an overview of the Jasperproduct, would I be able to create PDF-templates ('iReport Designer'? ) reading from a database-table, then hooking that into a VB.NET- or C#.NET-application? or using the iReport Designer and then calling a webservice from the VB.NET/C#.NET application ? best, i
  4. Hi, I have a java server software, now I would like to get started with labels (QR-codes). Could you help me on my route here, were can I get started - how should I think ? Today we are running most services over a RESTful-API and that would be the preferred way when using a product from jaspersoft, Am I able to do that ( request : I send a text , response : i receive an QR-code image ) Best regards, ink ps. all tips are welcome, tutorials, course and books and blogs :) ds
  5. Hello! I cannot find a information on licences. Are there different licenses for different products ? Is it a single license or a dual license system ? Best regards, i
  6. Hello, Been using OpenReports, wanting to check out iReports. In Openreports i am able to add a SQL-statement and let the visitor /my colleague / go to a certain URL to add his parameter. That is ; I am able to add the question: Select golfcourse,hcp from player where firstname=${NAME} My colleague is asked to enter a name in a textfield on a certain URL. I am not required to do any programming, onlye to write a correct SQL-phrase. Is this possible in iReport ? Insted of creating the reports for all my colleague I only have to write SQL-phrases and they are able to go to a certain URL ? the example in Openreports gives one a good understanding of what is possible to do with this tool. regards, i:( :(
  7. Hello! Beeing a bit puzzled when visiting this site. - whats about all the messages beeing moved !? Wanting to test JasperReports to see if the application fits my need, used OpenReports and pretty satisfied with what I see - thinkin that JasperReports must be able to give me more of the same kind !? Am I right ? Developing on a XP, deploying to a linux/debian. Which documents should I read and which product should I run to see if Jasperreports is more than OpenReports but as easy as maintain for an Admin !? Or is Jasperreports on a lower level !? best regards, i
  • Create New...