shauntae_mitchell Posted December 18, 2013 Share Posted December 18, 2013 I'm trying to create a crosstab in my ad hoc editor. The values in the crosstab that are NULL show up as a blank space. Is there any way that I can change this to show '0' instead? I've attached a picture Link to comment Share on other sites More sharing options...
H Mendoza Posted December 18, 2013 Share Posted December 18, 2013 Hi there - I am not sure if you can set that from the Ad Hoc editor. However, you could save the View as a report, and then open the file in iReport or Studio and make some changes, but that requires knowing how to use one of those two platforms. You can open reports from the server using iReport or Studio (via the repository plug-in).Regards, Hugo Link to comment Share on other sites More sharing options...
kcollins Posted December 18, 2013 Share Posted December 18, 2013 Hello,If you log in as superuser and go to "Manage" > "Server Settings" > "Ad Hoc Settings", there is a setting called "Display Null as Zero". This should display your nulls as zero.-Kris Link to comment Share on other sites More sharing options...
H Mendoza Posted December 18, 2013 Share Posted December 18, 2013 Is that feature in the newest release, 5.5? I don't see it in 5.0. Link to comment Share on other sites More sharing options...
kcollins Posted December 18, 2013 Share Posted December 18, 2013 Yes, I believe it was introduced in version 5.2. Link to comment Share on other sites More sharing options...
gowthamsenmca Posted December 19, 2013 Share Posted December 19, 2013 One caution here is that, this setting this option will change "Null" values as "0" for reports created using Adhoc views. For reports created using Jasper studio, the null values will appear as null. In order to handle nulls, we should put a condition as follows:<field Name>== null ? 0: <fieldname>HTHGowtham 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