Showing Null

[blushingrose]

I have a report that I need to create that shows an empty space. For instance I have a room that has two spaces, but only one space is assigned. In the report I need it to show both spaces, one with the name that is assigned to it and then the empty space. Anyone know how to do that?

 

[lbass]

If the room number comes from a separate table from the assignment, then use a left join FROM the table containing the room number TO the table containing the assignment. Then you should be able to place the room field and the assignment field on your report to get the desired results.

If this doesn't work, you need to provide information about the tables and fields used. You should also always specify your CR version.

-LB

 

[Madawc]

If you are wanting to show something for a null field, the classic answer is if isnull({your.field}) then "No value" else {your.field}. Fo a numeric, you'd need to say ToText({your.field}) or else use 0 for null, since you cannot mix string and numeric as alternatives for the same formula field.

If that's not it, please explain more.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10