在同一个表中使用不同的数据集
我正在创建一个表格和参数化报告，它应该从两个不同的数据集中获取数据。 该报告按教师提供了学习者描述，并按性别、种族和残疾进一步分组。 我有教师和性别的小组摘要 例如：
faculty gender learner
BIT 856
第二个应该是这样的：
faculty gender ethnicity dis ability learner
bit M 400
bit F 456
我遇到的问题是我使用不同的数据集进行总结，并且在按教师总结时没有问题，但问题是在按性别总结时。
由于每个学院都有多个招生，我面临的问题包括基于性别的小计（我正在寻找独特的） 由于汇总字段来自数据集 2，因此它只允许我将它们包含在聚合字段中。
I am creating a tabular and parameterised report, which should get data from two different data sets.
This report gives learner description by faculty, grouped further by gender, ethnicity and disability.
I have got group summary for faculty and gender
e.g.:
faculty gender learner
BIT 856
second one should be like:
faculty gender ethnicity dis ability learner
bit M 400
bit F 456
the problem I have is I'm using different dataset for summary and I have no problems while summarising it by faculty but the problem is while summarising it by gender.
As there are multiple enrolments in each faculty I'm facing problem including subtotal on the basis of gender (I am looking for unique)
as the summary fields are from dataset 2, it only allows me to include them in aggregate fields.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我在使用 Reporting Services 时了解到，只有非常基本的查询才应该直接从 Reporting Services 处理。如果查询只是稍微困难，那么从存储过程生成数据会容易得多，该存储过程仅根据您解析的参数返回输出。另一件事是在 Analysis Services 中构建一个多维数据集，但是，这是完全不同的事情:-)
HTH，
Christian
I have learned when working with Reporting Services that only very basic queries should be handled directly from Reporting Services. If the query is just mildly difficult it is much easier to generate the data from a stored procedure that just returns the output based on the parameters you parse. Another thing is to construct a cube in Analysis Services, however, that is a totally different thing :-)
HTH,
Christian