Crystal Report for AccPac
Crystal Report for AccPac
(OP)
I am want to write a report in crystal using the segment descriptions.
I am using GLAMF and want to link it to GLASV to obtain these descriptions.
However they do not want to seem to link, I think because they are not indexed on segment codes alone.
Any suggestions?
I am using GLAMF and want to link it to GLASV to obtain these descriptions.
However they do not want to seem to link, I think because they are not indexed on segment codes alone.
Any suggestions?
RE: Crystal Report for AccPac
RE: Crystal Report for AccPac
Just remember that all segments are in table so you have to split them.
RE: Crystal Report for AccPac
Can you give more details .. this is new to me. Is this in AccPac?
RE: Crystal Report for AccPac
Depends if you are running MS SQL or Pervasive.
The principle is the same for both however.
What you should do is create a view directly in your database if you are using Pervasive you might be required to ad indexes to some of the tables in order to accommodate links.
The script below will create a view called Retail against the SAMLTD and will contain all descriptions for the Retail segments in your GL
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Retail]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[Retail]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.Retail
AS
SELECT SEGVAL, SEGVALDESC
FROM dbo.GLASV
WHERE (IDSEG = '000002')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Hope this helps
RELLOC