SELECT t.name AS table_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID ORDER BY table_name; How can I BREAK the report to list table name only once. How do I put in the control break any time table name changes in my report.
I think he(she) wants group by column_name with parent group table_name. On report, every table name will be shown only once, and for every table_name there will be all columns in lower level of hierarchy. In tablix, add column_name as lower level, and after that add parent group with header for table_name. In properties of group table_name, add page break after each value in group. This is all steps for report designer (data studio or report builder).