reportbuilder3.0reporting-servicesssrs-tablix
Is there a simple way to just auto generate every field/column from a dataset into a flat table/tablix in SSRS without making it a matrix? Seems like something that should be so easy, rather than having to drag each and every column over. Not sure if I'm missing something obvious.
My dataset returns about 180 columns, dragging them all over would be painful. Any insight would be greatly appreciated! I'm using Report Builder 3.0 by the way.
Thanks!
It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn't work.
Instead, you need to:
RepeatOnNewPage property to True.
KeepWithGroup property is set to After.The KeepWithGroup property specifies which group to which the static member needs to stick. If set to After then the static member sticks with the group after it, or below it, acting as a group header. If set to Before, then the static member sticks with the group before, or above it, acting as a group footer. If set to None, Reporting Services decides where to put the static member.
Now when you view the report, the column headers repeat on each page of the tablix.
This video shows how to set it exactly as the answer described.
There is a way to move columns through the designer:
Best Answer
Have you considered using the Table Wizard in Report Builder?
See Creating a Basic Table Report.
You can specify the required columns quite easily by just selecting them in the Wizard and Report Builder creates the table - for hundreds of columns that might be slightly easier than the standard Designer.
You can only use the built-in Wizard themes, but it's probably easier to format all of the cells in one go or by find/replace in the RDL file than specifying almost 200 fields.