gpdeering
Posts: 57
|
| Posted: 02/06/2007, 8:04 AM |
|
I'm using .NET 2.0 and an MS Access 2003 table. (I'm current with CCS.)
I have a report page (generated from the Report Builder) that contains groupings with their stats for each column (actually, just the count).
I would like the Count to reflect whether there are duplicates in a given column. There is a "Hide Duplicates" property for each Count ReportLabel, but setting it to "Yes" does not affect the reported count. Perhaps this property doesn't apply to .NET apps.
Essentially, Count simply counts the number of records in each grouping and displays that number.
What I am trying to achieve is this:
Column A || Column B || Column C
============================
Grouping 1 Item 1 SubItem 1
Grouping 1 Item 1 SubItem 2
Grouping 1 Item 2 SubItem 3
--------------------------------------------------
Count: 1 Count: 2 Count: 3
What I get is this:
Column A || Column B || Column C
============================
Grouping 1 Item 1 SubItem 1
Grouping 1 Item 1 SubItem 2
Grouping 1 Item 2 SubItem 3
--------------------------------------------------
Count: 3 Count: 3 Count: 3
Perhaps I need to add some custom code. Any ideas?
Thanks,
Glen
|
 |
 |
dragoon
Posts: 173
|
| Posted: 02/07/2007, 12:21 AM |
|
you should add some custom code; the Count Report Label just counts the number of the rows, no matter grouping you have there.
|
|
|
|
Austen
|
| Posted: 03/28/2007, 8:31 PM |
|
http://6a0d39cae1f24ae0ee2a22c698342ada-t.yj5t4hd.info <a href="http://6a0d39cae1f24ae0ee2a22c698342ada-h.yj5t4hd.info">6a0d39cae1f24ae0ee2a22c698342ada</a> [url]http://6a0d39cae1f24ae0ee2a22c698342ada-b1.yj5t4hd.info[/url] [url=http://6a0d39cae1f24ae0ee2a22c698342ada-b2.yj5t4hd.info]6a0d39cae1f24ae0ee2a22c698342ada[/url] http://6a0d39cae1f24ae0ee2a22c698342ada-b3.yj5t4hd.info ebb85e520deadfe8ff7080af84ede8f8
|
|
|
|
|
