kkriplani

Hi, As rightly said, there aren't any other document but do share if you find one. Thanks in advance, KKriplani

Hi, I have a question on your query; Are you asking about mandatory input control or parameter? There is a good difference between the two. Avoding a parameter can be done by the use of a conditional parameter and this change is done in the query while making a Input control optional is simply done by right clicking on the input control, going to the properties and unchecking the box for Mandatory. Hope this helps, Regards.

Hi, Please clarify if you are looking for default values to be set for a report? Regards, KKriplani.

Hi, Just to clarify the scenario, You have a subreport designed for 500px but the subreport element in the main report is of 200px, yet the size in main report is observed as 500px. Am I right? If yes, See, the report will be populated as per the size of the subreport. If you do so, the main report may not print all or overflow or maybe give an error. Try keeping the subreport size and the subreport elemnt size the same. Hope this helps, KKriplani

Hi, As I said earlier, this isnt possible as per my knowledge. But however you can view the complete name in the tooltip. I had the same requirement as yours earlier but I had to settle down for the one mentioned above. If I get to know any further, I will let you know and you please do the same :) Also please mark the appropriate answers right as they will close the thread and help others get the best answer to the similar requirement. Regards, KKriplani.

Hi, What you need is to implement input controls (ICs). ICs pick the value from the jasperserver user and pass it into the parameters in the query. ICs give you the option to select values from a drop down etc. Regards, KKriplani

Alright. Follow these steps; 1) Stop tomcat. 2) At the path; <tomcat-directory>webappsjasperserver-proWEB-INFclasses add the property anywhere in the file, jasperreports.properties as stated below; com.jaspersoft.jasperreports.highcharts.function.properties.allowed=true 3) Delete work and temp folder from the tomcat-directory and restart tomcat. 4) Now using ireport designer / jaspersoft studio, set the advanced property for the chart as; xAxis.labels.formatter (Use an expression) "function(){return this.value.toString().substring(0, 5);}" Here, I am displaying just the first 5 letters of the X Axis label, you can modify as per your choice. Regards, KKriplani

Hi, Yes, But not exactly the same. Something very similar is possible. Possibility: The label along the axis will be limited to a specific number of letters (including spaces) but upon hovering over the bar chart, the tooltip will display the complete name/value. Let me know if you need help doing the same. Regards, KKriplani.

Hi, This is a long shot but have you tried; "R$ " + $F{soma} As for the pattern of Soma, you can click on the field and give it a pattern in the property. Regards, KKriplani

Hi, Just a couple of questions; 1) Have you set the "Value and Visible columns"? 2) Is the Datasource (in that input control) correctly mentioned? Regards, KKriplani.

Hi, Could you please explain better about your requirement? Regards, KKriplani

Hi, Okay I see. I can think of one more simple method. Using this method, even if you select more than one checkbox, the check box may seem to have been selected but none will pass in the main query. To do so, use a simple $P!{abc} called the conditional parameter. The implementation is as follows; 1) Create a parameter, lets say $P{abc} 2) Lets consider the parameter in which the multiselect be named as $P{xyz} 3) For the default expression of parameter abc, state the condition as : $P{xyz}.size() = 1 ? $P{xyz} : "null" 4) In the main where this query is sending in its data, define the query as: .... where event_type IN ($P!{abc}).... This is just a thought and logically possible. Hope this helps, KKriplani

Hi, I have a strong feeling that you have two postgres jars under <tomcat-directory>/lib There may be two jars, delete the jar of the lower version, delete the work and temp folder and restart tomcat. Hope this helps, KKriplani

Hi, "The tables need to be created, joined, and then I can select my final report data, and delete this data in the end." At first, I would like to know if the query joins are satisfied. Obviously everytime a temp table has to be created, all joins have to be satisfied. Secondly, Could you share the query to give a better idea of what is being done. Regards, KKriplani

Hi, It is achievable but I suppose it will get way too complicated. Why dont you try using a single select query input control type instead? Single select query IC will let you select only one value at a time only. Hope this helps, KKriplani

Hi Hozawa, Regarding point 2; I am no expert in jasper, but I would like to know how can we install jasperserver without a db. Usually we use postgres to store the dummy data for foodmart and sugarcram to test the sample reports. Thanks, KKriplani

Hi, For any report, there is a parameter named $P{REPORT_LOCALE} Your can use this parameter to define the format of the number. The use of a third parameter, lets call it $P{Number_format} , you can define this format as per the locale. Hope this helps, KKriplani

Hi, In a default expression I just changed the case of a parameter; before (working fine): $P{abc} after(Giving this error): $p{abc} I found the same error thus I suggest you check the case. Regards, KKriplani

Hi, Click on View >> Messages on jasperserver. Do you see any error there? Regards, KKriplani

Hi, 1) Try downloading from here http://community.jaspersoft.com/download 2) Yes you do need a db like oracle or postgres to install jasperserver and test your report. Regards, KKriplani

Hi, Posting the complete error might give a better clue. Regards, KKriplani

Hi everyone, I am getting a very weird error when installing jasperserver. The error looks like below; do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate host: localhost [echo] Host localhost is OK [echo] Done validating host: localhost [echo] About to validate port: localhost:5432 [echo] Port 5432 is OK [echo] Done validating port: localhost:5432 [echo] Validating administrative database connection at jdbc:postgresql://localhost:5432/postgres. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.2-1002.jdbc4 [echo] Specified JDBC driver jar exists [advanced-sql] Failed to connect: FATAL: invalid value for parameter "TimeZone": "America/New_York" [echo] Connection failed: [echo] SQLState: 22023 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: invalid value for parameter "TimeZone": "America/New_York"] Does any one have an idea of what could be the issue..? Thanks in advance, KKriplani

Hi, I won't say this is the right way, reason being queries take their time on running depending upon the query itself. If the queries are taking considerable time to run, a better practice would be to keep the queries in the main report and then link the parameters into the sub-reports. However, if the queries are taking less time, just carry on with your method. Regards, KKriplani

Hi, Passing main report parameters to subreport: left click on subreport and in the properties tab you will find a property named "Parameters". That is where you link the parameters. A better explaination is given here. However can you give a better explaination of the second question? What I understand is that you have 5 queries but you are rerunning a few queries for the chart elsewhere in a subreport. Am I right? Regards, KKriplani

Hi, The name of the IC doesnt matter but the make sure the id of the IC is the same as the name of the parameter. Regards, KKriplani