pawelkosi

Hi everyone I have a problem with visualise.js not producing report export file. What happens is: I am able to succsefully load the report through the visualise.js API, it loads and displays on my web pageExport controls load up successfully too, so I have dropdown with export file formats and a button to export the file.When I click the export button though, the whole page reloads as if the export button was really a submit button and nothing happens.Weird thing is that occasionally, the export will work and it will produce file. Though there is no pattern to when it will produce the file and when it will fail.Below is the code I am using for this (I am using plain text auth for testing purposes): JS: visualize({ auth: { name: "mylogin", password: "mypass", organization: "organization_1" } }, function (v) { var $select = buildControl("Export to: ", v.report.exportFormats), $button = $("#button"), report = v.report({ resource: "/FPSReports/journal", container: "#export", params: { "journal_ref": [ "<?php echo $reference; ?>" ], }, success: function () { button.removeAttribute("disabled"); }, error : function (error) { console.log(error); } }); $button.click(function () { console.log($select.val()); report.export({ // export options here outputFormat: $select.val(), // exports all pages if not specified // pages: "1-2" }, function (link) { var url = link.href ? link.href : link; window.location.href = url; }, function (error) { console.log(error); }); }); function buildControl(name, options){ function buildOptions(options) { var template = "<option>{value}</option>"; return options.reduce(function (memo, option) { return memo + template.replace("{value}", option); }, "") } var template = "<label>{label}</label><select>{options}</select><br />", content = template.replace("{label}", name) .replace("{options}", buildOptions(options)); var $control = $(content); $control.insertBefore($("#button")); //return select return $($control[1]); } });[/code]The code above is used to generate the report and to generate the controls. HTML: <div class="grid"> <div class="grid-8"></div> <div class="grid-8 center"><a href="" id="button" class="large link_button margin2">Export</a></div> <div class="grid-8"></div></div> <div class="grid"> <div class="grid-24" id="export"></div> </div>[/code]The report I am exporting is small one page report, it loads in no time. I really do not understand where there could be an issue. Is this some kind of timeout happening? Thanks for all the help in advance!

Hi, I am in need of simillar thing. I need to display a dashboard for certain level of users. Do anyone knows a way to do it that works and is in English? Regards

Hi Guys, I am currently evaluating JasperReports Server pro and Jaspersoft Studio Pro. I have created simple report with one parameter; When you select the parameter option from the combo box on the report you need to press apply button to see the data update. Question is: Is there a way to apply parameters dynamically, missing the 'apply' button step? So you have your combo-box with list of options, you select/click on one option and your report updates then, not after you click apply button. It just seems like totally unnecessary step when you have simple report with simple querries. Thanks to anyone who can help!!!

Elizam, thank you once more for replying. That got me thinking, would it be easier then to send low-permission user straight to dashboard / report or maybe a list of reports? I might be again talking here about something easy, I havent come across anything like that in the manual yet. I would be fine with sending user to the Report List for example. Then I could simply disable links for 'home' and 'create' through bit of code and CSS and I would pretty much have what I wanted. Is that possible? Please say yes *holding fingers crossed* Please say yes Please say yes Please say yes :)

Sorry mate should have stated that I use the latest Jasperreport server pro and the pro designer. My bad and thanks again for replying!!!

Hi Guys, I am banging my head here, surely it can't be that difficult. I am trying to find a reference or mention in the guide / manual about how to remove elements from the home screen based on user permission. I want my standard user to be only able to view 'Reports' and 'Dashboards', I don't want him/her to see 'Data Sources', 'Domains' and 'Ad Hoc views' on the home screen when they log in. Is there an easy way to do that, is there something dead obvious that I am missing? Please help!

Hi guys I have this error that started to appear when i run my report in Jaspersoft Studio 5.5. I havent changed anything, increment type is set to none. I am stuck as it seems I cant find the problem anywhere. Error: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Increment class not found. at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:482) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:457) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:347) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)Caused by: net.sf.jasperreports.engine.JRRuntimeException: Increment class not found. at net.sf.jasperreports.engine.fill.JRFillSubreportReturnValue.getIncrementer(JRFillSubreportReturnValue.java:127) at net.sf.jasperreports.engine.fill.FillReturnValues.copyValue(FillReturnValues.java:248) at net.sf.jasperreports.engine.fill.FillReturnValues.copyValues(FillReturnValues.java:230) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:792) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:332) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:384) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:358) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2059) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:778) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:288) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at java.lang.Thread.run(Unknown Source)Caused by: java.lang.ClassNotFoundException: at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:175) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115) at net.sf.jasperreports.engine.fill.JRFillSubreportReturnValue.getIncrementer(JRFillSubreportReturnValue.java:122) ... 13 more[/code] Thanks for any help! Pawel

