kkriplani

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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