here is my question
I have a report that uses a query (query 2)
Query 2 is actually using another to build up (query 1)
In the report load event there are few sqls that populate data in text boxed mainly using (query 2)
How to run the report in away that make sure that query 1 also get filtered too
example: query 1 filter the date
query 2 filter the products purchased in this date.
i need the two queries in my report . How to do that
I have a report that uses a query (query 2)
Query 2 is actually using another to build up (query 1)
In the report load event there are few sqls that populate data in text boxed mainly using (query 2)
How to run the report in away that make sure that query 1 also get filtered too
example: query 1 filter the date
query 2 filter the products purchased in this date.
i need the two queries in my report . How to do that