DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
ian maclauchlan 6/5/2017 8:51:00 AM

Adding data to report

I have a report that looks at PA01201 reporting various fields out of this one table; I have been asked to add table

but the issue is the second table PA41302 has multiple rows for each row in PA01201.

What I am looking for is to transpose the second table.

Table PA41302 definition

PAPROJNUMBER

SGMTNUMB

SGMTNAME

SGMNTID

 

What I want to do is add 2 columns into report Cost Centre and Region

Where PA41302..SGMTNAME = Cost Centre or Region then data into report  

join is based on PAPROJNUMBER

Many thanks

     

Version: GP 2013
Section: Dynamics GP, SQL Scripts, SSRS