Report Builder - Grouping Data Elements
I have run into an issue with the way Report Builder groups the data elements that are placed in the report. The example below explains it.
The following data is located in my database:
InvoiceNumberBillDateUsageItemValue
456456456 9/5/2006 102.7 131.97
456456456 9/5/2006 10.3 13.24
456456456 9/5/2006 10.3 5.95
777888999 8/3/2006 112.6 241.12
If I place "InvoiceNumber" or, "InvoiceNumber" and "BillDate", into Report Builder, I only get two rows returned - <456456456 9/5/2006>, <777888999 8/3/2006>.
If I place "InvoiceNumber", "BillDate", and "Usage" into Report Builder, I get three rows returned - <456456456 9/5/2006 102.7>, <456456456 9/5/2006 10.3>, <777888999 8/3/2006 112.6>.
Not until all four attributes are placed into Report Builder do all rows get displayed.
I see that this is occurring because of the way the data is being grouped. Is there a way to turn this grouping off?
My concern is that users will not see that there are 4 entries in the "InvoiceNumber" field unless they add all four attributes to the report.
