[Moved Names Space]

In order to help you I need to know more details on how you are using the components and how the reports are being generated..

If this is associated with a commercial subscription, I recommend you contact Jaspersoft Production Support.

[Jaspersoft Studio Span Group Header to full width]

Highlight all the columns in the group header and right click / "Group Columns". This will create a grouped header section.  You can then put the "Group Header" text element on the grouped section, and remove the cells for the individual columns.

[jasper enterprise edition 8.2.0 source code folder ce/jrs-ui or pro/jrs-ui-pro]

All commercial editions (Reporting, Professional, Enterprise) share the same code base, which is found at  pro/jrs-ui-pro folder.

[Query epoch date in SQL Server does not work from Jaspersoft Server]

I would use the java.util.Date.getTime() method to get the epoch, and compare the epoch field using that parameter.

Create a second parameter (name it OpenDateFromEpoch) that performs that translation, and use the second parameter in the query.

Something like :

and cr.open_date  >= $P{OpenDateFromEpoch}' 

[Convert epoch time in input to human readable date]

Epoch for "2012-08-01" is 1343800800000 (for the start of the day)

[Problems trying to pass from Epoch to Date]

java.util.Date class has a "getTime()" function that returns the epoch.

 

[I need to create the Adhoc view in jasper Community Edition]

Ad hoc designer is a commercial only feature.

[Cannot get a qrcode barcode to display any image other than the default]

This works fine for me.

1. Create parameter.

2. Add the QR Code to the report

3.Set the "Code Expression"

4. Preview the report.

5. Use camera / other means to read the QR code.

QR Code reflects the value from the parameter.

To further assist on this, you need to provide jrxml  

[Set Date Picker to Sunday instead of Monday (v8.0.0)]

A few clarifications:

- where is the date picker you are looking at?

- The default selected date is usually the current date, or the default date set in the parameter properties in Studio.

- Are you wanting to make the first day of the week be set to Sunday rather than Monday?

[Password protect PDF using reportExecutions API ?]

You can set the following property on the document to set the password:

net.sf.jasperreports.export.pdf.user.password (documentation: https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.pdf.user.password 

 

[Dropdown list in Excel report]

There are a subset of Excel properties supported by Jaspersoft's Excel exporter. This does not include the properties associated with data validation.

A list of those properties is found here: https://jasperreports.sourceforge.net/config.reference.html

You may be able to  create a custom exporter that will implement these properties. You would need to write java code to implement this custom java class. Unbderstand this is a complex extension of Jaspersoft. The links below may be helpful.

The Excel properties around data validation are discussed here: https://docs.devexpress.com/OfficeFileAPI/DevExpress.Spreadsheet.DataValidation

JasperReports JAVA API is  here:  https://jasperreports.sourceforge.net/api/index.html

[Clearing the cache]

Subreports by default point to the compiled version (*.jasper). Compiling / building the subreport should bring your changes into the master.

You can also point the Subreport Expression to the "*.jrxml" file, which should trigger the build of the subreport along with the master report. 

[how to stretch table column when any column of the table value null other columns occupy that hide column size?]

Try using different Layouts in your design. (Vertical Layout, Grid Layout, Spreadsheet Layout).  For details on each check out https://community.jaspersoft.com/wiki/tibco-jaspersoft-studio-layouts

[Text formatting problem in HTML]

What html is in the variable? The html in the variable needs to be properly formatted.

[Documents scaling differently from settings]

Is there any additional issue here? Typically you export to a specific format to print the report.

[Text formatting problem in HTML]

What is in the variable - what is the html you are injecting?

[Gnatt chart]

Check to see that the chart is placed on either the Title band or the Summary band. If the chart is on the "Detail" band, a chart will be generated for each row that is returned from the main "Dataset and Query". 

[Gnatt chart]

If you could attach your jrxml it might be helpful.

[can't connect to Oracle DB from Jasperserver]

The database connection apparently is accessing a channel in the incorrect blocking mode.

I would get with your Oracle DB administrator to ensure you have a correct connection string.

[Example using DOM element as container]

This is a known issue targeted for future release.

[xml source with namespace]

I notice 2 things

- in the namespace version of the xml you have not defined the namespaces.

- In  Studio when defining the xml adapter, is the "Enable namespaces support" checkbox marked? 

[xml source with namespace]

A jrxml sample would help understand this issue.

 

[How to use 2 datasources from 2 differents from Oracle database in Jasper server]

Your approach is fairly sound, although you might try checking the report in as an organization based user, which will change the path (removing the organization specific portion of the path.) With the org infor present it may make it so that the report doesn't work for a non-root user.

From a general strategy pint of view, here is some details on how to use multiple data sources in a report:

==============================

A report in JRS is actually a Report Unit, and a ReportUnit is not designed to use multiple data sources (JasperReports data sources). So if your data does not come from the same database (with which you may still pass the REPORT_CONNECTION to your subdataset) or is using the same JSON (for which you could derive a sub dataset), your best option is using data adapters. Any DatasetRun in JasperReports can run against a data adapter specified as a property.

You can create a ReportUnit referencing a (JRS) datasource, i.e. FoodMart. This is not mandatory.

Then, we assume that the chart gets its data from some JSON and the subreport uses an SQL query from a different database.

A Data Adapter in JRS is an xml resource that is uploaded either manually, or by using JSS.

The “binding” between a DatasetRun (which is the part of the report that defines how a subdataset gets its data), and the data adapter is configured in Jaspersoft Studio.

For a subreport, the main dataset will set the property net.sf.jasperreports.data.adapter

For Charts, Tables etc, it is always about using this property (Studio provides also the UI to specify the data adapter)

Be sure you point to a proper data adapter, which is a resource, inside your repository, just like you would do when you reference an image.

Studio will help you also loading these data adapters when the report is published to JRS.

===============

[AdHocView: how to change grouping on date dimension using VisualizeJs]

This would be possible - however, it may involve putting the adhoc view in a dashboard, so that the click event could be captured. Although setting the summarization level by parameter is not poossible - you may need to define separate ad hoc view for each level.

[AdHocView: how to change grouping on date dimension using VisualizeJs]

This capability is a design consideration. API access to this type of designer feature is not yet a part of visualize.js.  I would suggest submitting an enhancement request through your customer success manager if you are a commercial customer with Customer Success.