问题描述
我有2张桌子
装配和砖块
每个装配有多块砖（最多3块）
每个Brick附带一个LotNumber和一个SerialNumber
我喜欢搜索Assembly表然后按Brick过滤.LotNumber
如果我理解正确我应该将数据集设为包括两个表，并将Brick.LotNumber的INNER JOIN连接到Assembly.Brick1.LotNumber
Brick.LotNumber到Assembly.Brick2.LotNumber
Brick.LotNumber到Assembly.Brick3 .LotNumber
是/否？
我可以制作一个报告查看器，可以为一个人做一些非常简单的事情表，但不是2个相关的表。
第二个问题和快速，是否可以在报告中进行超链接？例如 超链接Brick1.SerialNumber？
I have 2 tables
Assembly and Bricks
Each Assembly has many bricks(maximum 3)
Each Brick comes with one LotNumber and a SerialNumber
Id like to search the Assembly table and then filter by Brick.LotNumber
If I understand right I should make the dataset to include both tables and do an INNER JOIN of Brick.LotNumber to Assembly.Brick1.LotNumber
Brick.LotNumber to Assembly.Brick2.LotNumber
Brick.LotNumber to Assembly.Brick3.LotNumber
Yes/No?
I can make a reportviewer that does pretty simple stuff for one table, but not 2 tables that are related.
Second question and a quicky, is it possible to hyperlink within the report? such as hyperlink Brick1.SerialNumber?
推荐答案
这篇关于如何在ReportViewer报告中INNER JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！