HeelNGville
Registered User.
- Local time
- Today, 09:44
- Joined
- Apr 13, 2004
- Messages
- 71
Thanks in advance for any assistance.
I have a basic report that lists product records by date for each date/product occurrence. Example here:
Date-----------Product
1/1/11---------ABCD
1/1/11---------EFGH
1/1/11---------IJKL
1/2/11---------12345
1/3/11---------98765
1/3/11--------111111
What I am struggling with are dates with >1 entry. For records that exceed a count >1, I would like to list the date once, followed by the products that also map to the date and maintain the sort sequence. Example here:
Desire to have data appear as:
Date--------------Product
1/1/11-----------ABCD
EFGH
IJKL
1/2/11-----------12345
1/3/11-----------98765
11111
Do to other reporting parameters, setting a group on the ‘date’ field is not a option. Any guidance here?
I have a basic report that lists product records by date for each date/product occurrence. Example here:
Date-----------Product
1/1/11---------ABCD
1/1/11---------EFGH
1/1/11---------IJKL
1/2/11---------12345
1/3/11---------98765
1/3/11--------111111
What I am struggling with are dates with >1 entry. For records that exceed a count >1, I would like to list the date once, followed by the products that also map to the date and maintain the sort sequence. Example here:
Desire to have data appear as:
Date--------------Product
1/1/11-----------ABCD
EFGH
IJKL
1/2/11-----------12345
1/3/11-----------98765
11111
Do to other reporting parameters, setting a group on the ‘date’ field is not a option. Any guidance here?