Having trouble with ADP report
From: Dan (Dan_at_discussions.microsoft.com)
Date: 01/10/05
- Next message: Natalia: "Re: Page footer with summary data"
- Previous message: Stephen Lebans: "Re: Drawing lines in reports"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 Jan 2005 08:17:07 -0800
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?
- Next message: Natalia: "Re: Page footer with summary data"
- Previous message: Stephen Lebans: "Re: Drawing lines in reports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
