Current Query - See Attached - Using the 'Where' statement I created a query parameter which will filter on Report parameter item, 1-6. When I run the query it prompts for input and runs the query fine.
Desired Query - I need to maintain the 1-6 separate Report filters and Instead of using the Where for a parameter I need my output to provide all six filters at once with their individual outputs:
Count Inv_ AS inv # 1 (Filter 1)
Count Inv_ AS inv # 2 (Filter 2)
Count Inv_ AS inv # 3 (Filter 3)
Let me know if I can provide any additional clarity.