Hi Guys I am struggling with something and I hope you will be able to help me. This is my scenario: In the main report I have six sub-reports that each display 3 values based on the parameter selected in the main report. I have passed all 18 variables back to the main report and when I test them it all works fine (The text fields and the sub-reports are in the same band, when I use evaluation time ‘band’ I get my values passed from sub-reports displayed in the main report). It all works so far. Next I want to make two charts (simple bar chart) each using 9 variables returned from the sub reports . When I put my variables in the ‘value’ and I run the report the chart is empty. Chart itself is set to the evaluation time ‘band’ as it also resides in the same band. All 18 variables are simple numbers. Below is the example from excel of what i am trying to reproduce. Its based on mockup data. User selects a location and depending on it the values in the table are selected. Then from those values a simple chart is created as seen on picture. Thanks in advance for any help! Regards Pawel

oh and Yes I will be deploying this to JasperReports Server.

Hi Sjored Thank you very much for answering! Yes that was a part of it. Here is where I am at the moment: 1. You get the prompt for the value from table1 and table2, and then the both values get concatenated in variable1. So basically I have the concatenated code as I needed. 2. Now I want to pass that variable to the table dataset so the table can display the relevant record for that code. Unfortunately this is where I have hit the problems. I have few questions regarding this, if you will be willing to answer them: 1. Is there a way to copy or move the output (or end result) of variable into the parameter? I know I can pass parameters to the table, but passing variables didnt work. 2. I have found someone elses question here asking about similar problem and the answer was to do the relevant concatenation within the parameter 'Default Expression Field' instead of using variable. But when I try to do that I get errors, my open parameters do not show fields or variables in expression editor only other parameters. This is the URL of that answer: http://community.jaspersoft.com/questions/543919/pass-variable-values-parameter-values-sql-query-how Where part of the answer is: "In your case you will need to do the calculation of your dates in Parameters using the parameter default expression property." 3. Then I have found another answer, again similar to mine where there was talk about scriplets: http://community.jaspersoft.com/questions/514882/passing-variable-value-parameter-end-report "You need scriptlet magic. First create a scriptlet to do the value passing. This example takes an Integer variable and sets a String parameter, then returns the String contents of the parameter so it can be displayed in a text field:" Do I really need scriplets to pass value from variable to parameter? Is there any other way of doing it? Thanks for your answer once again! Pawel

Well, maybe I came across wrong - the software is still great and I haven't found anything better on-line. Bugs are not show-stoppers at all and the documentation assumes a lot, this is what I mean by holes. JasperSoft Studio is new (from what I understand and read) and you have to forgive it few things. I spend around 8h a day now testing and evaluating this software and my bill came to around $70 which is not bad (if you wont sleep, eat and do pretty much anything else but hang on the server then yes you would pay $400). If you want to have something good you have to pay, I have pretty much accepted that. Once you get over the hurdle of creating report the end user (as in your client, boss, people from the board) do not need to know anything about JasperSoft to be able to manipulate the data on the fly as they see fit. If you are strong coder you can try to build something yourself but I tried that approach and the time investment would be too massive for what I need for now. And to finish, I am just another user and I tried to answer your question the best I could looking at my own example. No need to be hostile. I am not telling you what to do, I am telling you what you MAY do. I am sure you are big enough to make your own mind up. regards Pawel

