When running this report. I can not get the OS column to show me the information for any server that does not have an R2 build.
It is using the following for this column....
RTrim(LTrim(tblOperatingsystem.Caption + ' ' + tblOperatingsystem.OtherTypeDescription))
When this line is put in, it puts blank lines for all servers that do not have information in the "tblOperatingsystem.OtherTypeDescription" table.
How can this be avoided so that I can see them all using only one column in the report?
Thank you,
- DRM