[javax.net.debug.ssl - How to set property and look at log]

You can try to add it to JVM options. Depending on what application server you use, there is different way of specifying it. For example for tomcat it usually is set in setenv.sh/bat file or in service properties if you run tomcat as a service.

[report whit 2 pages]

Report will automatically paginate if your detail band + other bands go beyond the page size and your Ignore Pagination parameter is set to False. Some formats like HTML do not have pagination by default.

[Table header in each page for excel]

I guess you're using JasperServer to export reports. To change this behavior go to your WAR file location, for example for tomcat: /tomcat/webapps/WEB-INF/classes and edit the jasperreports.properties file. Find and switch this to false:

com.jaspersoft.jrs.export.xls.paginated=true

Save and restart the server.

[Replicating Existing Domains]

You can try downloading the existing domain XML schema and the creating a new domain from that schema. To download the schema edit the domain in the domain designer and press Export Design button. Save the schema.xml. Then create a new domain and instead of creating a new domain using the domain designer select the Upload option and point it to your schema.xml file.

[how to change data source for input controls automatically]

The input control and the report can have different data sources. If your input controls are internally defined you'll need to go through all the reports and change them manually. To avoid that in future it's a good practice to use external input controls and use profile attributes in the data source values so you can have exactly the same structure in the repository but have an option to define the data source connection details through the server or organizational or user level profile attributes. You can read more about that in JRS Admin Guide.

[Images won't load when my website invokes jasperserver to generate report]

If the images are part of the report itself (report content resources) you can just reference them by ID in your image expression like "test.jpg". If the image is a repository resource you can use "repo:/path/to/image" syntax to reference the image.

For REST v2 there is a parameter called attachmentsPrefix that you can try using. I am not sure it's present in 5.6.

For HTML output, this property specifies the URL path to use for downloading the attachment files (JavaScript and images). The full path of the default value is:

{contextPath}/rest_v2/reportExecutions/{reportExecutionId}/exports/{exportExecutionId}/attachments/

You can specify a different URL path using the placeholders {contextPath}, {reportExecutionId}, and {exportExecutionId}. The {contextPath} can be also manipulated through deploy.base.url property in js.config.properties file.

If you are to use REST v2 it's generally recommended to use 6.3/6.4 version as it has more ironed out and more feature complete REST web service.

[My variable is print null in the first line]

Maybe your text field is evaluated earlier than the variable is calculated. Try to change evaluation time from Now to Report for example and see what result that yields.

[Can anyone provide an example of how to create a crosstab with percentages?]

If you want to display both percentages and sum values then you'll need to create 2 measures. One will display the sum without percentage, the other will display sum value as percentage of grand total.

[Image condition is not getting evaluated after publishing the report]

It's an either/or scenario. The way I do it so that I can see image in both server and JSS is that when I add image I select the "Workspace item", pick an image from workspace and work from there. Then when I publish the report the publish option will ask me if I want to publish the images too and I can pick that. These images will be publish as report resources and they will be referenced by the server too.

[Gantt chart report]

The Gantt chart in Jaspersoft Studio is under Components Pro -> Widgets Pro -> drag it to the pane -> select Gantt Chart.

It is a fairly complex chart with a lot of datasets that can be used. I don't have any documentation at hand for it unfortunately. I'll see if I can find something.

[Is it possible that two parameters cannot be selected at same time?]

There is no functionality like this out of the box. You will have to create a custom input control JSP to introduce a feature like that. See JasperReports Ultimate Guide for more information on custom input control JSP's.

[Creating Variable into Japerreport]

Create a variable with No Calculation Function and expression $F{myField}. The variable will always have last value of the field.

[Can we create responsive reports?]

Responsive as in resizable so they can be properly viewed on any device? Yes, visualize.js can help you with that but bear in mind that visualize.js is a library/framework which provides you JavaScript wrappers for REST v2 calls. You can call reports on demand using visualize.js and embed reports into a web page like that.

[Using JSON Data Source and Template]

So you want something like pass a JSON data source for the report and that JSON data source will need to run SQL queries to obtain data for those values? That won't work unfortunately. You can either have an SQL query to a data source or have a JSON file as a data source. You can try to write a program that would execute these queries and form you a JSON file as a result which you can then feed to a JasperReport for data. Or create a custom data source object but that would also require additional coding.

[Subtracting date variables?]

Possible the equation 30* 24 * 60 * 60 * 1000 overflows because that value is way to big for an integer to store. Might want to try something like 30L * 24 * 60 * 60 * 1000 so it forces to a Long.

[Relative dates in jrxml controlling null values]

Hello,

i don't think you can use the SQL functions in the $X{} clause. It's $X{Function; Field_name; Parameter_name}. Field_name needs to be something identifyable for the compiler, it can't identify the functions. The $X{} clause is made to avoid the specifics of certain database engines about how they require different operations to be coded. Adding extra functions there removes the whole purpose of this.

[How to change datasource for imported Charts or Reports]

When you export the report, the data source gets exported with it. You can edit the datasource related to exported reports and change the connection details there.

[Gantt chart report]

JasperReports Server does not have tools to create a Gantt Chart report. You'll need to download the JasperSoft Studio Professional and use that instead. Charts Pro component in Jaspersoft Studio Professional has the Gantt Chart option. You'll need an active license to use that component tho.

[How to calculate multiple columns in one Hoc view?]

Hello,

one ad hoc view references one data source. If you need two or more data sources to be used by one domain -> ad hoc view then you can use Virtual Data Source feature and unite different data sources under one, create one domain, create calculated fields in that domain and then create a view based off that.

Alternatively you can create JRXML topics that use stored procedures and do all the complicated calculations inside a stored procedure instead.

[Image condition is not getting evaluated after publishing the report]

Do you still have the image expressions pointing to drive C and stuff? That's not a good idea especially when you publish on the server. I'd suggest you to publish an image on the server as a separate object and then reference it in the report using the following syntax in the expression: "repo:/path/to/image"

[Visualize.js access]

Visualize.js needs to point to a client, there is no extra configuration there. Underneath it's all just regular REST v2 wrapper calls. Might want to check the developer tools (console and network tab) for more information on what is going on on the client side.

[Jaspersoft Report deploy in asp.net web application on IIS server]

No, that is not possible. JasperReports is a Java library, IIS is .NET technology, the two do not intersect. IIS application can do web service calls to JasperReports server using REST v2 or Visualize.js to obtain reports but report generation will be done by Java regardless.

[How to change JasperReportserver from professional commercial edition to community edition]

Not possible to do that. JasperReports Server PRO and CE are technically two different applications. You'll have to install CE separately and transfer the repository.

[Is it possible to render reports dynamically from json data source?]

When you connect to a JSON file datasource you can do Read Fields and get field names automatically that way. If you want your reports to get field names automatically and then print them in the report automatically - that unfortunately is not possible without having something to generate a JRXML on the fly.

[Connecting HBase from JasperReport Server 6.3.0 or Jaspersoft Studio 6.3.1 on linux]

Jaspersoft Studio has an option to create an HBase data adapter (New data adapter -> HBase).

JasperReports Server doesn't offer HBase connector out of the box. Take a look at this article for more information about HBase + JasperServer:

http://community.jaspersoft.com/wiki/hadoop-hbase