Hi all,
I have 2 queries query a is my pre-query and query b is my reporting query. Query A has a results set that shows possible expense entries that have been entered multiple times so I have 2 characteristics to show expense reports ER#1 and ER#2. I need to feed both of these values into query B. Is this possible? I built a replacement path variable and can successfully get the list from field ER#1 but I can't figure out how to get ER#2. I tried having 2 replacement variables on the 1 characteristic but the query didn't like that and gave me an exception report.
If this isn't possible is it possible for me to have 2 separate queries and append the results together. This is report is being displayed in a web template and I am using the 2004s tools.
Any help would be great!!
Thanks
Nicola