报表查看器问题 [英] Report Viewer Problem

问题描述

大家好，

我有一个数据库，其中包括4个表 [personels-table2-table3-table4] ，我的personels表具有一个主键(ID_per)，另外3个表具有一个外键(来自personels Table [id_per] ).

现在，我想在报表查看器中显示此信息，例如这种方法:

-ID表按ID_per分组(每个ID_per在一页中) [确定]
_显示每个ID_per的另外3个表信息，例如:

我的TABLE2包含来自人员的外键，所以我想在该页面中查看有关该ID_per的TABLE2信息，
也是Table3
也是Table4

我这样做，但是我认为这不是真实的方式
我更改数据集配置，并将这3个表必填字段添加到数据集中的个人表中
但它不起作用
我的意思是，当我执行的操作中，当一个ID_per的表之一为空时，reportviewer不会完全显示该ID_per

对不起，英语太久了，

谢谢

Hi every budy

i have a data base include 4 table[personels-table2-table3-table4] , my personels table have a primary key (ID_per) And another 3 table have a forign key (From personels Table[id_per]) .

Now i would like show this information in report viewer such as this method :

-table grouping by ID_per Field (each ID_per in one page) [this is OK]
_show that another 3 table information for each ID_per, for exampe :

my TABLE2 include forign key from personels , so i want see TABLE2 information about that ID_per in that page ,
Table3 too
Table4 too

i doing this buts i think its not true way
i change dataset configure and add that 3 table required fields to personels Table in dataset
but its not working true
my mean when i doing it , when one of tables aboute one ID_per is empty , reportviewer dont show that ID_per completely

Sorry for long and weak English ,

Thank you

推荐答案

如果我正确理解了您的问题，看来您必须对各种类型的JOINS有所了解...尤其是LEFT JOIN和RIGHT JOIN .

该链接提供了更多信息:
http://www.w3schools.com/sql/sql_join.asp [

If I understand your question correctly, it looks like you have to learn a bit about the various types of JOINS... especially LEFT JOIN and RIGHT JOIN.

This link provides more information:
http://www.w3schools.com/sql/sql_join.asp[^]

HTH

这篇关于报表查看器问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！