[Unable to Save Datasource]

What about the catalina.log in the log folder of tomcat?

[Apply conditional style based on field value text = jasper studio]

Steps involve:

1) Right click on styles >> Add >> Style
2) give it a forecolor
3) right click on style >> Add Conditional Style >> give a condition like below;

   $P{GroupField}="text"

For the field you want to apply the style, click on the field and in the property select the style.

Note: This property would apply to complete string and not just one word of that field.

[Jasper 6 upgrade broke main menu]

Also, please tell me the version of JDK used.

[How to filter with date]

What is the name of the date parameter you have used in sql of the report? have you linked the input control with the parameter?

Run the logs and check what the query returns.

[Subreport in detail band: print only on first record]

Firstly, on your jasperserver, manage > server settings > for the property "SQL query executer", set the property value to Debug (from the drop down on the right).

Secondly, clear the jasperserver.log (empty the file, don't delete) and save. Then run the report and view the query that runs, run the query in the database by replacing the ? with relevant values.

This will help you check the result from your query.

 

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

The url build should be something like below;

http://localhost:8080/jasperserver-pro/report......&p_para=2&p_para=3&p_para=4

where p_para is the collection parameter.

 

[Supress Footer band when print Group Band.]

Since Jasperserver is just a reporting tool, you cannot hide the footer band when the Group footer is printed. However, if you can assign a parameter such that its value is 1 when the group footer is printed but 0 when not printed, then you can achieve the requirement with printwhen condition of the page footer.

Regards,
KKriplani

[Unable to Save Datasource]

Your first and formost step must be to analyze the jasperserver.log and if possible, share it here on the forum.
Also using which user are you logging into jasperserver and if you arent using superuser or jasperadmin, what is the user permissions?

Regards,
KKriplani

[Jasper 6 upgrade broke main menu]

Hi,
This is usually a case of postgres jar in the lib folder of tomcat. Replace the jar with the latest jar and make sure you remove the older version from the directory!

Also try to look for jar conflicts.

Regards,
KKriplani

[How can we consume single query in multiple tables]

Select the field and in the properties bar, add the "Print when Expression" with the required condition.
Basically, the fields will only print if the value of the parameter exceeds a certain value, in your case, 20.

[How can we consume single query in multiple tables]

Your example clarrifies your requirement. Ignore my previous answer.
What I finally understand is that you want to display first 20 records in table 1 and next 20 records in table two.

The easient way would be to have two separate datasets.

But even without that, what you can try is give all the fields of table 2, a print when condition like ;
$P{Id}>20.

In that case, all the fields of table two will only be printed as and when the ID is greater than 20.

Hope this helps,
KKriplani
 

[How can we consume single query in multiple tables]

using the same query, you can implement the above requirement using either Conditional Parameters or if the field definition remains the same in both table, just display only the required fields in the table 2. Hope you are aware of the fact that a table need not display all the fields from the query.

[How can we consume single query in multiple tables]

Hi,
Just create one dataset and use it twice in the tables displaying the relevant / required fields.

Regards,
KKriplani

[Getting error during login into jasper server?]

Jasperserver is trying to find the license on the path mentioned above.
Place the license on the above mentioned path and rerun jasperserver.

Regards,
Kkriplani 

[Dynamic value change for static label column header]

Please share that error and the expression that you used.

[Dynamic value change for static label column header]

Hi,
Try using ternary statement in the expression for that text field;

$V{test} == 1 ? "Heading 1" :$V{test} == 2 ? "Heading 2" : "Heading3"

Regards,
KKriplani

[Stop sending failure notifications to schedule owner]

Hi,
You will have to edit the scheduler that you have created. In the "Notifications" tab, uncheck the "Send Failure Notification".

Hope this helps,
KKriplani

[Is it possible to use MYSQL DB and mongodb in a single Jasper report??]

Hi,
I just came across the reason. Read below:

MongoDB is a big data architecture based on the NoSQL model that is neither relational nor SQL-based. Jaspersoft provides a
connector that allows reports to use MongoDB as a data source. Reports based on a MongoDB data source can be used as
Topics that allow users to create Ad Hoc views based on the fields returned by the MongoDB query. However, Domains
require relational data sources, and therefore MongoDB data sources cannot be used in Domains.

Regards,
KKriplani

[Is it possible to use MYSQL DB and mongodb in a single Jasper report??]

 

Hi,
Refer the screenshot for creating a Mongodb datasource.

Regards,
KKriplani

[Is it possible to use MYSQL DB and mongodb in a single Jasper report??]

Hi,
I guess it is not possible to use MYSQL DB and mongo db to be used individually in the same report.
However, you can implement Data Virtualization to do so which would use the two different DBs as one.

Regards,
KKriplani

[Installer to use MS SQL database?]

Hi,
You are looking to install jasperserver using Mysql metadata instead of Postgres?

Get the related installation here. download any ***-bin.zip
Let me know when we are on the same page.

Regards,
KKriplani

[How to set a row count manually?]

Hi,
Using a "Page break" would help. In the default expression, use a field like;

$V{REPORT_COUNT} == 10

Regards,
KKriplani

[Passing a hard coded list of values in jasper report's parameter]

For multi-select, create a collection type parameter.

[Preview don't need to enter parameters again.]

Hi,
regarding your prev question,
Click on the parameter in the report >> In the properties section, you will see a checkbox for "Is For Prompting". Uncheck that and add a default value for which the report always populates data.

Regards,
KKriplani

[How to Limit Number of records Per Page in Jasper Report 6.0]

Hi,
The use of page break and report count should help.
Apply a page break and give it a print when condition such that;

$V{REPORT_COUNT} > 50

Regards,
KKriplani