[refer to a textbox like SSRS]

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

[refer to a textbox like SSRS]

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

[failed to connect hive in Jaspersoft studio community edition 6.4.0]

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.

[hive query with Explode Array in Derived table of creating domain]

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;

[hive query with Explode Array in Derived table of creating domain]

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

[how to convert decimal to string in a calculated field]

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

[how to convert decimal to string in a calculated field]

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.

 

[create domain/adhoc views from hive tables with Array]

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.

 

[how to get the max value of a text field in a group]

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

 

[sorting in a group]

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.

 

[how to get the max value of a text field in a group]

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.

[How to achieve Expand and Collapse on Row/Record/Group Level in Jasper Report?]

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

 

 

[how to set table row and column heights?]

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.

[fail to connect to SQL Server in Jaspersoft studio (6.3.1)]

I solved the problem by reading this post:

http://community.jaspersoft.com/questions/951061/sql-server-connection-integrated-authentication-jaspersoft-studio

[fail to connect to SQL Server in Jaspersoft studio (6.3.1)]

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.

[domain display: how to set the items within a set in Alphabetical order]

I am new to Jasper. I am creating a domain with ~ 1100 items from a single table (this table has 6000 Items). After all Items were moved to the domain, I found some Items are missing. For example, f_day was moved, but f_mon and f_year were missing. So I moved these 2 fields to the domain and now they  are sitting at the bottom in the display tab. I have to use the MOVE TO TOP button manually to move them after the f_day. Is there any way to order them alphabitical automatically? Is the order in the display important if I need to use the domain to create ad hoc view? I have lots of these kind of missing items.

Thank you very much!