question

helloworldfromed avatar image
0 Votes"
helloworldfromed asked Joyzhao-MSFT commented

(SQL Data Tools 2015) When creating a report, how can I merge few columns for rows that have same data? (Picture included)

Hello, below screenshots show how initial data are gathered, what i have so far, and what I intend to accomplish.

In second table ("What I updated to so far..." one), Initial Comments and Final Comments are merged and concatenated properly using Join and LookupSet combined. Also, Name, Date, ID, and Type are already added to Row Groups in SQL Data Tools.

However, for Columns Name, Date, and ID, i am attempting to merge them and only have one value present, and I'm having difficulty doing this.

Any help would be great.


31353-image.png


sql-server-reporting-servicessql-server-integration-services
image.png (183.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @EdwardKim-1648 ,
If the answer is helpful, please click "Accept Answer" and upvote it. Thank you for understanding.

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @EdwardKim-1648 ,
I conducted a test based on the data you provided, and my test results are as follows:
31476-test01.jpg
1.After creating the table, you could drag the initial comments and final comments into the table, and then select "intial comments" right click-Add Group-Row Group-Parent Group. Select "Type" in the "Group By" option,as shown below:
31448-02.jpg
31522-03.jpg

2.Select "Type" right click-Add Group-Parent Group, select "ID option.
31340-04.jpg

3.Select "ID" right click-Add Group-Parent Group, select "Date" option.
4.Select "Date" right click-Add Group-Parent Group, select "Name" option.

In the end you will get the same result as me.Hope this helps.
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



test01.jpg (38.7 KiB)
02.jpg (46.2 KiB)
03.jpg (13.8 KiB)
04.jpg (38.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

By the way: detail rows cannot be merged together.

1 Vote 1 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

By the way: detail rows cannot be merged together.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @EdwardKim-1648 ,
Has your issue been resolved?
If you have any question, please feel free to let me know.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.