×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Crystal Report for AccPac

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?

RE: Crystal Report for AccPac

You can use a subreport.

RE: Crystal Report for AccPac

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.

RE: Crystal Report for AccPac

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

RE: Crystal Report for AccPac

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close