Problem in data source in query

(0) Share

Report

Posted on by KareemTaima

304

Hi,

I have a data source A (TranslaionForBank) in query linked to another data source B (BankAccounts) via some field assume it's BankAccount, if the table A doesn't have a match for field BankAccount in the some cases the ssrs report fails and doesn't get any data for the whole report not just this part

How can I avoid this?

so if there's no match the part related to banks comes empty but the rest of the data sources in the query well work fine

All responses (3)

Answers (2)

KareemTaima 304 on at

Like (0)

Report

RE: Problem in data source in query

thank you all, it's working now
Verified answer

WillWU 22,352 on at

Like (0)

Report

RE: Problem in data source in query

Hi KareemTaima,

An inner join rejects all table rows that fail to match a row in the other joined table. But an outer join includes rows from the first table even though there is no matching row in the other joined table. Default values are substituted for the data that could not be obtained from a matching row in the other joined table.

Refer to: https://docs.microsoft.com/en-us/dynamicsax-2012/developer/select-statement-with-an-outer-join
Verified answer

Mea_ 60,278 on at

Like (0)

Report

RE: Problem in data source in query

Set join mode to Outer join instead of inner. This way you will get records for bank even if there is no transaction.