JS-newbie Posted September 27, 2018 Share Posted September 27, 2018 I published my JAsper soft Studio report to Jasper soft Server today. When I am trying to run the report it shows that the report is empty.What changes I need to make in Jasper Server to view the report? Please provide the steps needed to make it happen.Thanks in advance!! Link to comment Share on other sites More sharing options...
reportdev Posted September 27, 2018 Share Posted September 27, 2018 I would start looking at the Datasource. Datasources need to be specified while publishing the report. you might have missed it. Link to comment Share on other sites More sharing options...
hozawa Posted September 27, 2018 Share Posted September 27, 2018 Following pages contains information on datasource.https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v71/data-sources Link to comment Share on other sites More sharing options...
JS-newbie Posted September 28, 2018 Author Share Posted September 28, 2018 @reportdev: I have my data source query as - select * from Table name where District_Number= $P{DistrictNumber}IF I am using that as my query in Jasper Server for the Data source, it shows the "report is empty" and if I remove that I get the report results but the paramter selection is not applied on the result. What should I do?How should I connnect paramter to my report so that the results can be filtered?Thanks! Link to comment Share on other sites More sharing options...
narcism Posted September 28, 2018 Share Posted September 28, 2018 What is your report datasource configuration in Studio? Link to comment Share on other sites More sharing options...
JS-newbie Posted September 28, 2018 Author Share Posted September 28, 2018 @narcism: It is the same as it is in Jasper Server. Thanks! Link to comment Share on other sites More sharing options...
Solution reportdev Posted September 28, 2018 Solution Share Posted September 28, 2018 Check if your input control Values are correctly filtering the data.Examples : Parameter value may be 'YES ', but my report SQL is looking for 'YES'Parameter value may be 'TRUE', but my report SQL is looking for 'YES'Parameter Class is java.lang.String and you might have Configured the Server parameter as a java.util.ListThe last thing I would do is, place a text field with $P{parameter} on the report(without any filtering SQL) and see if parameter value appears on the jrxml 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