Retrieve data from GLBCHL view with CR ! 1

[EVISSER]

WHo can help me out? I will need to retrieve data from GLBCHL with Crystal Report or any other way to create a report with data from this view.

Thanks

Eric Visser

 

[jayconverse]

Is this for Accpac Pro? There's no GLBCHL view in Accpac Advantage.

Jay Converse
IT Director
Systemlink, Inc.

 

[EVISSER]

THanks again Jay!

Let me explain first what I want to do may be you will get a better idea.
There is one report GLBCH01 (GL batch Listing) which I would like to modify slightly. One of the parameters of this report is the creation date. I would like to change this parameter or add one extra parameter (Year-period).
The whole idea is to get only those batches from a selected Year-period and not from the creation date.
I thought may be I had to do it from scratch. I took a look in the Visual Linking Expert to see which tables this report retrieves data from, and I saw GLBCHL and POPORH1. I assumed that GLBCHL is a View! (maybe I am wrong). Eric

 

[jayconverse]

My bad, GLBCHL does exist. However, it's not a view, it's a datapipe DLL, which means you can't change it, and you have to use the Accpac UI to run it. All you can do is add a standard Crystal Parameter inside it. Then when the user runs the report from the Accpac UI, they'll get an extra prompt before the report starts.

Jay Converse
IT Director
Systemlink, Inc.

 

[EVISSER]

I understand! Could you tell me if I can retrieve data from this datapipe into CR and how?


Thnaks

Eric V

 

[jayconverse]

The only way you can get the data into CR is with the Accpac UI that runs it.

Jay Converse
IT Director
Systemlink, Inc.