zh3ntil
-
Posts
122 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by zh3ntil
-
http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v611/import-and-export-through-command
-
Why don't you write all in one textfield? CONCATENATE($F{first_last_names}," co process")
-
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?
zh3ntil replied to jigar.patel's topic in Products
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. -
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.
-
Hi, In outline window select your report, go to properties. under the "report" tab, check the "Float column footer".
-
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.
-
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.
-
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.
-
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
-
Hi, http://community.jaspersoft.com/questions/821487/output-host-file-system
-
Hi, Try ViewAsDashboardFrame=true
-
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.
-
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.
-
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
zh3ntil replied to mohammed.sardar's topic in Products
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. -
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
-
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]
-
add before " characters in string which you try to generate and preview the report to see if the output is OK.
-
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.
-
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'
-
Try to add the keys below in advance options on the chart options. plotOptions.series.dataLabels.enabled: trueplotOptions.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.
-
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
-
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
-
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
