?
Solved

"load report failed" VB.NET (2002) on deployment machine

Posted on 2004-08-17
25
Medium Priority
?
593 Views
Last Modified: 2008-01-09
Hi,

I have written my first extensive VB.NET project and am now at the deployment stage. It all works except the crystal stuff, would you beleive it!
Here is the code that i use to instantiate and run the report.

                Dim repland As New crptProdListLand()
                fViewer.crvMain.ReportSource = repland
                repland.SetDataSource(dsRep)
                fViewer.Show()

When i try to run the report on a deployed machine i get the error (handled and msgboxed out) "Load report failed" ...and then a credentials box pops up.
On the Dev machine it all works fine, as things always do!

I have packaged up the project using VS.NET 2002.
I have included the merge modules for my version of vs.net (2002)
         http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_net_mergemodules_en.zip.asp

and i have included the merge files that i have learnt are related to ADO.NET handling.
(http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21088702.html)
         VC_CRT.msm
         VC_STL.msm

Any help is much appreciated!

Regards

DSE
0
Comment
Question by:DSE
[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
  • 13
  • 12
25 Comments
 
LVL 10

Expert Comment

by:ebolek
ID: 11820408
Is your report crptProdListLand() embedded to the project. Check to see in the deployment package it exists.

Regards
Emre
0
 

Author Comment

by:DSE
ID: 11820470
buildaction = embedded resource
  (this is the dev project not the package project)

..........(btw this is CR.NET that is included with VS.NET 2002)
0
 

Author Comment

by:DSE
ID: 11820541
I also tried connecting to non embedded reports like this

            fViewer.crvMain.ReportSource = "C:\test.rpt"
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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 10

Expert Comment

by:ebolek
ID: 11820575
no that is wrong. You load the report for that

Crystal Decisions.CrystalReports.engine.reportdocument myreport = new report1;
myreport.load(path);
crystalviewer1.reportsource = myreport;

this is how youload the report with the path with c#
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820581
so you say when you run the report on the development machine, it displays the report OK right?
0
 

Author Comment

by:DSE
ID: 11820612
ok...for vb.net i have translated that into this...

            Dim repland As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
                repland.Load(Application.ExecutablePath & "\crptProdListLand.rpt")
                fViewer.crvMain.ReportSource = repland
                repland.SetDataSource(dsRep)


ill go try it now :o)

0
 

Author Comment

by:DSE
ID: 11820617
yes the development machine displays fine.
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820639
you dont need to set the datasource, what is dsrep. Is it a dataset? yOu set the report source of the viewer and report displays fine.
0
 

Author Comment

by:DSE
ID: 11820698
it does with the first method shown at the top....

but after just testing the line with <<<<  causes the "load report failed" error

           Dim repland As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
                repland.Load(Application.ExecutablePath & "\crptProdListLand.rpt") <<<<<<<<<<<<<<<<<<<
                fViewer.crvMain.ReportSource = repland
                repland.SetDataSource(dsRep)

dsrep is a dataset yes, I have to pass this to the report as i do several operations with it before the report shows. This doesnt cause a problem on the dev machine.

Ive just remembered to mention. The report is built on a XML schema (XSD) - basically a field definition file.

DSE


0
 

Author Comment

by:DSE
ID: 11820708
thats a point thinking about it.... i havent included the XSD in the package... should i?
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820715
Dim repland As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
                repland.Load(Application.ExecutablePath & "\crptProdListLand.rpt") <<<<<<<<<<<<<<<<<<<
  repland.SetDataSource(dsRep)
 fViewer.crvMain.ReportSource = repland

The order is wrong though. First you set the datasource of the report document then you set the reprot source of the viewer,
             
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820733
it could be there are merge modules for datasets, that you should put in the rpoject
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820760
let me find you the deployment document that I use. it is pretty good.

go to business objects.com and find ths document

Crystal Reports 10 and .Net Application Deployment

Also be sure to put the license code in the setup project. Did you do that.
0
 

Author Comment

by:DSE
ID: 11820831
are you refering to this page?
 http://support.businessobjects.com/library/kbase/articles/c2013175.asp

about the license code ... i passed that hurdle a little earlier!

ill take a good look at the suggestion and get back to you.

Thx
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11820983
search for this document : "crnet_deployment.doc".

Yours is good too though
0
 

Author Comment

by:DSE
ID: 11821178
i found crnet_deployment.pdf ... i'd already ran through it :o/ and all seems to be in order.

I will go through it again in the morning with a fresh head!

Will return tomorrow. Thx for your help today.

DSE
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11821202
No problem. I had lots of problem when i first try to deploy my app too. I understand man

Regards
Emre
0
 

Author Comment

by:DSE
ID: 11830569
Ive been through crnet_deployment.pdf and everthing seems to be in order.
hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm!
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11830662
what about the license code, did you put that in the property of the app
0
 

Author Comment

by:DSE
ID: 11830793
ye thats sorted... that was the first hurdle i had to cross. The package wouldnt complie saysing something like "licenece key cannot be null"... so i registered and put it in. compiles ok now. So its not that...

0
 
LVL 10

Expert Comment

by:ebolek
ID: 11830835
I dont know man, maybe you are using the wrong merge modules. But you said you checked it. I dont know, I have done exactly what that document said andit worked for me. SOrry

Regards
Emre
0
 

Author Comment

by:DSE
ID: 11830847
ill start a new package project and see how that goes.

Ill shout back when i have a result either way.

Regards

DSE
0
 
LVL 10

Accepted Solution

by:
ebolek earned 2000 total points
ID: 11830860
yes lets see how it goes from scratch
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11841084
Glad to help. Sometimes it helps to start from stractch

Regards
emre
0
 

Author Comment

by:DSE
ID: 11841087
thx very much for your persistant help!

by redoing the package from scratch i seem to have avoided the error this time.

I only added the merge files for crystal this time... so its essentially a cr.net dependancies installer... all is good as i can just copy the bin from the dev to the deploy for now.

I will make a tidier package at a later date including the whole lot.

Thx again!

DSE
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

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…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 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