kkriplani
Members-
Posts
240 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by kkriplani
-
Hi, I need some more information. Jasperserver prepares jasperserver logs, those logs will give more information. EDIT: 1) Open "apache-tomcat-XwebappsjasperserverWEB-INFlogs". 2) Open file "jasperserver.log" 3) Clear the complete file and save. 4) Open Jasperserver and download again. 5) Copy and share all logs.
-
Hi, What does the jasperserver log spit out?
-
Adding borders to textField depending on a param
kkriplani replied to gabrieltcb's topic in Products
Hi friend, I would like to point out your attention at the option "Print When Expression". You could duplicate the textfield (for eg: One with all 4 borders and one with no borders). You could print the desired field based on your java param in the Print when expression. Maybe I don't entirely understand your question, if so, share a screenshot what you have and what you intend to have. Regards, KKriplani -
Hi, You should retry scheduling and try get the error in the messages issue or get the error trace from Jasperserver logs so we can understand the issue. Regards, KKriplani
-
Hi Santosh, You are looking at the wrong end. On jasperserver, go to View >> Messages and look for the error message related to your job schedule. Share that message so i can get a better idea as to what really stopped the report from generating. P.S. Select this answer as relevant and upvote it if the answer solves your issue, as it may help others with the same issue. Regards, KKriplani
-
Hi Himanshu, The issue is you are looking in the wrong direction. No change is required in the report. The change has to be made on Jasperserver. 1) Go to the scheduler properties of that report, Go to the notification tab (Right corner). 2) On the left side, click the very last checkbox that says "Do not send emails for empty reports". That should help. P.S. Select this answer as relevant and upvote it if the answer solves your issue, as it may help others with the same issue. Regards, KKriplani
-
Hi, On the jasperserver UI, hover on View and select messages. This would give you the error, share the error on this page. Also configure the scheduler to send you a mail in case of a failure and that can be done by editing the scheduler, clicking on the notification tab and filling the details under "Send job status notifications". Also check the two select boxes named as Include report job information and Include stack trace. Regards, KKriplani
- 2 replies
-
- scheduler
- jasperreport
-
(and 1 more)
Tagged with:
-
Hi, What you should do is get the Date in the query and then create a variable which will return the max date by setting Calculation to "Highest". But my question is, Why do you need the max date? Regards, KKriplani
-
Hi, No, the query only executes once when the report was generated. once you click on pdf export, the pdf is generated. However, in case of a scheduler, the query executes once everytime the scheduler mails a result. Regards, KKriplani
-
open the jasperserver.log, clear the complete logs and close the file. Now rerun the report and open the logs. Share the same here for knowing what the issue exactly is. Attach the file rather than sharing it in the comments.
-
Hi, In order to populate the jasperserver.log, go to the UI of jasperserver, login using the relevant credentials and click on manage, under manage click on "Server settings". for sql query executer, select DEBUG. Regards, KKriplani
-
No data message in a report with Table Component
kkriplani replied to naresh.kabra_1's topic in Products
Add a "No Data" band to the report. In the property of report, search for the property named "When No Data" and select "No Data Section". Regards, KKriplani -
Hi, First of all check the jasperserver logs and attach a file for the same on this forum.
-
Hi, Click on the table component. In the properties bar you will notice a property named: "When no data type". In the drop down for that property, select "Blank". Regards, KKriplani
-
Hi, Basically your tomcat needs to be tuned. Here are a few steps to do the same. Regards, KKriplani
- 1 reply
-
- configuration
- mysql
-
(and 3 more)
Tagged with:
-
A simple suppression question of a 2nd Detail Band
kkriplani replied to john.griffith's topic in Products
Click on the detail band, in the properties bar on the right you will see "Print When Expression". Enter the condition you want to print the report for. Regards, KKriplani -
Jasper Reports: Exporting report to multiple files
kkriplani replied to diegoqueres's topic in Products
You should read about Report Scheduler in jasperserver. You can mail the attachment at a preferred time using jasperserver which requires your mail configuration. -
Its surely bound to give a jar conflict. Updating the lib folder with postgres 9 jar should help.
-
Jaspersoft Subreport Collection Parameter - Order issue
kkriplani replied to sreerambabu.palaniswamy's topic in Products
Reason why you are getting that input is because while the query of the subreport executes, the input values for the collection parameter go together. example: select * from table_1 where p_para IN (2,3,4); This query is bound to return a single result sets with multiple rows or column depending on the fields. While if you don't use a collection type parameter but instead use java.lang.integer type, you can achieve different query sets. Example; Instance 1: when you enter the value of parameter as 2 Select * from table_1 where p_para = 2 which will return a result set, i.e, S1, S2 and S3 executes for value 2 (I1) Instance 2 & 3 : Similarly next run the report for 3 and 4 values of p_para. Here your requirement would be achieved but only at different instances.- 7 replies
-
- subreports
- parameters
-
(and 1 more)
Tagged with:
-
Layout error when band split type is stretch or immediate
kkriplani replied to sakit.atakishiyev_1's topic in Products
Are you using a table component? Make sure these fields have the same height. -
Jaspersoft Subreport Collection Parameter - Order issue
kkriplani replied to sreerambabu.palaniswamy's topic in Products
Hi, Since you are using a collection parameter, the query executes once for all the values of the parameter. I would suggest you use integer/string parameter and generate the report once for I1, next time for I2 and the third time for I3. Regards, KKriplani- 7 replies
-
- subreports
- parameters
-
(and 1 more)
Tagged with:
-
Create the input control using studio. The input control id should be same as the parameter name. For multiselect, you can either chose a list of value or pass a query using which the input control will be populated from the db. EDIT (ON september 29th): Since you have gladly marked your own answer right I am commenting here. let me warn you that conditional parameter method that you have used will give you an issue. What if the user hasn't selected any value. Your IN condition will look something like; "Where p_para IN ();" Which is surely bound to give an error. But using a collection parameter (& multi select input control), in such a case would replace the whole string with; "Where 0=0" Choice is yours.
-
check the installation logs under; Jasperserver folder >> buildomatic >> logs and find the last installation logs and check if there is any error.
-
Glad could help. Regards, KKriplani