SSRS Report Builder 3.0 Auto-generate columns for flat table (not matrix grouping) to avoid manual dragging? possible?

0
votes

I must be missing something very obvious!

If I have a simple query (SELECT * FROM Table) which has 200 columns - rather than dragging each of my dataset columns onto my table object in design mode, is there any way to have those 200 columns auto built to that table, or a new table? THE CATCH IS - I don't want to do any grouping, summing, etc.. Just a flat table.

** IF I try to use the Table Wizard, it eventually brings me to that "Arrange Fields" box which provides Column groups, Row groups and Values. I only want "Columns" generated, not any kind of Matrix grouping. Just a flat table, so if my dataset returns 1000 rows, I want a table that has 200 columns, and 1000 rows.

Is this not possible in Report Builder? I'm completely stumped!! Help very much appreciated. Thanks!

1
reporting-servicesssrs-2008ssrs-tablixssrs-2008-r2
I Am not understanding this issue, Could you use headers or footers or some other mechanism that will aggregate the values for you? - Ross Bush
Possible duplicate of SSRS Auto Generating all columns from Dataset into tablix (Report Builder 3.0) - user565869

1 Answers

1
votes

The wizard WILL do exactly what you're looking for - when you get to the page in the wizard with the 3 boxes (row/column groups + details), just put all of your fields into the Details box - neither of the grouping boxes are required fields.

Leave the formatting alone on the following page, and you're set.