SAP CRYSTAL REPORT
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22711
Printed Date: 25 Apr 2024 at 11:39am
Topic: SAP CRYSTAL REPORT
Posted By: gbraijin13
Subject: SAP CRYSTAL REPORT
Date 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
-------------
Daryl R Gerardino
|
Replies:
Posted By: kevlray
Date 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.).
|
Posted By: gbraijin13
Date Posted: 18 Dec 2018 at 1:03pm
I'm sorry . I already update my post. thank you for the comments.
-------------
Daryl R Gerardino
|
|