Accpac DLL and Crystal Reports 10

[irenavassilia]

Is it possible to connect to an Accpac DLL through Crystal Reports version, because when i try to run my Crystal report which is connect to a A4WUDP.DLL it tells me the database DLL 'crdb_p2bpipe.dll' could not be loaded.

I have tried registering the dll and it wont allow me says the DllRegisterServer entry point was not found. This file can not be registered.

Does anyone know what I can do to fix this problem?

Thanks alot.

 

[Jay Converse]

You need to set the password to Saminc (or Samltd) in the datapipe.ini (parameter P3) for the module you're working with.

 

[ettienne]

Some Accpac Crystal reports use a DLL as datasource, these are known as datapiped reports. The Accpac DLLs are special programs written by Accpac to perform data processing and calculations not possible or practical within reports, or just to speed up reporting.
I'm not sure about a4wudp.dll, I could not find it, but to be honest I did not search very hard.
So to answer your question, if the DLL is a datapipe for a report then you can use it in Crystal, if it is not a datapipe DLL (for example program DLLs in the application folders) then it cannot be used in a Crystal report.

 

[irenavassilia]

Hi Tuba,

The password has already been set up to Samltd in the datapipe.ini file.

This is it am i correct?:

[A4WUDP.DLL]
query="A4WUDP"
P1=SamLtd
P2=ADMIN
P4=ENG

The report still cant find the crdb_p2bpipe.dll, tells me database could not be loaded.

Thanks.

 

[Jay Converse]

Let's step back... What are you trying to do to that report, and which report is it?

 

[irenavassilia]

Hi tuba,

Its report AR3000 and i want to make it into a subreport where i can link it to the main report and pull the username out of the subreport matching the userid from the main report table.

Regards,

Irena

 

[ettienne]

There is no Crystal report named AR3000.rpt

 

[irenavassilia]

My apologize, AS3000.rpt

 

[ettienne]

So if I understand you correctly, you want to print Accpac user names on a report. You cannot pull the user names from where they are saved, since it is saved in USERS.ISM, which is an ISAM file and not a table in the database.
You cannot use AS3000 as a subreport, it is just not going to work.
What you can do is save the user names in an Optional Table. Export the user id and user name, then import into an optinal table, or write a macro to do that for you. Both are fairly simple.
Link to the Optional Table in your report and you will be able to pull the user name. The Optional Table will have to be maintained when users are added.

 

[irenavassilia]

Yes I've done that, not in the optional table though. We just chose a field thats not being used within the POPORH1 table, so theres alot less complications.

The macro i have created too

Just thought that you could do it with the dll, but i guess not.

THanks.

 

[ettienne]

OK, so you have a solution.
The A4WUDP.DLL does not work in a subreport, been there as well and tried 100s of things.