Hi guys. Sorry for the confusing explanation, but I'm a newb so here goes.
I have a crazy report that has one main table, then it has links (some outer joins) to 6 other tables, so it's a beast. I have it working semi ok with just the outer joins and links, but now have a quandary with one of the tables. This table is linked with a Left outer join to the main table. It isn't linked to any of the others. Apparently there are about 7 different user flags in this table that may or may not be selected. So I have to search that table for all the flags that may be there, and if it contains any of the ones they don't want, don't select that entire record. Is there a way to do this in the report selection criteria or do I need a subreport?
Thank you!
I have a crazy report that has one main table, then it has links (some outer joins) to 6 other tables, so it's a beast. I have it working semi ok with just the outer joins and links, but now have a quandary with one of the tables. This table is linked with a Left outer join to the main table. It isn't linked to any of the others. Apparently there are about 7 different user flags in this table that may or may not be selected. So I have to search that table for all the flags that may be there, and if it contains any of the ones they don't want, don't select that entire record. Is there a way to do this in the report selection criteria or do I need a subreport?
Thank you!