[Jaspersoft Studio Custom Component Tutorial]

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

Thanks in advance,
KKriplani

[mandatory parameters]

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.

[persist the formatting/filter rules]

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

Regards,
KKriplani.

[Subreport Width?]

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

[Axis label showing full upon mouse hover]

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.

[How to access database in jasperreports server without manually keying in parameter data]

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

[Axis label showing full upon mouse hover]

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

 

 

[Axis label showing full upon mouse hover]

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.

[BigDecimal Currency Money Charts Ireport]

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

[About query input control]

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.

[Render text field with string empty]

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

[multi-select query (checkbox)]

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

[Jasperserver-pro Login page is not displaying properly]

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

[Using Temp Tables in Jaspersoft Studio]

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

[multi-select query (checkbox)]

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

[start my first jasper report]

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

[Change the Number format as per the parameter pass in jasper report]

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

[Too many groovy classes were generated]

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

[generating the report with QUARTZ scheduler]

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

Regards,
KKriplani

[start my first jasper report]

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

[NullPointerException when Publish report to JasperReports Server]

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

Regards,
KKriplani

[Issue While installing jasperserver 5.5 with postgres 9.2]

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

[Subreports and dataset queries]

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

[Passing parameter to subreport chart dataset]

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 

[How to link input control with report parameter?]

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