Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Crystal Report (in Visual Studio 2005)

Posted on 2011-02-13
17
Medium Priority
?
724 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 101

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 101

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 101

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
 

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 101

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 101

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 101

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 101

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

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…
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 …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

618 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