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

helloworldfromed 46 Reputation points
2020-10-09T22:16:51.44+00:00

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 Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,727 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,407 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2020-10-12T02:56:59.64+00:00

    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.


  2. Joyzhao-MSFT 15,561 Reputation points
    2020-10-12T06:30:38.283+00:00

    By the way: detail rows cannot be merged together.

    0 comments No comments

  3. Joyzhao-MSFT 15,561 Reputation points
    2020-10-15T09:39:57.53+00:00

    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.

    0 comments No comments