singwei Posted December 30, 2015 Share Posted December 30, 2015 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. Link to comment Share on other sites More sharing options...
zh3ntil Posted December 30, 2015 Share Posted December 30, 2015 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. Link to comment Share on other sites More sharing options...
singwei Posted December 31, 2015 Author Share Posted December 31, 2015 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? Link to comment Share on other sites More sharing options...
socheat.student Posted December 31, 2015 Share Posted December 31, 2015 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? Link to comment Share on other sites More sharing options...
singwei Posted December 31, 2015 Author Share Posted December 31, 2015 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. Link to comment Share on other sites More sharing options...
socheat.student Posted December 31, 2015 Share Posted December 31, 2015 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. Link to comment Share on other sites More sharing options...
hozawa Posted December 31, 2015 Share Posted December 31, 2015 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 Link to comment Share on other sites More sharing options...
ramrajchoudhary890 Posted September 18, 2018 Share Posted September 18, 2018 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. Link to comment Share on other sites More sharing options...
stephanxeno Posted September 20, 2019 Share Posted September 20, 2019 Hi @hozawai have a same problem. I created same datasource in my server but that's not solving.any idea ? please Link to comment Share on other sites More sharing options...
singwei Posted December 12, 2019 Author Share Posted December 12, 2019 Hi, i already use the datasource in the repository, but the problem still there. Any idea? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now