Unable to show headers on each and every record

PhillipO 1 Reputation point
2022-08-30T14:30:39.857+00:00

236179-image.png

236147-image.png

236119-image.png

MSFT Report Builder

When run it does not show like the one in blue circle (Crystal report). I tried many settings, but it still is unable to show the one in the top Circle ones. Any suggestions?

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,235 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 27,211 Reputation points
    2022-08-30T14:36:22.277+00:00

    You place "Category Number" in tablix header and "Date" in column header; both are only show once.
    Add further detail lines and move then to there.
    Right-mouse click on the detail row (right) => Add row => Within group above/below

  2. Joyzhao-MSFT 15,381 Reputation points Microsoft Employee
    2022-08-31T07:32:44.983+00:00

    Hi @PhillipO ,
    Do you want to repeat Category Number, Project Number? As I understand if you use List it will repeat every time like the screenshot you provided.
    There is also a way to refer to the subreports. The Table containing "Date" appears in each Project Number by passing parameters.
    see more: SSRS Subreports Example.
    Please feel free to correct me if I misunderstood what you mean.
    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.