News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How can I add a OneToO...

Small and medium business | Business Central, N...

Suggested answer

How can I add a OneToOne Field to a report dataset as a column

(0) Share

Report

Report

Posted on by Redgren

80

I have a custom table which has a User field (relation to User) as the key as well, plus an extra field, SG Number.

So I know the SG Number is always 1 (one) for each user. So when running a report I have tried adding a dataset like this:

But this always returns all rows on each "child dataset"

WHat options can I explore to have it return only the matching row, where the UserName matches with the Parent table's user?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Amit Baru 3,029 on at

Like (0)

Report

RE: How can I add a OneToOne Field to a report dataset as a column

Hi,

Please share both tables structure and its sample data.

Regards

Amit Sharma

www.erpconsultors.com

www.linkedin.com/.../

Press Yes if verify.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Sohail Ahmed 1,452

#2

YUN ZHU 1,313 Super User 2025 Season 1

#3

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans