I am using CR 8.5, ODBC and SQL Server. I added a memo field inside a Group to an existing report. The problem is that if the memo filed is empty for that particular record, nothing for that record appears in the report. It is entirely skipped. There is supposed to be an option in Format Editor to uncheck Suppress Blank fields, but it's not available for a Memo Field. If I haven't given enough information, please let me know. Thanks...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Empty Memo fields 1
- Thread starter SLarimore
- Start date
-
1
- #2
Is the memo field from a different table? If so, you need to use a left join from your original table to the table containing the memo field. Otherwise, you might try replacing the memo field with a formula:
if isnull({table.field}) then " " else {table.field}
-LB
if isnull({table.field}) then " " else {table.field}
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question