Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: SAP CRYSTAL REPORT Post Reply Post New Topic
Author Message
gbraijin13
Newbie
Newbie
Avatar

Joined: 31 Oct 2016
Location: Philippines
Online Status: Offline
Posts: 2
Quote gbraijin13 Replybullet Topic: SAP CRYSTAL REPORT
    Posted: 17 Dec 2018 at 2:47pm
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
Daryl R Gerardino
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 18 Dec 2018 at 4:42am
A number of things you have told us.  One, what is the field you are having an issue with?  Second, have you verified that there is data in this field using another tool that will execute the stored procedure.  Not that it matters too much, but what is the data source (MS-SQL, Oracle, etc.).
IP IP Logged
gbraijin13
Newbie
Newbie
Avatar

Joined: 31 Oct 2016
Location: Philippines
Online Status: Offline
Posts: 2
Quote gbraijin13 Replybullet Posted: 18 Dec 2018 at 1:03pm
I'm sorry . I already update my post. thank you for the comments.
Daryl R Gerardino
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.