Hi,

Is there any way or option to get the all columns of dataset added to table when we add a table in data regeon. It will take lot of time to add one by one and also there are chances to add one column ore than omce.

Thanks!

Shamsuddeen

Hi Shamsudden,

SSRS does not allow to add all the fields of a dataset in one stretch. You got to manually add these  columns.

In short no.

You could however recreate the Report if there are a lot of columns to add?

This trick may be helpful in some cases:

http://stackoverflow.com/questions/6751676/in-ssrs-2008-is-there-any-way-to-add-all-dataset-fields-to-a-table-at-once

Hi Shamsuddeen,

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 cant 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 doesnt 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 ask.

Best regards,
Qiuyun Yu

Thanks all for the reply and suggestions.

Br,

SHamsuddeen