[how to handle Big Numbers in ireport?]

Hi,

Click on the field, in the properties of that field, you will see a property named "pattern".
Open the pattern and select number and give the desired pattern to print the field.

Hope this helps,
KKriplani

[Encrypting passwords in URLs]

Hi,
The link was as follows:

http://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v55/encrypting-passwords-urls

However, I was unable to implement the same on Jasperserver 6.3 community edition.

Thanks for your reply,
KKriplani

[Default checking of all checkboxes for a Multi-Select Query Input Control]

Hi,
Okay i seemed to have found a solution, give it a try.
All you have to do is as follows;
1) keep the default expression of the parameter fetching value from multi-select Input control as blank, i.e, insert no values.
2) And keep the multi-select input control as non-mandatory.

The behaviour of multi-select that I observed was, non of the boxes will be checked but the query would pass the value as :
"where 0=0"
That means, all the selections are considered. 

Regards,
KKriplani

[Encrypting passwords in URLs]

Hi,
I came accross a link for encrytion of passwords in URL and followed the steps very carefully.

I would like to know if these steps don't work for community edition since i wasnt able to get the desired results or I might be making some error.
Also I tried the same steps on proffessional edition and it worked in the first go.

Please advice.

Thanks in advance,
KKriplani 

[unable to create table using subreports in jasper reports]

I am afraid I dont have any such examples, but tell me a couple of things;
1) When you execute the complete report with table as subreport, the query in the logs for the table is returning data in the database?
2) Have you linked the parameters of main report and sub report?

If the answer to point 2 is no, probably null values are passing for parameters in the table query when you execute the report as a whole consisting of the table as a subreport.

Hope this helps,
KKriplani

[Dynamic query]

Hi,
Then I guess the issue is not with the conditional parameter. There may be an issue with passing the parameter value. 
Tell me more about how are you getting the value for $P{Id} ?
Is it in a dataset? Are u using it in a table? Or its just a parameter retrieved from an Input control?

Regards,
KKriplani

[unable to create table using subreports in jasper reports]

Hi,
Look into the below listed two points;
1) Check the logs if there is any error (if error occurs, share the error).
2) From the logs, also rerun the query to check if the values are populated for the selected parameters.

Regards,
KKriplani

[Dynamic query]

Yes, it is very much possible to do so using conditional parameters (see the last answer in this link ) represented as $!P{}

Try approaching like this;

$P{Id} == null ? "where 0=0" : "where id=" +$P{Id};

Regards,
KKriplani

[In a stacked bar chart, display bar if the value of the bar is 0 (display a thin line on the X axis)]

Hi,
I am not sure about the possibility of your requirement but however I suggest you use data labels. The data labels will display the value for each bar thus making it clear that a bar has 0 value.

Hope this helps,
KKriplani

[Conditional Display of a report item]

Hi,
I am not sure as I have not come around such a requirement specifically in Studio.

Regards,
KKriplani

[Can we install the two instances of Jasper server in one Tomcat.]

Hi,
Yes you can very well do that but make sure of the below listed points;
1) The jasperserver db name should be different (js.dbName).
2) The jasperserver name should be different (webAppNamePro).
3) The diagnostic port should be uncommented and increase the port number by 1 (diagnostic.jmx.port).

These changes are to be made in default_master.properties before js-install.

Regards,
KKriplani.

[Conditional Display of a report item]

Hi,
Well you can write a few lines of customizations in the dashboardViewer.jsp (at webappsjasperserver-proWEB-INFjspmodulesdashboard). Write a script for your requirement. 
That might help. 
In the recent few requirements, I have had basic customization requirements as show and hide of report fields and I used dashboardViewer.jsp since this file loads as and when a dashboard opens.

Hope this helps,
KKriplani.

[Conditional Display of a report item]

Hi, 
Give me a suitable example for your requirement to get a better understanding. But as rightly stated by Hozawa, JasperReport is a Reporting tool only.

Regards,|
KKriplani

[What could be the reason for a "blank" report when passing a certain parameter from apex?]

Hi,
The first thing you should do is check the jasperserver.log file. Test the running the query and check if it returns any records. Probably, if you are using any joins in the query, its breaking with the value of to_location. 
This could be one resolution, if not, share the jasperserver.log file (in a saparate file for better understanding).

