Crystal Report for AccPac

[mdandmp]

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]

You can use a subreport.

 

[Relloc]

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]

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

 

[Relloc]

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