I'm executing a query and getting about 250 pages of data in my table but most of it (I guess my primary key "Contract") is the same value for many rows, Is there a way to group all my "contract" variable results into one row only? executed table
Asked
Active
Viewed 37 times
0
-
1Are you saying you want to have the `Contract` to only show once? Add a parent group for the `Contract` from the details group. – SS_DBA Jun 02 '17 at 17:19
-
Yes, I need to make 'Contract' just showing up once , adding as consequence the Actual cost, Name1, Name 2 , Project Mgr, and udGEACrev as one row, each on its column – Alex Alcala Jun 02 '17 at 17:21
-
it is possible to group all you contract results into one row. But what about the information like date and billing amount. They have to be aggregated in a function. Will it suffice if only one billing date is shown? – qwerty Jun 02 '17 at 17:36
-
Or do what WEI_DBA suggested. – qwerty Jun 02 '17 at 17:37
1 Answers
0
WEI_DBA is correct. Right click the table in Visual Studio and click "Add Parent Group", and select your "contract" column. It should group them together.
chazbot7
- 598
- 3
- 12
- 34
-
I am using SSRS for the table and query using a database on my server – Alex Alcala Jun 02 '17 at 17:43
-
-
My apologies, I've only used VS to create reports - this link should give you steps on how to do it: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-or-delete-a-group-in-a-data-region-report-builder-and-ssrs – chazbot7 Jun 02 '17 at 17:55
-