[js-import / js-export excluding datasources]

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v611/import-and-export-through-command

[two field in iReport]

Why don't you write all in one textfield?

CONCATENATE($F{first_last_names}," co process")

[i am facing unable to get next record error while executing my sql statement.]

Check the report query language in dataset and query window, If it is 'plsql' or not. If the language is "SQL", It can cause an error like that.

[How to pass array kind of structure (from report query) to SQL function?]

Hi,

As far as I know, there is no way to do that on studio . But, you can make it work by creating a StoredProcedure that parse your parameter string, convert to an array and pass to your function.

[Crosstab with static column]

As far as I know there is no way to do that on editor.Because it processes what is coming from your query as result.But you can achieve that by editing your query. you can add a cross join a table, which holds the month's names, in your query.

[column footer and summary]

Hi,

In outline window select your report, go to properties. under the "report" tab, check the "Float column footer".

[Sort on Month name in crosstab report]

you should add month number like '01-Jan'. So jasper will order as you want. Or, there is a field like MONTH_NUMBER in your query result, you can use month_number as sort field.

[Subreport producing multiple results]

If your main dataset result doesn't fill any field on main report, you can use a query like 'select 1 as field' just to be sure the dataset returns at least a row. Because if your dataset returns no result, your report shows no data section. So, If your main dataset returns a dummy result like that just a row, your detail section runs just one time.  

[Subreport producing multiple results]

Hi,

It seems your main dataset query generates three rows and you subreport is on detail band. Put subreport on summary band or change main dataset as generating one dummy record if it is not in use.

[Invalid Column Index Error on report]

it can be caused by oracle jdbc driver. Select the "tibcosoftware.jdbc.oracle.OracleDriver" for data adapter and test it. If it doesn't work, I agree with hozawa. Problem is in your query or parameters that in use on dataset

[Export report to file system]

Hi,

http://community.jaspersoft.com/questions/821487/output-host-file-system

[How can I remove the page title of a dashboard ?]

Hi,

Try ViewAsDashboardFrame=true

[HTML Chart Size]

Try to add the key below in advance options on the chart options.

plotOptions.pie.size

 

sfiddle example : http://jsfiddle.net/gh/get/jquery/1.7.2/highslide-software/highcharts.com/tree/master/samples/highcharts/plotoptions/pie-size/

 

jaspersoft use highcharts for HTML5 charts. You can find more advanced options if you checkout the highcharts api. 

 

[Cannot remove line when blank]

It collapses the band if the element if the element is not printing and no other element is occupying the same veritcal or horizontal space. In your case there are elements which are occupying the same vertical space.

You have to make subreport for each earnings' and deductions' sections to achieve that.

[SubReport with a Different Data Adapter]

Try this. It will solve your problem.

http://community.jaspersoft.com/questions/951636/subreport-close-connection

[Hide a column in jasper Report But should adjust with next column]

You shouldn't use table component on detail band in your case because jasperserver will print your table again and again for each row coming from result set. You can add it to summary band. In table, you can use print when expression for each column.

[Report with no record]

Did you choose a data source from repository when you publish the report to jasperserver?

http://community.jaspersoft.com/documentation/jasperreports-server-user-guide/defining-data-source

[Complex Excel formula]

Actually ı tried it first and see it is working. Are you sure output is null when add the before " chars?

"=HYPERLINK(CONCATENATE("http://somedomain.com/script/blahblah.blah?v1=MOD00&v2=_&first_gr=",$F{TRN},"&last_gr=",$F{TRN},"&time=",CONCATENATE(TEXT(HOUR(NOW()),"00"),TEXT(MINUTE(NOW()),"00"),TEXT(SECOND(NOW()),"00")),"&list=0,SNL,_,_,_,all,_,_,_,_,_,",$F{TRN},",_,_,_,_,_,P1&posRepMag=&posRepMin="),"TRACK")"[/code]

 

[Complex Excel formula]

add before " characters in string which you try to generate and preview the report to see if the output is OK.

[I don't want chart to be re-built automatically on columns/rows changing]

Select 'no data' and add the fields at row or columns. When you complete the design choose 'all data'. That's the only way as far as I know. 

[How to calculate the average and give the output in a textfield? (Jaspersoft Studio)]

It seems the problem caused by reset type of variable and evaluation time of the textfield which holds the variable.

check the reset type of variable. It shoud be 'report'. Evaluation type is 'Now' as default. It differs according the usage of textfield. For example if you use text field in a group header, you should change the evaluatin time should be 'Group'

[How can i show values with percentage symbol, as display labels in column chart(HTML5)?]

Try to add the keys below in advance options on the chart options.

plotOptions.series.dataLabels.enabled: true

plotOptions.series.dataLabels.format: "{y} %"

 

jsfiddle example : http://jsfiddle.net/gh/get/jquery/1.7.2/highslide-software/highcharts.com/tree/master/samples/highcharts/plotoptions/series-datalabels-format/

 

jaspersoft use highcharts for HTML5 charts. You can find more advanced options if you checkout the highcharts api. 

 

[How do I code the "Timestamp Range" parameter class into the query?]

Jasper Query:                                                                            SQL Query:

where $X{BETWEEN,column_name,param1,param2} -----> where column_name>param1 and column_name<param2

where $X{[bETWEEN,column_name,param1,param2} -----> where column_name>=param1 and column_name<param2

where $X{BETWEEN],column_name,param1,param2} -----> where column_name>param1 and column_name<=param2

where $X{[bETWEEN],column_name,param1,param2} -----> where column_name>=param1 and column_name<=param2

[How to create the the following:]

You can create this report and chart easily by using adhoc-designer on jasper report server. Add the fields at rows and columns, select crosstab, right click date field and select quarter under the group by section. But If you have to use studio, you can do this with crosstab component

[How to pass a parameter from text field hyperlink?]

You should add the parameters to textfield hyperlink parameters. For example assume that there is parameter named 'param1' in both report. So in textfield hyperlink section. You should add param1 and mapped $P{param1}. add the parameters where you defined the drill down report path with '_report' in textfield hyperlink