logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
xutao650  
#1 Posted : Monday, June 4, 2018 1:49:24 AM(UTC)
xutao650

Rank: Newbie

Groups: Registered
Joined: 6/4/2018(UTC)
Posts: 1
China

Hi! It's nice for you to provide this excelent tool for us! I got a problem as below:
Table "HoldInfo" has 3 columns "Reason" , "TxnUserID" while "TxnUserID" and "HoldToUserID" can be null.
Table "UserInfo" has 2 columns "UserID" and "UserName". I want to get.a datatable like "Reason","Txn User Name","HoldUserName". But the generated sql is not correct : SELECT ... FROM (UserInfo1 Left out join (HoldInfo Left Outer Join UserInfo 2 on. .) on. ..),So I can not get the datas whose txnuserid is null.
I.have config 3 tables "HoldInfo","UserInfo1","UserInfo2" and 2 left out joins in designer.
Can you help to fix it!
epf  
#2 Posted : Monday, June 4, 2018 6:04:04 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 533
Switzerland

Thanks: 7 times
Was thanked: 72 time(s) in 70 post(s)
Can you make a sample with Northwind, and attached the report showing the problem ?
Thanks.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.