Jump to content
We've recently updated our Privacy Statement, available here ×

Report is empty in Jasper soft Server


JS-newbie
Go to solution Solved by reportdev,

Recommended Posts

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

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

@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

  • Solution

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.List

The 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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...