on 09-19-2016 10:25 AM
Hi All,
When I ran a query to generate the report ,report would be generated with null values in one column .
when can we get null values in web i report object ?
Are getting null values is because of any defect ?
Kindly let me know.
Thanks
Ram
You can get nulls in a variety of ways.
1/ The column itself contains NULL
2/ There is a case expression that evaluates to NULL for a given row
3/ There is an outer join that does not have values on "both sides" of the join, which would return NULL for the dataless side.
Those are the three most obvious things that I can think of.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
does the database holds values for that col?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.