Share via

(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,878 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 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,571 Reputation points
    2020-10-12T06:30:38.283+00:00

    By the way: detail rows cannot be merged together.

    0 comments
  3. Joyzhao-MSFT 15,571 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