D
Dan
I've got a summary report based on a sp in a SQL Server "Merchandising"
database. The sections are grouped as follows:
detail (hidden) followed by
"Store ID" footer (hidden) followed by
"Product ID" footer
I'm only interested in summary info for the Products - e.g. Product ID's
along with count of product ID's seen at each store, avg. price, etc., - I
get all of that, but because of the way I have to group the report to
summarize the product data I can't figure out how to get a count of the
unique stores visited. I can only get a count of stores that includes all the
records for each product and not just the unique Store ID's. In a MDB file I
can get this count by setting up a separate query grouped only by "Store" and
then use the DCount function against it - but how do I do it in the ADP?
database. The sections are grouped as follows:
detail (hidden) followed by
"Store ID" footer (hidden) followed by
"Product ID" footer
I'm only interested in summary info for the Products - e.g. Product ID's
along with count of product ID's seen at each store, avg. price, etc., - I
get all of that, but because of the way I have to group the report to
summarize the product data I can't figure out how to get a count of the
unique stores visited. I can only get a count of stores that includes all the
records for each product and not just the unique Store ID's. In a MDB file I
can get this count by setting up a separate query grouped only by "Store" and
then use the DCount function against it - but how do I do it in the ADP?