Hi,
I am new to the forum and would like some help with a specific query.
In query 1, I have a query of all the samples shipped by site, product code, customer, customer number and sales person.
In query 2, I have a list of all the sales by site, product code, customer, customer number and sales person.
What I want to be able to do is combine the queries to determine of all the samples shipped which have sales orders after the samples was shipped.
The data for samples and sales is from the same data source/package.
Solutions appreciated.
are sales and samples not joined in your package?
if not you can join your queries in reports studio just drag in join tool in query manager and put the two queries there. Join the queries using the items that will satisfy your requirement.