Hope this helps,
KKriplani

[Can Jasper do this?]

Hi,
JasperServer has a functionality of retirieving the logged in username.
Just create a parameter as $P{LoggedInUsername} . This parameter retrieves the logged in username used and you can create a conditional parameter using this value.

Read this link to know more about Conditional Parameters.

Hope this helps,
KKriplani

[Not able to see jasperserver login page]

Hi,
Hozawa has a good suggestion. 
If thats not the case, share the catalina.out.

Regards,
KKriplani

[What is the $P!{} Parameter , How it is used in Jasper reports]

Lets suppose I have the following query,

Select L_name, 
age_1,
$P!{check} as Characteristic
from table

This paramater allows me to view the various characteristics of the person I am refering above. It would be dependent on another parameter, let us call that parameter as $P{value}. 

In the default expression of the parameter "check", I could define the following;

$P{value}==1 ? "Physical_strength" : $P{value}==2 ? "IQ": "Nature";

Depending on the various values of $P{value}, the parameter "check" will input the values into the query and mind you, the above three stated characteristics are nothing but the table columns, so basically we are displaying different columns based on the parameter "value".

For instance, the parameter "value" was entered as 2, so my running query would look like (which you can check in the logs);

 

select L_name, age_1, IQ as characteristics from table

Hope this explains all.

Regards,
KKriplani

[How to make report visible to User "A" only Not "B" which is created by User "A" as jasper user]

Hi,
The simplest way would be to add a parameter in the report as $P{LoggedInUsername} and update the query of the report adding a filter as ;
"and $P{LoggedInUsername} = 'jasperuser'  "
so the query will fetch data only for that particular user.

And also include a no data band so the other user views it.

Hope this helps,
KKriplani

[Details: Cannot call sendRedirect() after the response has been committed]

Hi all,
I am using visualizejs of jasperserver 6.2 on a remote server and deployed my UI calling a report from the jasperserver in the same remote server. The issue is the first time i run the report, I get the above error but when I refresh the browser, the report is redered just fine.
I am using tomcat 7 and JDK 7.

I am not sure what the issue is, can anyone please help?

Thanks in advance,
KKriplani

[How to add 'Current date' in Header of reports generated from Adhoc view in 6.2 jasper-Pro?]

Hi,
Is it okay if we have a report designed from iReport/Studio and embedd it in a dashboard along with the report from adhoc?
If its okay, you can design a report from iReport which would include just the page footer and last page footer.

Hope this helps,
KKriplani 

[Regarding calling of parameters from subreport to main report]

Hi,
By "fields are not retrieved automatically", you mean to say that the fields are not generated in the query editor of the subreport while creating the report in iReport/Studio?


Regards,
KKriplani

[Jasperserver Report Server not accessible]

Hi,
From <tomcat-directory>/logs/ and share the catalina.out file.
Basically it is possible that tomcat is up but your jasperserver-pro app is not functioning (there may be various errors like "SEVERE: ERROR LISTNER START" etc) but only the logs could tell.
So, attach the logs in a file and share it here.

regards,
KKriplani

[How to sum two parameters from subreports]

Hi,

First of all check if both these variables return a value in the main report by printing them.

Regards,
KKriplani

[How to use optional parameters?]

Lets suppose I have the following query,

Select L_name, 
age_1,
$P!{check} as Characteristic
from table

This Query allows me to view the various characteristics of the person I am refering above. It would be dependent on another parameter, let us call that parameter as $P{value}. 

In the default expression of the parameter "check", I could define the following;

$P{value}==1 ? "Physical_strength" : $P{value}==2 ? "IQ": "Nature";

Depending on the various values of $P{value}, the parameter "check" will input the values into the query and mind you, the above three stated characteristics are nothing but the table columns, so basically we are displaying different columns based on the parameter "value".

For instance, the parameter "value" was entered as 2, so my running query would look like (which you can check in the logs);

 

select L_name, age_1, IQ as characteristics from table

Thank you
KKriplani

[How to limit the number of items that a user can select from a multi select control]

Hi,
This is a long shot and i haven't implemented anything as such. But logically it seems feasible.
Try limiting the multi select query control using a where clause (where rownum <=10) in the control query to get the only first 10 values into the control.

I hope this helps,
Regards,
KKriplani