Hello, there is something wrong with the new report. There are 12 records in the data which should be displayed in 12 pages normally, but only one page is displayed at present, Header table only shows the first row of recorded data, while all the data of Line table are displayed in the same report.
the design:
the report run result:
last page:
else pages:
The first impression is that the association between the Header table and the Line table is not established.
thanks & regards,
Are you using page break option in the report.
How about creating groups and displaying relevant records in each page. It should create single page for each unique record.
stackoverflow.com/.../in-ssrs-i-am-trying-to-create-a-ssrs-report-that-creates-a-new-page-per-row-of
How come headers data is displaying in lines section. I can see two datasets, so something not right in report design.
Thanks for your answer.
actual problem is: I want the report to be a Header data table showing one page for each record (plus the associated Line data table), but actually the Header has 12 records, the report only shows one page, the Header shows the first record, and the Line shows the corresponding record of the Header
Thanks & regards,
Hi, You can create group on a Field and control records visibility per page. Please check this article
www.techbrothersit.com/.../how-to-display-x-rows-per-page-in-ssrs.html
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156