Solved

Crystal Report (in Visual Studio 2005)

Posted on 2011-02-13
17
703 Views
Last Modified: 2012-06-21
Hi,

I have created a crystal report in VS 2005.
It looked good on Report Preview in VS.

But when i run it (F5), it has a lot of broke images error, even click on those broken images, it has no actions, seems like javascript issue too.

I read a lot of forums, seems they also have issues:
http://www.gutgames.com/post/Crystal-Reports2c-issues2c-and-fixes.aspx

What i want is simple, i want to deploy my report to my localhost, and eventually deploy to my production server, please advise!!!!

Tommy
0
Comment
Question by:hongclub
  • 8
  • 8
17 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
You might look at this tutorial.  Starting on page 434 are the steps to take for distributing the application.  You can choose the method that best suits your situation

http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf

mlmcc
0
 

Author Comment

by:hongclub
Comment Utility
hi, thanks for your help, you are pretty helpful.

I tried to follow the pdf, but it asked me to go to security tab on the project, i cannot find it.

Anyway, i deployed to my localhost, i got this issue:
Failed to load database information. Details: The database DLL 'crdb_dao.dll' could not be loaded. Error in File C:\Windows\TEMP\CrystalReport(sub) {9DA2EFE9-0449-4FD5-973C-1496FA9F403B}.rpt

any thought? my machine is Window7, 64bit. and i am using Visual Studio 2005

Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
When you build the install package you need to include the database drivers.  Did you use the merge modules when you installed to the locahost?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Did you install/compile as x86 or 32-bit?

Crystal in VS2005 doesn't support 64-bit

mlmcc
0
 

Author Comment

by:hongclub
Comment Utility
how can i use the merge modules?

i complile it as "Any CPU" option, i tried to compile as x86, it throws me another error message on localhost ...

oh, i created the crystal report in VS2005 on my 64 bit, it worked with debugging (F5), but not working once i put them to localhost ....

the datasource i am using is a "excel" input, I read some forums, crdb_dao.dll (DAO) is a driver handle the excel input, so i create another report with just database connection as input, it works on my localhost.

Anyway, please help, i need to deploy it on my localhost and production server (both are 64 bits), what can i do? please please advise

Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
0
 

Author Comment

by:hongclub
Comment Utility
thanks, so that means i need to create a Dataset, and assign the data to that Dataset first for ADO.NET ....

One thing, i compile in 32 bit and reconfigure the IIS application pool to run 32 bit, it seems better, at least i can run the site on localhost  ... however, another popular issue: so when i run in localhost, it asked me "The report you requested requires further information" ... for all the username and password ....

Please advise .... again, i am using excel import ... they still ask me that login information ... wow!!!!

Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Did you build the report using the Excel sheet as the data source?

mlmcc
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:hongclub
Comment Utility
yes, i used Excel sheet as the data source. but the page still asked me the login information, i know it is a popular issue in VS2005 Crystal Report development.

Please advise,
Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Have you tried entering a userid and password?

Try admin with no password
try your username and password

mlmcc
0
 

Author Comment

by:hongclub
Comment Utility
i will try it, last night the issue happened on my laptop, today when i work on my office machine, it didn't ask me the login.

Also, one question, when i use excel sheet as datasource, how can i just use the excel under the same folder.
The excel i am using is located somewhere in my D drive (like d:/tommy/project/crystal/test/xxxx.xls), but i am going to deploy to production server, i don't want to use use that path, i want to just put the xls as the same path as the rpt and aspx hosting.

Please advise,
Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
There used to be an option that basically said the location is in the same directory.

I think I would determine where on the user's machine you are going to install this then create that directory on your machine and change the data source to use it from there.

mlmcc
0
 

Author Comment

by:hongclub
Comment Utility
for now, i just create a folder in the server for quick deployment.

I am running into a asp.net issue, when i deploy to my production server, the root web.config override the web.config in my report folder, how can i solve this .net issue?

Tommy
0
 

Author Comment

by:hongclub
Comment Utility
wow, i am running another issue, after it can run my subfolder webconfig ....

now it throw me this:
Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0

Any advise,
Tommy
0
 

Accepted Solution

by:
hongclub earned 0 total points
Comment Utility
finally, i give more permission for the whole web folder, the issue is solved .... so actually there are a lot of permissions setting involved with deployment

tommy
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 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

9 Experts available now in Live!

Get 1:1 Help Now