kkriplani

Hi, I may not have a solution to decrease the height and suspect its not possible. However, I can give you a work around. Why dont you change the position of the input control to "Top of the Page"? That should solve the issue. Regards, KKriplani

Hi, In your previous question, I have replied for the first question A couple of reasons why datasets are used are stated below; 1) If you have to execute 2 or more queries and populate various charts and tables etc, you will have to use datasets. 2) A table always requires a dataset and never picks the main query. Regards, KKriplani

Hi, You can create a table and drop the field within the table. Note: Creating a table has a few steps like creating report connection and linking the parameters. Regards, KKriplani

Hi, 1) Try using port 25 instead. 2) Also add this line to applicationContext-report-scheduling.xml ; <props> <prop key="mail.smtp.auth">true</prop> <prop key="mail.smtp.starttls.enable">true</prop> </props> Hope this helps, KKriplani

Hi, If you are using jasperserver 6.2, then using tree map would be a nice option. Try creating one using adhoc view. Regards, KKriplani

Hi, I am no expert but I am afraid the query will be executed again. Jasperserver rexecutes the query and populates the reports again to get the current export. This is the normal behaviour. Regards, KKriplani

Hi, I have a very simple method. embedd an image/text field in the report (it may say "export"), give it hyperlink to the report you want to export in either csv or xls as ReportExecution and Parent. While linking parameters, pass a parameter name as "output" and expression as "xlsNoPag" or "csv" as required. Refer the image below. You can have two images/text fields saying "Export to CSV" and "Export to XLS". This should help, Regards, KKriplani

Hi, There is no such functionality in jasperserver to do so, Jasperserver populates a table from a table dataset. However, you can create a query such that all this data is available, for example using a Union in the dataset query should logically help. Regards, KKriplani

Hi, Either leave the default expressions of all parameters blank or leaving the default expression of any one parameter blank and marking that parameter as mandatory would help. The first option is generally preferred. Regards, KKriplani

Hi, Give a better insight of your requirement. what exactly you mean by dynamic connector? Are you trying to obtain data from more than a single database or type of database (for example from both mysql and oracle simoultaneously)? Lastly, what version of jasperserver are you using? Regards, KKriplani

Hi, When you login, under the login credentials selection, there is an option of "show locale & timezone". There isnt russian in that section so this is going to be tough as even if you create a new locale as russian (which for your information is done at applicationContext-security.xml within <tomcat>/jasperserver-pro/WEB-INF), you will have to define various config files at <tomcat>/jasperserver-pro/WEB-INF/bundles. Even if you dont create new files, the en_US locale files will be picked by default. So its of no use if you dont have the right files deployed for the the new locale created. Read page 152 from this guide shared here >> http://community-static.jaspersoft.com/sites/default/files/docs/jasperreports-server-admin-guide.pdf?_ga=1.213488466.777635134.1461570079 To sum up, you would need to deploy the lanuage specific file in <tomcat>/jasperserver-pro/WEB-INF/bundles , with the below format; <file-name>_<locale>.properties| and then call the same locale with applicationContext-security.xml (around line 146) within <tomcat>/jasperserver-pro/WEB-INF Regards, KKriplani

Hi, Yes you can view the logs. For that you will have to follow the below listed steps; 1) Jasperserver, click on Manage >> Server Settings . 2) Upon reaching the log_settings, set the property to debug for the things you want to view in the logs (inclucing "SQL Query Executer") 3) on the server where jasperserver is deploed, Go to <tomcat-directory>/webapps/jasperserver-pro/WEB_INF/logs and view the file named jasperserver.log , you will find the logs there.

Hi Guys, I am using jasperserver 5.5 and exporting a table into XLS format (xlsNoPag). The issue is that whenever I export the table, the zero values in the table are printed as - Is it a normal behaviour or is there any work around? Not sure what I am missing out. Thanks is advance, KKriplani

I can't really give the specific code but you will have to show and hide the input control based on their id. use something like explained in this link. Regards, KKriplani

Hi, These come as an additional customization. You can write a jquery/jsp code in a file within the scripts folder of jasperserver-pro and call them during run time in the dashboardViewer.jsp Regards, KKriplani

Hi, What you can do is using ReportExecution hyperlink, calling the same report again, create an addition parameter, let us call it p_Print and having a default expression as 0. When the report is rerun pass p_Print as 1 and for the page headers, pass the PrintWhenCondition as; $P{p_Print} !=1 So, as the report is rerun , this parameter is passed and it hides all the page headers (if multiple) and just prints the CSV formats. Regards, KKriplani

Hi, I am not a cent % sure but this may be an issue of rights. check if the user exporting the zip has the right to export or not. Regards, KKriplani

Hi, Using a table, have you linked the datasource and parameters of the table to that of the report? Also check if the dataset has the fields listed above? Regards, KKriplani

Hi, are you aware that jasper builds reports in xml format specifically called jrxmls (Jasper reports extensible markup language). Just build a report in designer and the xml will be updated in the backend. They are one and the same. Regards, KKriplani

Hi, At first run the same query in the database and verify if the result is the same. If so, obviously the reason is with the query else verify if the input control is created correctly (like if the datasource is correctly mentioned) etc. Regards, KKriplani

Give an example to understand the requirement better.

Thanks for sharing the Solution Hozawa, will give it a try. Regards, KKriplani.

Hi, Though I haven't dug deep into it but I feel that it doesnt work. I had a requirement of not displaying hyperlink when the value of that field is 0 but have hyperlink when the value is non zero. So i simply used two text fields (same text fields) one over the other, one with hyperlink and other without hyperlink and printed them using the printwhen condition. Regards, KKriplani.

Hi, The purpose of the subreport is just to return a result from the query? If thats the only point, add a dataset in the main report and just use the field value. That should help. Regards, KKriplani

Hi, Why not calculate the text field within the subreport and display the subreport containing only that calculated text field? I am not sure if that meets the requirement but give it a try. Hope this helps, KKriplani