Crystal Report for AccPac

Question

Crystal Report for AccPac

mdandmp (IS/IT--Management)

(OP)

18 Mar 03 15:14

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?

Anoli (Programmer) · Answer 1 · 2003-04-23 16:42:51

RE: Crystal Report for AccPac

Anoli (Programmer) 23 Apr 03 16:42

You can use a subreport.

Relloc (TechnicalUser) · Answer 2 · 2003-05-16 08:53:04

I usually create views against the GLASV table and link them via visual linking manager can be done in all data basis.

Just remember that all segments are in table so you have to split them.

mdandmp (IS/IT--Management) · Answer 3 · 2003-05-18 03:34:57

Thanks Relloc, but "create views against the GLASV table "?
Can you give more details .. this is new to me. Is this in AccPac?

Relloc (TechnicalUser) · Answer 4 · 2003-05-19 03:34:43

Nope it’s not in ACCPAC but directly on your ACCPAC database
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

Come Join Us!

Posting Guidelines

Jobs

Crystal Report for AccPac