Is there a way to auto-create all of the columns in a tablix?

Question

Is there a way to auto-create all of the columns in a tablix? I have a SQL view with 100+ columns that the user wants to see in a spreadsheet created from an SSRS report and I do not want to manually create each column for the tablix.

Answer 1

Hi，
Unfortunately, SSRS does not support adding all the fields of the data set at one time. You must add these columns manually.

In Reporting Services, we can create a dataset to return data from database. To create a report, we can drag separate field from report data pane to expected table cell, specify different expression for the field and so on. All these customizable operations are based on our needs.

Since all those fields within the dataset can’t be placed in one cell, if get all the fields of dataset added to table in a batch, in this process, we also need to distribute those fields to different cells within the table and format each field. The operation is the same as dragging fields from report data pane to table, which we should do it separately for each field. So it doesn’t make sense to all the columns to table without adding one by one. And currently, there is no such feature.

If you have any question, please feel free to let me know.
If your problem has been solved, please mark "accepted answer" on my reply, thank you for your understanding.
Regards,
Joy