Report Viewer帮助 [英] Report Viewer Help

问题描述

大家好我有SQL Server 2008 R2，最近不得不创建一个新表来处理来自其他来源的一些数据。我的新表结构看起来像这样

Hi all I have SQL Server 2008 R2 and recently have had to create a new table to handle some data from another source. My new table structure would look like this

Name2

Name3

Name4

在一段时间内对这些名称中的每一个< Name2 60>，我有另一个表也有名称但不具有相同格式的表< Name_2>和其他数据。我想使用其他表中的列并填充我的新报告。

against each of these names in a time so <Name2 60>, I have another table which also has names but not in the same format <Name_2> and other data. I want to use a column from the other table and populate my new report.

< Name2 60> （table1）和另一个表中另一列的数据。

<Name2 60> (table1) and a datafiled from another column in another table.

很难解释并阅读这篇文章并没有多大意义。事实是 我只能在报表上使用1个数据集但是需要使用其他数据集中的字段这可能是

Its hard to explain and reading this back make not much sense. The fact is  Ican only use 1 dataset on a report but need to use fields from another data set is this possible

推荐答案

我'我不确定您现有的架构，但您可能会编写一个存储过程，将所有数据聚合到一个数据集中，如果所有数据都可以通过SQL访问，则返回该存储过程。另一个选择是编写
a单个程序集，它将获取两个数据集并从中创建一个数据集，然后您可以从报表查看器应用程序中调用该程序集中的方法。

I'm not sure of your existing architecture, but you could potentially write a single stored procedure that would aggregate all of the data into one data set and return that if all of your data is accessible via SQL ? Another option is to write a single assembly that will get your two data sets and create one from them and then you can call methods from that assembly from your report viewer application.

Hope这有帮助吗？

Hope that helps ?

这篇关于Report Viewer帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！