Need to add the GL # to the PO Form in SSRS

[dhalim (Debra Halim)]

I need to add the G/L # onto the POForm SSRS report using a copy of the Standard-SSRS report style but am unable to figure out how to bring in the proper fields and display the G/L account info on the same line as the PO Rel Due Date, PORel.RelQty without getting an error upon trying to upload the modified rdl report after updating a copy of the original rdd file after adding the TranGLC table to it and removing the checkbox on the excluded fields from tables.

In the crystal version we have it shows a subreport to "getaccountinfo on the G/L#. See images.

[dcamlin (David Camlin)]

I have this added on mine:

RDD:

1. Added TRANGLC as Data Source
2. Added Relationship between PORel and TRANGLC:

NOTE… if you want the GL Account description, you need to add the GLAccount linked table to the TRANGLC table:

RDL:
I added the below join to the POForm_PORelPart subreport…

LEFT OUTER JOIN TranGLC_" + Parameters!TableGuid.Value + " T5 ON T3.Company = T5.Company AND T5.Key1 = cast(T3.PONum as varchar) AND T5.Key2 = cast(T3.POLine as varchar) AND T5.Key3
 = cast(T3.PORelNum as varchar) AND T5.RelatedToFile = 'PORel'

Added these two fields to the query:
T5.GLAccount, T5.GLAccount_AccountDesc as GLAccountDesc

Added them as query fields:

Added the fields to the report:

Results:

[Mike_Tonoyan]

Unfortunately, with this method Report Style \ SSRS Breaking/Routing gives an error:
“Parent Columns and Child Columns don’t have type-matching columns.”
I am not sure what else can be done.