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
thank you all, it's working now
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
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
