I do not want to limit the report to showing just those cases where that particular comment_type is present. I just want to show the info related to it if it does but if that particular type does not exist I still want it to pull cases based on the opening date but list the type for that comment as a blank in the field. Here is the jist of how the report is formatted:
All cases opened between date A and date B, listing the staff assigned, their roles (which I also have a question about), a particular comment type, comment create date, create_userid, and the comment itself.
What is happening now is that the comment type is blocking any other cases from showing up on the report unless it already has that comment type populated in the db. Right now I just have the one particular code defaulted in the parameter and I know that isn't right because it does not allow for any null values. The problem is if I state to allow a null value, then I cannot select multiple values which it would be since it would be one type and one null. I'm thinking I would need to "Get values from a query" so that I could specify including the null?
Very frustrating! (Teaching myself SQL by the way, be gentle) Thank you 🙂