Crystal report can not run on COM Data source in Accpac 3

[Tianjin]

I created a COM data source that can delivery different dataset based on each computer user. I use crystal report XI to create a sales analysis report base on this data source. It works fine in original crystal report. however when I tried to run this report from Accpac, it gave "logon failed" error massage. I wonder if there is option COM Connectivity driver has not been installed when Accpac initially setup, or there is other reason.
By the way, all reports I created from crystal report other than this one can be run from accpac.

Thanks in advance

TianJin

 

[ettienne]

Accpac version?
If you want the report to run from the Accpac desktop and dynamically load the correct database then add the CMPNAME parameter to your Crystal report.

 

[Jay Converse]

And use an ODBC data source.

 

[Tianjin]

Thanks guys.

My report doesn't retrieve data from different databases, instead it draw data from some database but each computer in term of each salesperson can only see the data allocated to him/her, not anything else. this is why I used a dynamic COM data source where I can programally assign value of parameter of report for each computer. I know I can make multiple copies of the report and pre-set report's parameters for each computer as required. the reason being not is because first, there can be a lot some reports need to be manage. second, I just curious if it is possible to do this way.

 

[Tianjin]

forget.
My accpac version is 5.4

Thanks

 

[Jay Converse]

You can't do that with Accpac, it's reporting API wants to replace the ODBC DSN in the report with the DSN for the company you're in.

 

[Tianjin]

in other word, ODBC is the only data source can be used in crystal report to make report runable in Accpac? even if ODBC is my data provider of ADO connection in my code.

thanks

tianjin

 

[DjangMan]

Yes - if you have Accpac run the report from the desktop it will try to redirect the tables within your report to use the ODBC connection that links to Accpac.

Your best option is to create your own front end to run your report. Then you bypass Accpac's behaviour.

 

[Tianjin]

Hi DjangMan,
I think separate front end idea would definately work for me.
However, I found a lot of reports in accpac use .DLL as data source and front end to replace original parameter entry interface from crystal report software. Any way that I can do the similar things.

Thanks

tianjin

 

[ettienne]

You need the Accpac SDK to write your own report front ends and report data pipes (those are the report DLL's), forget about it.
You can use a VBA front end to run Crystal reports through the Crystal report viewer, that will bypass the problem you are having with the Accpac report API.

 

[Tianjin]

Thank you ettienne,
crystal report viewer !!!!!. what is simple and greate break through.

Thanks

tianjin