Overriding Hide Dupplicates

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

I have a report with two grouping, Platform and Product. There is a footer
that only contains a line to seperate the detail lines when the control
changes. The deatil line contains both Platform and Product and both hide
duplicates.

The problem I am having is the Platform field repeats when the Product
changes. This is how it looks;
Platform Product Business
Web Site Banner Local
National
Web Site Hard Costs Local, National
WebSite Podcast Local
National
Web Site Video Local, National
Services Concert Local
National

What I need it to look like is;
Platform Product Business
Web Site Banner Local
National
Hard Costs Local, National
Podcast Local
National
Video Local, National
Services Concert Local
National

How do I override the repeating of the Platform when the only thing that
changed is the Product?
 
If I follow correctly, I think you need to remove the footer and place the
line in the detail like this --
Platform Product Business
 
I did not show the lines that I have in the footers, sorry. There are also
verticle line that complete the framing. Although I can not use the border
property because it does not get the desired look.

This is how it looks now with the lines
----------------------------------------------------------------
|Platform | Product | Business |
----------------------------------------------------------------
|Web Site | Banner | Local |
| -------------------------
| | National |
| -------------------------
|Web Site | Hard Costs | Local, National |
-----------------------------------------
|WebSite | Podcast | Local |
------------------------
| | National |
----------------------------------------
|Web Site | Video | Local, National |
---------------------------------------------------------------
|Services | Concert | Local |
------------------------
| | National |
---------------------------------------------------------------

And the is the desired look with the lines.

----------------------------------------------------------------
|Platform | Product | Business |
----------------------------------------------------------------
|Web Site | Banner | Local |
| -------------------------
| | National |
| -------------------------
|Web Site | Hard Costs | Local, National |
-----------------------------------------
|WebSite | Podcast | Local |
------------------------
| | National |
-----------------------------------------
|Web Site | Video | Local, National |
---------------------------------------------------------------
|Services | Concert | Local |
------------------------
| | National |
---------------------------------------------------------------

I think I need to control the value displayed for Platform when the Platform
is the same as the previous and only the Product changed. Most likely using
code. I just don't know the technique.

Any help with this approach or a better approach would be greatly appreciated.

Thanks, Barry
 
Back
Top