Hi Adam, I was in your shoes about a month ago. I am still learning but I am making steady progress. First of all be prepared that you will have to brush up on your SQL, Java and JavaScript. If you will want to present beautiful graphs, tables charst etc online then you will also need some understanding of HTML5 and CSS. Best solution for start is getting JasperReports Server through Amazon AWS (you pay per hour and only for what you use) the cheapest option is around $380 for month (if you used the server 24/h at 100% capacity which lets face it wont happen when you are only testing). It is also good idea that you use Amazon RDS for your testing database, the smallest DB server is free - with some restrictions. Unless you have really robust dedicated server that holds your database at work I would use external service. When you get your JasperReports Server through AWS you will also get licences for commercial versions of the development software - iReports and JasperSoft Studio. Community versions of the software lack certain important features. In addition with comercial option you get access to more training material - its not great, and I have already submited changes to the manual myself but it is still better than nothing and gives you place to start. Other suggestion is, dont use iReports but download the JasperSoft Studio. iReports will be phased out and the JasperSoft Studio is the evoultion of the iReports. The learning curve is quite steep, especially with the JasperSoft Studio but you will get the basics pretty quickly if you spend honest few hours a day learning and tring new things. Most of the documenst you need are here on community portal, when you register for AWS you will get access to docs on the main website too. I suggest you read all the manuals first from cover to cover, they are still full of holes as I painfully learn but still give you a good base of understanding. By the way, ask your boss to get you Windows 7 :) or if the PC is too old then ask him/her for replacement. JasperSoft Studio is already filled with bugs, I can only imagine that you will have more problems with it running it on dated OS.

Hi Guys, I am building this test report in Jaspersoft Studio and I am hoping that some of you will be able to help me or point me to material / manuals / tutorials that would help me with this. What I want to do is qute simple, and dead easy in a spreadsheet but I am struggling with it in JasperSoft Studio, here is what i want to achieve: I want the end user to do the following: 1. Select from dropdown menu value 1 (I have simple table with two columns - value1 and description, I want the users to be able to use description to select value1) Value1 is string. 2. Select from dropdown menu value 2 (same as above, two columns - value 2 and description. Select the value by its description) Value2 is string. 3. When both values are selected I want to concatenate them to form one code. To give you an example, value(s)1 look like: ab-c1-d1 and value(s)2 look like: ef-gh-00 now I want to concatenate them to form one line of code with extra hyphen between them to form this: ab-c1-d1-ef-gh-00 4. That unique code corresponds to a value in a third table that I want to display. I have managed to do half of the job already, I can select from all tables and display the corresponding values but there is no connection between them as I want. I hope I am clear enough, and thank you in advance for any help! I am stuck with this for some time and the info on the net is scarce, unless I am looking for wrong things. All the best to you all Pawel

Well I can't see metadata either. Just thought it wasn't big problem. I am using 5.5.0 Proffesional. Regards

After some digging around I have found that the problem wasn't with my querry but with built-in sorting (Select limit 100) in JasperSoft Studio .mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=100' at line 1 I guess it is a bug, I will report it to the bug tracking system.

Hi Guys, I am learning MySQL at the same time as Jaspersoft Studio. I am following tutorial 'Adding Parameters Activity' from the online learning portal here on the website. I am connected to my database and I can retrieve all the tables no problem, but when I try to add simple WHERE clause to the report querry I get syntax error, even though I follow everything exactly as it is in the tutorial. I have two columns, one is called 'UniqueKPICode' and holds string value (mix of letters and numbers) and other column is called 'AugYtdAct' that holds numerical (double) value. select UniqueKPICode, AugYtdAct from accountsimportnewwhere UniqueKPICode = "DvOvx-Dv3-2-na-SCos"[/code]I was trying to retrieve one record as per tutorial, the editor doesnt report any problems with this expressions though when I run the querry I get MySQL syntax error. Link to the tutorial: https://www.jaspersoft.com/scorm_data/DevelopingReportswithJaspersoftStudio_0516/data/execute Thanks for any help! Pawel

