JasperServer shows null value for some fields

[singwei]

Hi, I created a report which is run successfully in Jaspersoft Studio. In this report every fields that I want had been printed out but when run on Jasper Server, many fields shows null. I had created the same query as Jaspersoft Studio at jasper Server, which mean, it should be getting the same result as what I printed at Jasper Server and JasperSoft Studio.

Anyone knows what the reason cause it and had any solution on this?

Thanks.

[zh3ntil]

It seems studio data adaper and jasperserver datasource has different connection properties. Check the jasperserver datasource in use for report if it is correct or not.

[singwei]

Hi, @zh3ntil. 

When I publish to jasperServer, I had choose Local Data Source among the 3 option at Configure the data source. Am I choosing the wrong option when publish?

By the way, the data of my reports shows are not completely null, but null for certain fields only. This problem won happen if run using JasperSoft Studio.  Is it because of dataSource problem that you mentioned?

 

 

[socheat.student]

sorry, I have a question. do you have a problem with local environment and server environment?. it meant that you got the result on server and local it differrent, right?

[singwei]

Hi, @socheat.student.

Yes. When print at local environment all results will be print out. But when printed at server environment, some value showing null.

[socheat.student]

try to add microsoft font to server environment. it maybe font missing. try to test it becaue I got this problem too, but now I solved it by install microsft or some font to server environment.

[hozawa]

This isn't a font problem but with the datasource. Instead of using the local datasource, use a datasource in the repository. To do this, you'll need to create a datasource from JasperReports Server. See the following page for steps on how to do this. Create a datasource in the repository and test it. Upload your report and just select this datasource.

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/jdbc-data-sources

[ramrajchoudhary890]

HI All,

I have designed report in jasperstudio, but while publishing data on jaspersever all reocrds are coming null. I am fetching data from HIVE2.

Please suggest.

[stephanxeno]

Hi @hozawa

i have a same problem. I created same datasource in my server but that's not solving.
any idea ? please

[singwei]

Hi,  i already use the datasource in the repository, but the problem still there. Any idea?