如何在ReportViewer报告中INNER JOIN [英] How do I INNER JOIN within a ReportViewer report

问题描述

我有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?

推荐答案

只需创建一个VIEW，然后调用它或使用存储过程。



为第二个。



http://www.dummies.com/how-to/content/crystal-reports-10-adding-a-hyperlink -to-a-report.html



请检查该页面。

Just Create a VIEW then call it or use a stored procedure.

for the second one.

http://www.dummies.com/how-to/content/crystal-reports-10-adding-a-hyperlink-to-a-report.html

Kindly check that page.

这篇关于如何在ReportViewer报告中INNER JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！