I am just posting comments from the question above for easier reading. If you find yourself with simillar problem read on: Hi, Can you please confirm if you deployed your Jaspersoft for AWS using our cloud formation template or through 1-click / EC2 console? abroitman - 4 days 2 hours agoHi, sorry for not replying earlier. Yes I did, I have done it through EC2 console as my region only supports VPC. I have used Jaspersoft for AWS guide (pdf) and followed it step by step. pawelkosi - 1 day 8 hours agoI am having the same problems. When creating a new amazon acount the region only supported VPC Does the the Jaspersoft AWS install guide does not actually work in this default scenario? I tried the alternative install method using PDF at: http://community-static.jaspersoft.com/sites/default/files/docs/jasperso... I got the alternative instance installed. But i still get the same error message: Exception occurred during AWS data source recovery: /organizations/organization_1/datasources/Shipments. The vpc ID 'vpc-xxxxxxxx' does not exist com.jaspersoft.jasperserver.api.JSAwsDataSourceRecoveryException: Exception occurred during AWS data source recovery: /organizations/organization_1/datasources/Shipments. The vpc ID 'vpc-xxxxxxxx' does not exist at com.jaspersoft.jasperserver.api.engine.jasperreports.util.AwsDataSourceRecovery.createAwsDSSecurityGroup(AwsDataSourceRecovery.java:97) at com.jaspersoft.jasperserver.war.action.DataSourceAction.testAwsDataSource(DataSourceAction.java:568) at ploomreporting - 1 hour 24 min agoThat is the same thing I am getting and to be frank I stopped trying to fix it. Just setup your database as external JDBC source (just make sure that the RDS server and the EC2 server can talk to each other - add RDS server IP and port to the security group) It works for me so it should work for you. pawelkosi - 1 hour 11 min agoThanks Pawel I jsut used JDBC datasource to connect to SQL Server and it worked first time. I would still like to know why I cannot connect to an AWS datasource.

That is the same thing I am getting and to be frank I stopped trying to fix it. Just setup your database as external JDBC source (just make sure that the RDS server and the EC2 server can talk to each other - add RDS server IP and port to the security group) It works for me so it should work for you.

Message sent. Thanks for trying to help me.

On a whim I tried the licence I got from the iReports and it worked. Thanks again for pointing me to the right place Massimo!

I could not for life of me find this page ;// Thank you kind Sir! Just one last question, how do I get licence for it - as I understand since I pay for AWS I should have access to the commercial version of Studio with my subscription? Paul

Hi I am using Jaspersoft Bi for AWS and wanted to start using the Jaspersoft Studio to develop my reports. While I was reading documentation I have noticed that since I am paying customer I should have access to Jaspersoft Studio Pro (and not the community version) - I have been looking for it for the past hour and I cant get it. After registering for the amazon support I got the links to the iReport Proffesional but I hear that the Studio will eventually replace iReport. I do not want to learn software that will be phased out plus I have been using eclipse before for other work. Can someone clear this up for me? How do I get my hands on the Jaspersoft Studio Pro? Thanks for any help! Much appreciated! Paul

One important bit of info: I have edited the security group of my stack to allow connections from the IP address I run the Jaspersoft Studio from.

Hello everyone! I am very new to jaspersoft solutions so bear with me, I have what it might seem a very simple problem. I am using Jaspersoft BI for AWS (hourly), I have downloaded and installed the Jaspersoft Studio and now I am trying to connect it to the Jaspersoft Server but I am getting constant errors when creating new connection. faultString: java.net.ConnectException: Connection refused: connect I cant find any information about this problem, all tutorials assume that you use local installation of Jaspersoft Server. 1. Is there a licence problem somewhere that I am not seeing? 2. What port does the installation of Jaspersoft Server use on EC2 instance - there was no information about it anywhere. I was using port 8080 which i confirmed is open but then I checked my ec2 instance and there was nothing listening on that port. 3. Is there something dead obvious I am missing? This should be an easy step: a.) configure your Jaspersoft Server b.) connect it to your Jaspersoft Studio using the server credentials. Thanks for any help! Paul

Hi, sorry for not replying earlier. Yes I did, I have done it through EC2 console as my region only supports VPC. I have used Jaspersoft for AWS guide (pdf) and followed it step by step.