admin管理员组

文章数量:1336148

I am using Crystal Reports 2016 and Cityworks 15.7.5 (not sure the Cityworks version is relevant)

What I am attempting to do is write a report that traps all of the Cityworks Service Requests initiated by scf, 311 that have never had a "To SCF:" comment.

I can get all comments containing "To SCF:" but I don't need to know when people are doing things correctly. I need to know when nobody has responded back to the citizen reporter in 311. I don't really even need to see the commenst just the service request numbers that have never had a "To SCF:" comment.

I am using Crystal Reports 2016 and Cityworks 15.7.5 (not sure the Cityworks version is relevant)

What I am attempting to do is write a report that traps all of the Cityworks Service Requests initiated by scf, 311 that have never had a "To SCF:" comment.

I can get all comments containing "To SCF:" but I don't need to know when people are doing things correctly. I need to know when nobody has responded back to the citizen reporter in 311. I don't really even need to see the commenst just the service request numbers that have never had a "To SCF:" comment.

  • crystal-reports
Share Improve this question asked Nov 20, 2024 at 16:21 Leah HughesLeah Hughes 31 bronze badge
Add a comment  | 

1 Answer 1

Reset to default 0

If the "To_SCFcomment" column is in a table that is already in the report, you can simply add

IsNull({TableName.To_SCFcomment})

as a record selection formula.

Otherwise, add the table to the report. If no comment means no record in a related table, use Outer Join.

本文标签： Crystal Report for Cityworks CommentsStack Overflow

版权声明：本文标题：Crystal Report for Cityworks: Comments - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742345408a2457421.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。