SQL Server ReportBuilder/SSRS - How to make a report with multiple tables, same dataset and just display data from each row and repeat headers?

t5zmwmid 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(89)

Probably I am not defining correctly my problem, but a customer asked for a report that uses only 1 data set and wants three tables, one of 9 columns, the second with 6 rows and a third table with a simple row.

Now each table needs to be display one row at a time and then repeat headers with the subsequent data, all matching like I was using a single row Tablix.

Basically, I have been playing the Grouping, Page Breaks options, List and Rectangle and haven't got the results.

sql-server

来源：https://stackoverflow.com/questions/76690589/reportbuilder-ssrs-how-to-make-a-report-with-multiple-tables-same-dataset-and

1条答案

按热度按时间

4xy9mtcn1#

add tablix control
configure with dataset
define structure of the first table and set the visibility of rows and columsn based on your data
right click on row header of the first table and select row group --> group properties. set the grouping expression to a field that identifies each row uniquely
repeat 3-4 for second and third tables
repeaet the headers for each row - right click on row header of each table and select tablix props. go to row headers and enable the repeat header rows on each apge option.

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server ReportBuilder/SSRS - How to make a report with multiple tables, same dataset and just display data from each row and repeat headers?

1条答案

相关问题

热门标签

最新问答