tong123123

In jasperstudio 6.9 I want to export my report to pdf, but error "java.io.UnsupportedEncodingException: UniCNS-UCS2-V" shown, what should I do? I google and seems it is missing iTextAsia.jar, but even I download itext-asian-5.2.0.jar, what to do next? how to let jaspersoft studio use this jar?

I try to change the Page Format width, height property in jasper studio 6.10, but then I cannot find the changed value (e.g. 210, 300 here) in jrxml, so where is the width, height of page format properties saved in jrxml? For more information, if I change the Page Width properties in advanced tab, I can find the corresponding changed value in jrxml pageWidth attribute.

I try to view the JasperReports Library Utimate Guide pdf online or donwload the pdf from the link below, but using both method, the pdf contents cannot be search by text, why? https://community.jaspersoft.com/documentation/jasperreports-library-ultimate-guide and I try to copy some text from the pdf to notepad, the text cannot be shown correctly, why?

I have checked the data adapter is connected to the same db as SSMS, but when I run the same stored procedure from SSMS and jasper studio query dialog, the result is very different, many columns is not shown in jasper studio query dialog data preview tab, why? the select statement in the stored procedure is come from dynamic sql, then using exec(). seems it is a bug of jasper studio 6.10? if I replace the sql in stored procedure, extract the runtime generated @sql and paste the string back to the stored procedure, then jasper studio can read all fields. But the @sql is dynamic built, so it need to use exec(@sql)...Any method to work around this jasper studio read field problem?

in the figure, the right hand side is the query result, I want to show it in crosstab with sex as row and fyear as column, but the 2018 has no record and sex is NULL. how to hide the null row in crosstab (but need to keep the 2018 fyear column)?how to set the total sex so it can sum up the column value in crosstab?

there are many crosstabs inside summary band, when one crosstab content is overflow, it will overlap the content of crosstab under it, as in the figure red highlighted. The Rank crosstab overlap with the Year of Service crosstab. Any method to make the crosstab shift download if the upper crosstab content overflow?each crosstab is inside a frame, how to make the frame (and its border) expands when its enclosing crosstab overflow?

My origin excel chart is created by marco as Dim ch As ChartObjectSet ch = ActiveSheet.ChartObjects.Add(5, 50, 520, 280) and the output is like the following diagram (chart 1) I try to use jasperserver to simulate the same output (their data is different, but I want the chart size can like the chart1), but the result is that the chart is just on A5 cell and it's next cell is already U5 cell, like the following (chart 2): 1) Any method to let jasperserver exported my chart on a specific area in a worksheet (like chart 1, ActiveSheet.ChartObjects.Add(5, 50, 520, 280))? 2) I find in excel chart object, the vertical axis max and min value is auto generated, any method to let jasperserver use the same logic as in the origin excel chart? 3) in chart1 using marco, the image is on top of several row (4-20), but if using jasperserver to export the chart (chart2), the chart is on top of one row and that row is enlarged (row5). How to make the chart2 like chart1, on top of several rows instead of one row?

in jasper studio, when deploy main report with subreport, subreport "overwrite" column can choose "overwrite","ignore" and "overwrite only expression" what is the diffrent between "overwrite" and "overwrite only expression" for subreport? when to use each?

for import report to jasperserver, is the --update option in Import the myDir catalog folder, replacing existing resources if their URIs and types match those found in the catalog:js-import --input-dir myDir --update is equivalence to in my jasperstudio, choose "overwrite"?

Hi C-Box The sql is placed in main report <queryString>, and the three subreport is placed in main report three different group header, each with expression $P{REPORT_CONTEXT} In fact the report is not written by me but I need to maintain this report, what is group header with expression $P{REPORT_CONTEXT} means? Mostly I see group heder expression is a field like $F{FIELD_A}, this means the group header will reprint when value of $F{FIELD_A} change. But what happen when group header expression is $P{REPORT_CONTEXT}? it means that group header will just run once for the whole report? 2) Why do you actually use SubReports for the same datasource? Yes, in fact I think can just copy the content of subreport to the main report corresponding subreport component group header, just set the group header to the size of subreport, right?

I have a main report and three subreport which use the same sql, that sql is quite time consuming, so for the same sql it runs total four times ( one main + 3 subreport), I want to speed up the processing time by passing the main report dataset result to these three subreport, without using any java code. As I see some post mention to pass the dataset from java to main report parameter, then to subreport parameter, but this is not a option for me, my application is .net based.

I found the property name="ireport.jasperserver.report.resource" always automatically added/delete during publish/preview in jasperstudio, what is this property for? it is quite annoying that the file always show '*' (unsaved change) but in fact nothing is just beside this property.

I try to use expression in a text field, and the language is set to groovy, what I input is a very simple if else statement if ($P{P_TFE_TYPE} == null || $P{P_TFE_TYPE} == ""){ "abc"}else{ "def"}.[/code]but this already throw exception as what is the problem? I see a red underline under the opening {, and the tool tip is if I use expression like ($P{P_TFE_TYPE} == null || $P{P_TFE_TYPE} == "")?"abc":"def"[/code]it can compile, everything run as expected. I know I can use ?: operator but don't want to as my if..else if condition is quite lengthy and complicated in reality, and feel hard to see if use tenary operator ?:

in group header band, I already check "Reprint header on each page", but if the group extend more than one page, the group header still cannot reprint on next page except the first page. But this problem is not found if use "preview" tab in JasperSoft Studio 6.5.1, just after deploy the same report to TIBCO JasperReports Server ® Community Project 6.3.0 Release, this problem is found. I don't know if this is bug in jasper server 6.3.0, but we cannot upgrade the jasper server, so if it is, any workaround for this problem?

how imported the zip into jasperReport Server?