RDLC dataset - Left join with CONST filter

(0) Share

Report

Posted on by Samantha73

3,370

Hi Guys

I'm struggling with left joins in BC query and report dataset :) I know in a query object you cannot have a left join with CONST filter as this acts as a where clause. Detail blog below:

Dynamics 365 Business Central Queries: Erm…where are the rest of my rows?! – James Pearson (jpearson.blog)

I want to know if this is the case with RDLC report datasets as well and if there are any workarounds for creating left joins with advance filter options? Basically I want to create a report that shows all items and for the items with purchase orders, order numbers in expanding columns something like below:

Item On Hand PO10001 PO10009 PO10010 PO10900 PO 1000901 ........

A 10 10

B 20 20 12

C 12

E 50 10

I don't think I can use a variable in above scenario

All responses (2)

Answers (1)

Sort by

Verified answer

THE Italian Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

There is no easy way to achieve this. I think this could be very similar to e.g. location codes. Instead of location codes you have PO.

if your dataset is made by item dataset and PO as linked dataset, I think you might achieve this. A bit complex tough, and if you have 1000 PO how you could cope with the horizontal printing?

Very strange report.
Samantha73 3,370 on at

Like (0)

Report
Copy link

Link copied!

Thanks Duilio, This report itself is not important as I've only given it as an example BUT the fact remains that BC cannot handle advance joins and this limits what we call paginated reports. Whilst PBI is a great tool its not suitable for all business scenarios and currently we cannot use the full potential of SSRS without improvements to AL code base

Join the conversation

Community site session details

RDLC dataset - Left join with CONST filter

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

RDLC dataset - Left join with CONST filter

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates