Solved

Error while viewing CR10 Reports

Posted on 2004-10-11
20
738 Views
Last Modified: 2012-06-27
Hi all.

I have made two sets of same reports using Cr10 in VB6.The one set of reports uses a DSN say ABC and the second set of reports using the second DSN say DEF.

I ask the user on the software startup that which companies accounts he wants to manage.Based on his choice I simply open the correct report . Both sets of reports have been hard coded the queries and the DSN in VB data environment.

The application works perfectly fines on my development PC i.e. it opens the right set of CR10 reports besed on the user choice but on the clients PC it gives this error .

************
Logon failed.
Detalis: ADO Error Code: 0x80040e21
Source : Microsoft OLD DB Service Components
Descripton: Multiple-Step OLE DB operation generated errors.Click each OLE DB status value , if available.No work was done.
************

Then if we click the refresh button the report some times brings the data and shows it in CRVIEWER.and some times when the user clicks OK to the Error then it simply terminates whole VB application.

I don't understand this.As its working fine on my PC.
I have choosed the Database type to OLE DB (ADO) while seklecting the reports queries from Database expert.

Regerds
Ade
0
Comment
Question by:wtf666
  • 12
  • 8
20 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Can you show the code you are using?

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 35 total points
Comment Utility
Sounds like a missing dll or MDAC problem.

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
which dll :$  mlmcc ??
also the setup of my code gives an error while registring the MDAC on clients machine so I ignore it and finish installation but I afaik if thats the reason ?

For these reports I am using nearly No Code.So the problem must be either a dll or MDAC.

Can you please some more light on this.

regards,
Ade
0
 

Author Comment

by:wtf666
Comment Utility
I thought if installing whole CR10 on clients PC for checking either it is because of something missing on the clients PC which I have not added?

0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Since you are using CR10, Crystal has merge modules to help ensure all dlls are distribuited

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr10_rdc_merge_modules.zip.asp

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
i made all reports whn i had Cr9 installed on my system then i installed Cr10 later.
My Vb project reports were made in Cr9.when I uninstalled Cr9 then the reports were not opening shows that they were not updated to Cr10 automatically.

So i guess I should go with Cr9 for this project and download cr9 merge modules.
what to do after I download these merge modules ???

i downloaded the merge modules for Cr10 but the downloaded file was corrupt.Now i am downloading Cr9 merge modules.

Would Installing the Cr9 on clients PC remove this error I was receiving ?? or the only way is merge modules.


-Ade
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Installing CR9 should but you would have to leave it there and they in theory could modify your reports.

It would be better to build an installation package using the merge modules.  I think the instructions are included with the modules.

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
mlmcc

i downloaded and tried both cr9 and cr10 merge modules but it says not a valid archive file and try downloading again.I guess i have some virus on my computer which is corrupting it or may be some other reason.

So the temporary option left is installing th CR9 on clients PC.I checked doing this on my PC and it works fine.I don't know how can a user modify the reports >? the reports are only in executable format through my Vb application not in the DSR or DCA format.

I am accepting your answer

Thanks & Regards
-Ade
0
 

Author Comment

by:wtf666
Comment Utility
I installed the Cr9 on clients PC but it did not solve the problem :( and same error was comming.
Now I am again downloading Cr9 Merge modules to deploy them with the program setup.
should this work ?

-Ade

0
 

Author Comment

by:wtf666
Comment Utility
I am wondering why installing the Cr9 did not solve this problem on clients PC ? this should have solved the prblem if it was a dll missing problem.Also i simply installed the Cr9 and before that I removed the Crystal folder from the common files dir.

I did not reinstalled the Vb application after installing Cr9. does ths make any difference ? to reinstall the application after installing Cr9.Do i need to clean up some registry values too ?

I my development PC wen i installed the Cr10 while i had Cr9 reports in my application.I had to remove all entries from the registry and then un-install the cr10 and reinstall the cr9 to work in my cr9 appluication.In this process I was missing one thing i.e. not deleting the crystal decisiopn bin folder from the common files.This was giving ,me qvery executer error.This is just for reference cuz I am confused as what I am doing wrong in above senario.

Plase help
Regards.
-Ade
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
On the client PC did you do a full or complete install?

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
mlmcc:

I installed the C9 on client PC. what you mean be a complete or full install i don't get it.
I selected the typical install and waited till every things gets installed on his PC.

The install was same as i installed it on my development PC .... is it fine ?

-Ade
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
If that is how you installed on your PC it should be fine.

There are several features of Crystal that don't install on a TYPICAL installation.  I thought one of them might be what you needed but if you installed using TYPICAL on the development machine that should be what you need.

>>what you mean be a complete or full install i don't get it.
At least when I have installed CR8 at one point during the installation I get a screen which asks Complete (gets everything), Typical or Custom (allows you to pick and choose).

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
I have included the Cr9 merge modules msm files in my projct setup made througg install shield.Have not yet tried it on clients PC as i don't know if this is the reason or its MDAC causing error.

How can i find out that which dll is missing on clients computer which is causing this error or is this MDAC error . I have installed MDAC 2.8 on my dev PC and should i try installing this on clients PC as well seperately ?

Thanks alot
-Ade
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
This dependency walker will identify the require dlls then you can check which ae missing

http://www.dependencywalker.com/

mlmcc
0
 

Author Comment

by:wtf666
Comment Utility
great!!! ... Going through it...

I really appreciate & admire your help alot in CR section.

-Ade
0
 

Author Comment

by:wtf666
Comment Utility
isn't it tough to learn and use this new software for the problem i am facing.I am thinking of increasing the points?

-Ade
0
 

Author Comment

by:wtf666
Comment Utility
I used Install shield Express project assistant and for dependencies i used its installation designer.I first scanned my vbp project file through visual basic project Scan wizard option then additionaly just to be on the safe side I used the wizard which detects all dll's being loaded and all dependency being found while running my application on development PC.I also included CR RDC merge module packages in setup.All msm.
 
This worked & Solved the problem
Thanks & Regards

-Ade
0
 

Author Comment

by:wtf666
Comment Utility
New problem ::

The reports are just working fine but the user has reported me a new problem.

PROBLEM::

while viewing one report which fetches data from DB based on parameters he selects, the report fetches the data correctly but its scroll bar is gone very slow. i.e. when he pulls the scroll bar down or up with his mouse its very slow. How come this happend and i have seen this same problem in my Development PC.

any suggestions... more then welcome.

-Ade
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I haven't experienced anything like that.  I'll look for an answer

mlmcc
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now