dataset designer relation and crystal report

Asked Nov 30 '15 at 09:19

Active Nov 30 '15 at 09:19

Viewed 156 times

I am using datables in dataset.xsd designer visual studio 2012. I have three tables

tblA,tblB and tblC

tblA (parent)   --- ---->  tblB
aid                       bid

tblB(parent)    -- ---->  tblC
nid                     nid

if tblB is empty then no data is displaying in report.I want to show data in report if no data is in datable B.

asked Nov 30 '15 at 09:19

user good

Left Join instead of Inner Join. You can specifiy that in the relation designer by clicking "select all rows from TblA". – Tim Schmelter Nov 30 '15 at 09:22
how can i do left join in dataset desingner visual studio 2012 – user good Nov 30 '15 at 09:24
there is no button in designers select all rows from tblA.Can you show me through image – user good Nov 30 '15 at 09:26
I am making a relation in dataSet designer – user good Nov 30 '15 at 09:27
1

You have to right-click on the relation between both tables, default is INNER JOIN. You can select a different join-type by ticking off "Select all from TblA", "Select all from TblB" or both (which is a full outer join). – Tim Schmelter Nov 30 '15 at 09:30
I will click in links dataset designer .xsd or links in crystal report tab? – user good Nov 30 '15 at 15:53

0 Answers0