[How to create page footer only on first and second page]

Hi there -

There an out of the box variable for this -- see below --  you can modify this as needed.  Navigate to the Page Header properties (see Properties panel) and look for Print When Expression text field, which is under the Appearance button.   

$V{PAGE_NUMBER}.intValue()<2

This works on the Page Footer band as well.

Thanks.

 

[delete lines in a chart line in jasperreport]

Is this for Highcharts (HTML5)?  If yes, check here: https://api.highcharts.com/highcharts/.

[How to pass a value from main report to subreport?]

Hi there -

Look for the Subreport Parameters Map pop-up, which you can find by selecting your Subreport object and going to the Properties.  Click on the Subreport tab.  Next, look for and click the Edit Parameters button near the bottom.  You'll have to map the values to each other. 

Let us know.

[How avoid columnHeader repeat?]

Hi there -

Perhaps try adding $V{PAGE_NUMBER}.intValue()>1 to the Print When Expression on the Page Header band properties (see Appearance tab).  Change the operator to suit your needs.

Let us konw.  

[Can i create interactive html reports ?]

Yes, you can -- there are a number of ways.  Check on visualize.js, and you can also deploy JavaScript files to the server and access them from your Reports.  See this link from more on Visualize:  https://community.jaspersoft.com/project/visualizejs. 

[Jaspersoft Studio Edition]

There are differences around the types of elements that you get in the palette.  For example, you won't see the Pro charts in the community edition, among some other things.  For the most part, the two are similar.   

[Jasper Report Default Settings]

What version of JRS are you using?

[Free Community Edition Sample Dashboards]

The Pro and Enterprise editions of JRS ship with Samples. 
Not sure about Community. 

[Unable to See "View SQL Query" icon in the Adhoc view]

Hi there - You'll need superuser access so you can set the configuration under Server Settings > Ad Hoc Settings > Configure View Query.   

[displaying report from hierarchy tree]

This may help, http://community.jaspersoft.com/wiki/using-recursive-report-traverse-hierarchical-data-structure.

[Subreport chart writes over next subreport detail]

Hi there - Try adding another Detail band, this may help.

[why are dashboards not mentioned in jasperstudio 6.3]

As mentioned above, the Dashboard feature is in JasperReports Server.  You build reports in Studio, deploy them to JaperReports Server, and then incorporate your newly-built reports into a Dashboard.   

[SSO with LDAP JasperServer 6.3.]

The JRS Authentication Cookbook has a short section on SSO -- maybe this would be a good starting point.  There is no UI to work from when setting the configuration; instead, you are configuring property files. 

[Execute Stored with insert]

Out of the box, Jasper disables SQL prompts -- such as Drop.  I am not sure you can insert without making changes to the platform. 

[How to print TITLE band on first page]

The report's Print properties has an area where you can configure your Title page to be separate.  It is a checkbox; you just have to check it. 

[Execute Stored with insert]

If I understand this correctly, this configuration is not supported out of the box. 

[Jaspersoft Studio 6.4.0.final Very Slow Poor Performance]

Visit this site; it is very helpful when it comes to tuning your system. 

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

[Excel export (summary on first excelsheet)]

No, I don't believe this is possible.  The bands are fixed.  Put your objects in the Summary into the Title. 

[Is it mandatory to select atleast one value in multi select parameter while scheduling the report?]

Try the following in your WHERE clause,

WHERE $P{parameter} is null or department.department_id = $P{parameter}

 

[new font not available in the webserver glassfish]

Chapter 9 of the Studio User Guide has some information that may help; also, you could try creating a font jar. 

[custom datasource in the jasper report]

Some reference, http://community.jaspersoft.com/wiki/how-create-and-use-jrdatasource-adapter.   And for the server, there used to be samples here, c:jasperreports-serversamplescustomDataSourcesrcexamplecds.   

[Visualize.js Ad Hoc View Support]

They won't release this information until the release is out the door.

[Multiple time series lines from one data stream]

Maybe check this link, http://jasper-bi-suite.blogspot.com/2016/08/examples-of-all-html-5-graphs-in-tibco.html.

[javabean data source in jasperserver?]

Here's some reference, http://community.jaspersoft.com/wiki/how-create-and-use-jrdatasource-adapter. 

[Moving reports from Jasper Server to Local Project]

The exported catalog includes a structure of files and folders (with an output format of either zip or folder).  To recover your .jxml files, you'll have to find the report files that are represented as .data files.  The .data file is key and you'll have to reset the extension to .jrxml to open the file in Studio.