I have a report named: Accounts Payable - Journal entry report which display the debit and credit also the amounts and other details. But I have one field that doesn't display in crystal report when I put it on the report field.

I create this report using stored procedure in MSSQL then the field that are not displaying is the RegistedName varchar (250) = T4.CardFName. But when I browse the field (RegistedName) there is value but when I put it on the report field it shows nothing. Here is my Stored Procedure codes

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[Form_AP_JE]


@DocNum INT
AS

Declare @Form_AP_JE table

    (DocNum int,
     rowno int,
     Docdate datetime,
    Cardcode2 varchar(250),
     RegistedName varchar (250),
    CardCode varchar(250),
     CardName varchar(250),
     Tin varchar(250),
     RegisteredName2 varchar (250),
    Amount numeric (19,2),
    Account numeric(19,2),
    ProfitCode varchar(6),
     AcctName varchar(250),
     Debit numeric(19,2),
     Credit numeric(19,2),
    DrCr varchar(6),
    Remarks1 Text,
    CostCenter varchar(8),
    VatGrp varchar(10),
    FAO varchar(100),
    JEAmount numeric(19,2))

Insert into @Form_AP_JE
Select

    T5.Transid,
    T3.Line_ID,
    T5.RefDate,
    T5.U_BP,
    T4.CardFName,
    T4.CardName,
    T3.ShortName,
    T4.LicTradNum,
    T5.U_RegisteredName,
    T5.LocTotal,
    T3.Account,
    T3.Profitcode,
     T6.AcctName,
     T3.Debit,
     T3.Credit,
    T3.DebCred,
    T5.U_Comments as Remarks1,
    T3.ProfitCode,
    T3.VatGroup,
    T5.U_FAO,
    T5.U_JEAmount
FROM
     OJDT T5
     Left Join JDT1 T3 ON T5.TransId = T3.TransId
     Left Join OCRD T4 ON T3.Shortname = T4.CardCode
T7.DocEntry
Left Join OACT T6 ON T3.Account = T6.AcctCode

WHERE
(T3.Debit - T3.Credit) <> 0 and
T5.Transid = @DocNum
Select* FROM @Form_AP_JE
Delete FROM @Form_AP_JE



Edited by gbraijin13 - 18 Dec 2018 at 1:46pm

I'm sorry . I already update my post. thank you for the comments.