Crystal Report (in Visual Studio 2005)

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

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

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

Did you install/compile as x86 or 32-bit?

Crystal in VS2005 doesn't support 64-bit

mlmcc

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

Check this out.

There apparently is no 64-bit DAO engine.  You have to use ADO.NET

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333433363333333633373338%7D.do

mlmcc

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

Did you build the report using the Excel sheet as the data source?

mlmcc

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

Have you tried entering a userid and password?

Try admin with no password
try your username and password

mlmcc

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

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

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

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

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.