how to show data multiple table in crystal report ?

sraj muneer

how to show data multiple table According to the relationship (ID) between the two tables sequentially in crystal report for visual studio 2012 ?

I want :

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Kumar9y ago
Have a look into below links.

https://www.youtube.com/watch?v=A9BgWZj5F-o

http://www.c-sharpcorner.com/article/generating-a-report-from-multiple-data-sources-in-crystal-re/
sraj muneer9y ago
hi all body
I'm try with all example for links but when use a left outer join from main to subtable on ID after this the show me the problem is :
my problem :
show ID 20 in (main table) and show all ID from (sub-table)
And so on
show ID 21 in (main table) and show all ID from (sub-table)
And so on
show ID 22 in (main table) and show all ID from (sub-table) , How to solve ?

I want As shown in the picture of the question :
show ID 20 in (main table) and show all ID (20) only from (sub-table)
show ID 21 in (main table) only and don't show all ID from (sub-table)
show ID 22 in (main table) and show all ID (22) only from (sub-table)
Rajkiran Swain9y ago
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm
Manikandan Murugesan9y ago
Refer these folllowing Links : https://www.codeproject.com/Questions/678734/How-to-display-multiple-table-data-in-crystal-repo

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm
Khaja Moizuddin9y ago
Please refer the below links /blogs for your requirement. https://www.codeproject.com/Questions/678734/How-to-display-multiple-table-data-in-crystal-repo https://www.codeproject.com/Questions/649503/crystal-report-using-Two-table-data http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm https://stackoverflow.com/questions/12703590/crystal-reports-for-multiple-tables https://stackoverflow.com/questions/9459882/push-data-from-multiple-tables-in-crystal-report Hope this helps