Using the same table twice in a report

Business Central/NAV Developers Forum
1

I have a requirement to write a report using the same table twice in a report. Joining once on one field, write out some info, then join it again using a different field. How can I accomplish this without code?

If I have to use code how do I do it?

Trying to join Salesperson / Purchase to Sales Invoice Line using SP.Code = SIH.Salesperson Code Second join would be SP.Code = SIH.Salesperson Code 2

I tried using code but it is only returning one record. I am using Findset

cbSIH.SETFILTER(“Salesperson Code”, Code);
IF cbSIH.FINDSET THEN BEGIN
Repeat
UNTIL cbSIH.NEXT = 0;
END;

2

Please disregard as I lost my marbles for a second. I figured this out after stepping away from it for awhile. Mod please close or delete.

3

Hi Chuck B,

Instead of deleting this thread, it would be better that you post your own solution in your next post and Verify that Post as solution, this will help somebody in future who might face same/ similar problem.

4

Hi.

Can you please tell how you accomplished this.

Is it the same if you have the same section twice in report designer?