Solved

Crystal Report (in Visual Studio 2005)

Posted on 2011-02-13
17
710 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 8
17 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 34883608
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
ID: 34884303
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
ID: 34884535
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 100

Expert Comment

by:mlmcc
ID: 34884538
Did you install/compile as x86 or 32-bit?

Crystal in VS2005 doesn't support 64-bit

mlmcc
0
 

Author Comment

by:hongclub
ID: 34885288
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
ID: 34885532
0
 

Author Comment

by:hongclub
ID: 34885558
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
ID: 34885716
Did you build the report using the Excel sheet as the data source?

mlmcc
0
 

Author Comment

by:hongclub
ID: 34885980
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
ID: 34888951
Have you tried entering a userid and password?

Try admin with no password
try your username and password

mlmcc
0
 

Author Comment

by:hongclub
ID: 34889291
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
ID: 34889630
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
ID: 34889967
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
ID: 34890434
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
ID: 34893273
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
ID: 35163574
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

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