Solved

unable to view report on client pc

Posted on 2001-06-06
9
179 Views
Last Modified: 2008-03-10
Hi,

I have Crystal Reports 8.5 and Crystal Enterprise 8 installed on my NT server.  I have a Sybase 7 database and IIS installed as well.  I have a client web app that connects to the db and populates and displays the reports.

Everything works fine when I launch the web page from the server, the report is displayed.

But when I try it from a workstation, the web app runs, connects to the database just fine but is unable to display the report.

I have just installed all of these things on a clean server, is there something that I forgot to install on either the server or workstation.  I know that the app works just fine as it was working on a previous server.

Thanks,
-Z-
0
Comment
Question by:zawaad
9 Comments
 
LVL 1

Expert Comment

by:psyberfry
ID: 6160378
Are you getting any error messages on the workstation when it fails to display the report?
0
 

Author Comment

by:zawaad
ID: 6162961
no, just a red cross indicating that it cannot load the image.  According to Crystal's FAQs, it says that in IIS you should set the viewer virtual path's permission to None.

But that doesn't work either.

The thing is that when i installed Crystal it installed the web stuff in IIS under the default website and not the site that I created, so I manually had to copy the settings to my site.

My hunch is that the prob lies with the IIS setup, but what ?

-Z-
0
 
LVL 1

Expert Comment

by:psyberfry
ID: 6183294
Hey-

I ran across these articles in Crystal's Knowledge Base and thought you might be interested.

Goto...
http://support.crystaldecisions.com/library/kbase.asp

These are the Article ID's...

c2006465
c2004469
c2005176

Hope this helps you a little...

-psyberfry
0
 

Author Comment

by:zawaad
ID: 6185046
Hi,

Thanks, I have seen that already, I have been thru all the FAQs on Crystal's website and even called tech support, but no luck in solving the problem.

The good news is that I managed to solve it, by accident.
Our ADSL line was plugged in yesterday and I was setting up the PC to get onto the net, and just decided to run the page. It brought up the certificate to download the Crystal viewer, which is the point which it normally fails. Then it brought up a confirmation window to download a new copy of 'Microsoft Active Template Library dll', it took a few mins and all of a sudden it worked, the viewer downloaded and loaded the report.

Then I checked the 'atl.dll' on one of the PCs that didn't have access to the net yet and that was version 2 compare to version 3 that was just downloaded and made te viewer work.

So what I gather is while trying to download the viewer (pre net access), the viewer was trying to download a new copy of this 'atl.dll' file to make it work, which it couldn't and therefore failed!!

If only the damn thing displayed an error, I could have downloaded it myself and saved a week of frustration.

-Z-
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Expert Comment

by:pgtek
ID: 6186918
0
 
LVL 1

Expert Comment

by:psyberfry
ID: 6191632
Sounds very frustrating!
Thanks for the info it might prove useful sometime in the future.
0
 
LVL 1

Expert Comment

by:psyberfry
ID: 6191634
Sounds very frustrating!
Thanks for the info it might prove useful sometime in the future.
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6325297
zawaad

If you have solved your own problem, would you please take a moment and leave a message in community support at http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and ask them to PAQ your question and return your points.  Alternatively, you can award points to the expert who helped you most by clicking on the Accept Comment as Answer button.

Please do not award points to me.

DRRYAN3
0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 6494386
Points refunded and question moved into PAQ.

Thank you,
ComTech
Community Support Moderator
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

10 Experts available now in Live!

Get 1:1 Help Now