Click here to Skip to main content
15,891,864 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

1 solution

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
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900