How do I do this in SSRS but in Crystal it works

PhillipK 121 Reputation points
2022-03-01T17:43:45.88+00:00

How do I create this type of report in SSRS Report builder? In the attached picture it is a Crystal Rpt. I add a Matrix but the data keeps defaulting to Columns
178956-capture.jpg

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,822 questions
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-03-02T01:39:16.82+00:00

    Hi @PhillipK ,
    You might consider using List. In the page linked above, you could also see the difference between Table, Matrix and List at the same time.

    See more: Create invoices and forms with lists in a paginated report (Report Builder).
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 41,011 Reputation points
    2022-03-02T07:04:25.863+00:00

    How do I create this type of report in SSRS Report builder?

    Just by the blurred screenshot I don't get what for a kind of report you mean and what you are trying to achieve.
    May can you explain it more detailed and give us a real example, please?

    0 comments No comments