Hello,
my name is Ian and I have been working on cognac for roughly 3 months now. I am learning as I go so bare with me. I am creating a productivity tracker at work to track order selector mispicks and production numbers. I have 1 query that is made up of the user, item SKU, QTY and date of the mispick. Then my other query is user, QTY picked, minutes picking. I have 2 list boxes on page 1 of my report page.
My question is I have 2 queries that use separate date fields. How do I use 1 date prompt when I run the report filter both of these tables? I don't want to use 2 date prompts each time I run the report.
Again I am pretty new to cognos and even building queries so bare with me.
Hi Ian,
You can certainly use your prompt field in both queries. Something along the lines of
Query1: [Date of MisPick] = ?DatePrompt?
Query2: [TransactionDate] = ?DatePrompt?