[I create a report and open it in pdf, but the file is empty]

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.

[I create a report and open it in pdf, but the file is empty]

Hi,
What does the jasperserver log spit out?

 

[Adding borders to textField depending on a param]

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

[Reports are not running after scheduling]

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

[Reports are not running after scheduling]

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

[Jasper Scheduled Report]

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

[Problem with scheduler on Jasperserver]

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

[Date Picker in Jasper]

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

[Does SQL execute again when selecting to export to PDF]

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

[problem in creating more than one sub report]

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.

[problem in creating more than one sub report]

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]

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

[problem in creating more than one sub report]

Hi,
First of all check the jasperserver logs and attach a file for the same on this forum.
 

[How do I hide a table when its resultset is empty?]

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

[Report loading time issue]

Hi,
Basically your tomcat needs to be tuned. Here are a few steps to do the same.

Regards,
KKriplani

[How to improve jasper report generation faster any config need to change in Jasper-Pro server]

Reading this article will help.

http://community.jaspersoft.com/wiki/jasperreports-server-performance-tips-and-tricks

Regards,
KKriplani

[A simple suppression question of a 2nd Detail Band]

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]

You should read about Report Scheduler in jasperserver. You can mail the attachment at a preferred time using jasperserver which requires your mail configuration.

[Jasper 6 upgrade broke main menu]

Its surely bound to give a jar conflict.
Updating the lib folder with postgres 9 jar should help.

[Jaspersoft Subreport Collection Parameter - Order issue]

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. 

[Layout error when band split type is stretch or immediate]

Are you using a table component?

Make sure these fields have the same height.
 

[Jaspersoft Subreport Collection Parameter - Order issue]

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

[How to pass string into $X{IN} using URL?]

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.

 

[Jasper Server Community Frozen]

check the installation logs under;

Jasperserver folder >> buildomatic >> logs and find the last installation logs and check if there is any error.

[Supress Footer band when print Group Band.]

Glad could help.

Regards,
KKriplani