Hello,
I don't know how to combine two separate queries into one formula so that my report will print records based on two separate criteria from two separate tables in my database. (Using CR 11)
1) Print employee records if table.flag = 1
Formula example: {table.flag} = 1
2) Print employee records if employee.state = MD or VA or DC
Formula example: {employee.state} in ["MD", "VA", "DC"]
If I run either query separately, the report works for that formula. But when I combine the queries, it's not reporting on all the records. I've tried AND and OR strategies, but nothing's working.
Thanks!
I don't know how to combine two separate queries into one formula so that my report will print records based on two separate criteria from two separate tables in my database. (Using CR 11)
1) Print employee records if table.flag = 1
Formula example: {table.flag} = 1
2) Print employee records if employee.state = MD or VA or DC
Formula example: {employee.state} in ["MD", "VA", "DC"]
If I run either query separately, the report works for that formula. But when I combine the queries, it's not reporting on all the records. I've tried AND and OR strategies, but nothing's working.
Thanks!