Dear hasokeric,
We have already added the description column in custom report using Report Builder. But data is not displaying in the report. We have also added the “Description” column and tables relationship as in RDD maintenance into SQL query phrase in the RDL dataset (Refer to below code)
“SELECT T5.Description, T2.Company, T2.BookID, T2.RvJrnUID, T2.RvJrnTrUID, T1.CurrencyCode, T2.FiscalYear, T2.FiscalYearSuffix, T2.FiscalPeriod, T2.JEDate, T2.Calc_GroupID, T2.Calc_JournalNum, T1.[Description], CAST( T1.CurrencyCode_DecimalsGeneral as nvarchar ) as CurrencyCode_DecimalsGeneral, T1.CurrencyCode_CurrDesc, T2.BookCreditAmount, T2.BookDebitAmount, T2.Calc_LegalNum, T4.BookCreditAmount T4BookCreditAmount,T4.BookDebitAmount T4BookDebitAmount,T4.CreditAmount T4CreditAmount, T4.CurrencyCode T4CurrencyCode,T4.DebitAmount T4DebitAmount,T4.[Description] T4Description, T4.GLAccount T4GLAccount,T4.JournalLine T4JournalLine,T4.Reverse T4Reverse, T4.Calc_AccDescription T4Calc_AccDescription, T4.CurrencyCode_DecimalsGeneral T4CurrencyCode_DecimalsGeneral, T4.HasReverseLine T4HasReverseLine, T4.DebitStatAmt T4DebitStatAmt, T4.CreditStatAmt T4CreditStatAmt, (T4.DebitStatAmt - T4.CreditStatAmt) T4StatAmtBalance, T4.StatUOMCode T4StatUOMCode, T4.Calc_StatDecimals T4StatDecimals, T4.Statistical T4Statistical, T4.Calc_AmortCodeDescription, T4.JournalNum FROM GLBook_” + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN RvJrnTr_" + Parameters!TableGuid.Value + " T2 ON T1.Company = T2.Company AND T1.BookID = T2.BookID left join (SELECT T3.DebitStatAmt, T3.CreditStatAmt, T3.StatUOMCode, T3.BookCreditAmount,T3.BookDebitAmount,T3.Company,T3.CreditAmount,T3.CurrencyCode,T3.DebitAmount,T3.[Description],T3.GLAccount,T3.JournalLine,T3.Reverse,T3.RvJrnTrUID,T3.RvJrnUID,T3.Calc_AccDescription,T3.CurrencyCode_DecimalsGeneral, T3.HasReverseLine, T3.Calc_StatDecimals, T3.Statistical, T3.Calc_AmortCodeDescription, T3.JournalNum FROM RvJrnTrDtl_" + Parameters!TableGuid.Value + " T3) T4 ON T2.RvJrnUID = T4.RvJrnUID AND T2.RvJrnTrUID = T4.RvJrnTrUID AND T2.Company = T4.Company LEFT OUTER JOIN GLJrnHed_" + Parameters!TableGuid.Value + " T5 ON T2.Company = T5.Company AND T2.Cal_GroupID = T5.GroupID"
Column : T5.Description
Tables Join: LEFT OUTER JOIN GLJrnHed_" + Parameters!TableGuid.Value + " T5 ON T2.Company = T5.Company AND T2.Cal_GroupID = T5.GroupID"
Not sure what direction to pursue next.