在SSRS 2008中，有没有办法一次性将所有数据集字段添加到表中？
我是第一次使用 SSRS。将表添加到报表时，是否有任何方法可以一次将数据集的所有字段添加到其中，还是必须单独完成？拖放删除、插入列->当显示很多字段时，右侧是一种痛苦。
I'm working with SSRS for the first time. When adding a table to a report, is there any way to add all fields of a dataset to it at once or does it have to be done individually? Drag & drop, insert column -> right is a pain when there are a lot of fields that are being displayed.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
这是一种解决方法，但“添加新报告”向导会自动创建一个表，其中包含给定数据集中的指定列和组。我不认为有办法从现有报告中触发此功能，但您可以创建一个“牺牲”报告来获取您正在寻找的内容 - 运行向导，生成表格，然后复制/粘贴它到你的原始报告中。只要您的数据集相同，它就应该可以正常工作......
希望这会有所帮助。
It's a bit of a workaround, but the "Add new report" wizard automatically creates a table with the specified columns and groups from your given dataset. I don't believe there's a way to trigger this functionality from within an existing report, but you could create a "sacrificial" report to get what you're looking for - run through the wizard, generate the table, and copy / paste it into your original report. As long as your datasets are the same, it should work just fine...
Hope this helps.
我有一个与操作类似的问题，并且是 SSRS/BIDS 的新手。而且，我正在更新以前创建的报告，该报告（对我来说）太复杂，无法使用“向导生成”快速重新创建，因为数据源是一个 Web 服务（具有代码生成的 Web 服务参数，大量计算数据）数据源字段等）。复制 .rdl、全部删除并手动创建表会更快。
我想我会补充一点（只比op的方法好一点，但仍然节省时间）你可以只需拖放来填充列，而无需“右键单击>插入列” >对”。只需将数据集字段拖到表中所需的位置，BIDS/SSRS 就会自动插入新列。它还有助于先拖动后一列（即始终插入前一列），这样您就不必一直向右滚动。
I have a similar problem as the op and am new to SSRS/BIDS. And, I am updating a previously created report which (for me) is too complex to just quickly re-create using the "wizard generation" as the datasource is a web service (with code-generated web service parameters, lots of calc'd datasource fields, etc). It is faster to just copy the .rdl, delete all, and create the table manually.
I thought I would add that (only a little better than op's method, but nonetheless it is time-saving) you can just drag and drop to populate columns w/o the "right click > insert column > right". Just drag the dataset field to the place you want it in the table and BIDS/SSRS will automatically insert a new column. It also helps to drag the latter columns first (i.e. always inserting a previous column) so you don't have to scroll to the right all the time.
我一直在寻找类似的东西并且我已经弄清楚了。在 Report Builder 3.0 中打开您的报表，这是 Microsoft 提供的免费 BI 工具。转到插入>表向导。然后只需按照向导步骤生成自动列即可。在视觉工作室中保存并重新打开文件，文件将自行刷新。
韦德
I was looking for the similar thing and I have figured this out. Open your report in Report Builder 3.0 which is a free BI tool by Microsoft. Go to Insert > Table wizzard. Then just follow the wizard steps to generate auto columns. Save and reopen the file in your visual studio, file will refresh itself.
Ved
@Kevin Fisher 实际上不需要解决方法。 Report Builder 3 中有一种开箱即用的方法可以做到这一点。打开您现有的最喜爱的报告模板。在工具栏上，单击“插入”选项卡，查找“表”图标，单击“表”图标底部的向下箭头，然后选择“表向导”。那么我想你知道从这里该做什么了。 -希望这有帮助。
@Kevin Fisher actually there is no need a workaround. There is way to do this out of the box of Report Builder 3. Open your existing favorite report template. on the tool bar, click on INSERT tab, look for TABLE icon, click on the down-ward arrow at the bottom of the TABLE icon, then choose TABLE WIZARD. Then I guess you know what to do from here. -hope this help.
使用分页报告，转到表向导，选择所有字段并将它们拖到值框，然后单击下一步，直到获得快速报告。
Using Paginated Reports, go to Table Wizard, Select all fields and drag them to the Value box, then click next, until you get your quick report.
我同意没有办法轻松地将数据集中的所有列转移到表中。但我想出了一个对我有帮助的方法：
插入一个空白表格（这通常会给你 3 列）。然后将列插入到表的右侧（右键单击，插入列，到右侧），根据需要多次插入列，以使其等于数据集中的列数。
在表中创建所有空白列后，单击表单元格框内部并使用下拉列表选择字段。这样做的另一个好处是允许您以正确的顺序获取字段，因为我注意到数据集中的字段名称并不总是以与 SQL 存储过程输出相同的顺序出现。
I agree that there is no way to bring all of the columns over from the data set to a table easily. But I came up with a method that helped me:
Insert a blank table (this usually gives you 3 columns). Then insert columns to the right of the table (right click, Insert Column, To the Right), as many times as you need in order for it to equal the number of columns in your data set.
Once you have all the blank columns created in your table, click inside a table cell box and use the drop-down to select the field. This has the added benefit of allowing you to get the fields in the correct order, since I've noticed that the field names in the dataset don't always appear in the same order as the SQL stored proc output.