on 07-29-2009 5:14 PM
I am pulling information from a table where sometimes, some of the fields are blank.
Example:
Item # Size Color
123 L Red
124 M Blue
125 Null Null
When it pulls the report, item #125 doesn't show on the report. I am sure it is because of the Null fields. how can I get this info to come into the report?
Go to File -> Report Options -> Make sure the Convert Database Null Values to Default and Convert Other Null Values are both unchecked.
See if that works.
Regards,
Zack H.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Will this cover the subrepoorts too?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
do you have any record selection formula? if so add a record selection like this
isnull(Item Field)=true
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Either use ISNULL() for size and color or under File -> Report Options check the box next to "Convert Database NULL values to default'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
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.