Jane.Yu

I figured it out how to print only in Group B. in the Appearance Property: remove "Print repeated values" and set group changes: B in the Print When

We have a SSRS report to be converted into Jasper. The group hierarchy is like this: A group (Parent) B group (child) (page break in between) Details. In Group B, there is a textbox named Investors. in page header, there is another textboxB referring the Investors textbox. So, in the report output, the textboxB is not printing when that page only has Group A data. Example: Page 1: TextBoxB: A04 Group B data Page2: TextBoxB: (it is blank) GroupA data How can I get the same output in jasper? Thank you very much. Jane

I tried to create a data adapter to connect hive, but could not find tibcosoftware.jdbc.hive.HiveDriver in the JDBC driver list. It is supposed to be installed by default. The only one that can be found is org.apache.hadoop.hive.jdbc.HiveDriver. But this doesn't work. Please help. Thank you.

how to set this property in Jasper report server? I tried to add it before the select query in the derived table, and it did not work. set hive.vectorized.execution.enabled=false;

I need to create a domain from a hive table. This table has an array. The following query works well in ambari, but it failed in the derived table tab of domain creation. select col1, analysis_d1.column1 from HiveTable LATERAL VIEW explode(analysis_data) adTable AS analysis_d1 Here analysis_data is an array from HiveTable. The error message is listed below, please help. Thank you. Cannot execute JDBC Query.[Tibcosoftware][Hive JDBC Driver][Hive]Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1496095817591_0903_1_00, diagnostics=[Vertex vertex_1496095817591_0903_1_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: masterfile initializer failed, vertex=vertex_1496095817591_0903_1_00 [Map 1], java.lang.RuntimeException: serious problem

Thank you, Dprogrammer. It looks like contain function can be used to string datatype. My field is BigDecimal datatype.

There is a field (decimal datatype from hive) with value like: 101110110 (only 0 and 1 in every digit). 1. I would like to create calculated fields in ad hoc views and extract every position from this value 1,0,1,1,1,0,1,1,0 2. I would like to get the count of '1' from this hive field, so the count is 6 for this example. I tried to use java function String.valueof(), replace() in the calculated field, and it failed the validation. There are no function to convert decimal to string or replace strings in Jasper report server for adhoc view calculated fields. We can't change the datatype to string in hive. How can I create these calculated fields? Please help. Thank you.

There is a table in hive. It has array like this: tax_idx array<struct<TAX_SEQ_NO:string,TAX_CODE:string,TAX_ID_NO:string>> I need to create a domain in Jasper report server and extract TAX_SEQ_NO field. But the following query doesn't work when creating derived table. Select field1, analysis_d1.TAX_SEQ_NO, analysis_d1.TAX_CODE from hiveTable LATERAL VIEW explode(tax_idx) adTable AS analysis_d1; Please help. Thank you.

NO, I am not trying to get the character length, only the max value. For example, in the group AdressName='Chicago', the AdressBlockLine can have values like below, the expected value is'Deerfield road' NULL Deerfield road Deerfield RD

I use Jaspersoft Studio 6.3.0 professional. Is there any way to sort within a group? Seems the only way to do the sorting is in the Dataset and query editor. Thank you.

I use Japsersoft Studio 6.3.0 Professional. There is a report with a group as AdressName. In this group, I would like to get the max value of a text field named as AdressBlockLine. The max function only works on numeric field. How can I get the MAX value of this text field inside a group? Thank you.

I use commercial version (Jaspersoft studio 6.3.0) and it doesn't have this feature when preview. When export to excel, you can follow the link below to acheve this feature. http://jasper-bi-suite.blogspot.com/2016/03/tip-excel-export-expand-and-collapse.html

If you leave Table header and column footer in the table, you can adjust the the height of a whole row of table detail or column header.

I solved the problem by reading this post: http://community.jaspersoft.com/questions/951061/sql-server-connection-integrated-authentication-jaspersoft-studio

My computer has windows 10 operation system and Jaspersoft studio (6.3.1). It has JDK 1.8.0_101 and Microsoft JDBC Driver 4.2 for SQL Server installed. I have added sqljdbc42.jar to the driver Classpath. When I tried to create a data apater for SQL server with JDBC driver , it failed with error message: This driver is not configured for integrated autherntication. The Configuration for the data adapter: JDBC Driver: MS SQL Server 2005-2012 com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC Url: jdbc:sqlserver://hpdevsql21:1433;databaseName=Test;IntegratedSecurity=True; I checked the property of the SQL server, it has SQL Server and Windows Authentication mode, the Configuration manager shows TCP/IP is enabled and default port is 1433. Please help, thank you.