[RESOLVED] Error trying to print a Crystal Report after deployment

[DexterRose]

Using VB 2010 Professional and CR 13.

Everything prints just fine until I deploy my application. After deployment, I get the following error message when I try to print a Crystal Report.





This is the code I am using to print my reports.

ReportToPrint = "VehicleInventory"
            MySqlStmt = "SELECT * FROM DealershipTable; SELECT * FROM VehiclesTable WHERE VSold = 'No'"
            MyRpt = "C:\Program Files\AbcCryRpts\VehicleInventory.rpt"
 
 
                Dim conn As SqlConnection = New SqlConnection()
            conn.ConnectionString = sMyConnectionString
                conn.Open()
                Dim DtaAdptr As SqlDataAdapter = New SqlDataAdapter(MySqlStmt, conn)
                Dim RptDataSet As DataSet = New DataSet()
                DtaAdptr.Fill(RptDataSet)
                conn.Close()
               
                Dim RptDoc As ReportDocument = New ReportDocument
                RptDoc.Load(MyRpt)
 
            RptDoc.Database.Tables("DealershipTable").SetDataSource(RptDataSet.Tables(0))
            RptDoc.Database.Tables("VehiclesTable").SetDataSource(RptDataSet.Tables(1))
 
            CrystalReportViewer1.ReportSource = RptDoc
            CrystalReportViewer1.Refresh()

What am I doing wrong?

[wes4dbt]

You probably need to install the CR runtime engine. Look at this http://scn.sap.com/docs/DOC-19262

[DexterRose]

I'm getting this message on the same computer that I developed the report on(my development computer), does your suggestion still apply?

[wes4dbt]

Everything prints just fine until I deploy my application.

I'm getting this message on the same computer that I developed the report on(my development computer)

I don't understand what your trying to say. Those statements contradict each other.

[techgnome]

Compile it. Deploy it. Start your app... BEFORE doing anything else... go back to VS, and select Attach to Process from the Debug menu (Ctrl+Alt+P) find your app in the list of running processes. Select it, and click Attach.


Now, go back to your app and use it... at the point it breaks, it shoudl drop down into the code and show you where the error is... once you know that, you'll be better equiped to knw how to fix it.

-tg

[wes4dbt]

Compile it. Deploy it. Start your app... BEFORE doing anything else... go back to VS, and select Attach to Process from the Debug menu (Ctrl+Alt+P) find your app in the list of running processes. Select it, and click Attach.


Now, go back to your app and use it... at the point it breaks, it shoudl drop down into the code and show you where the error is... once you know that, you'll be better equiped to knw how to fix it.

-tg

Never new you could do this. Sounds like a great tool. I must not be understanding what he means by deploy. I've never had an app that would run in the IDE but not as an exe on the same machine.

[DexterRose]

Yes. I'm running both on the same machine.

Using your great idea I got:




This is a shot of my computer from Control Panel.

[DexterRose]

I got down as far as the "DotNet1" folder and it wasn't there, just the "DotNet" folder shown below.



How do I go about fixing this?

[techgnome]

Never new you could do this. Sounds like a great tool.

It's a freakin diety send... I use it heavily with the web services I work with... once I deploy them to my local IIS folder for the application, I can attach to the W3Service process... then anytime my server components break, it drops down into the code.

I must not be understanding what he means by deploy. I've never had an app that would run in the IDE but not as an exe on the same machine.

It can happen when a dll is referenced with "copy local = yes" but isn't included when deployed to the "run-time" folder.
IT can also happen when something, like oh the current or application directory, is different or different permissions - ie, I might have permissions on a folder in my bin folder, but under My Programs, I won't... it's rare for it to happen, but it does.

-tg

[DexterRose]

This is the first part of my appconfig file.



Thanks for your help.

I don't know how I should proceed?

[techgnome]

AppConfig isn't the issue here... it's how the CrX components were referenced and whether they need to be included in the deployment or not. If you got to the Bin folder, what's there? are any of the CrX files there?

To be honest, I'm a little perplexed by this... if I remember right, CrX wants to deploy to the GAC... which means it should be universally available ...


-tg

[DexterRose]

In my Bin folder, all I have is the Debug and Release Folders.

Backing up one in the path, I have the CR files shown below:

[wes4dbt]

Easiest fix would be to find a copy of crdb_adoplus.dll and put it in the dotnet1 folder, (I think I had to do that before). also, check your references and see if that file is listed.

[digitalShaman]

could this be a virtual store issue? do a search for the crdb_adoplus.dll on your c: drive. do you find it somewhere else than the dotnet folder - is it actually in the dotnet folder?

[DexterRose]

Thanks to everyone for hanging in there with me on this.

I could NOT find "crdb_adoplus.dll" anywhere on my computer.

When I did a search for it, I had several folders with this code in them:



I'm still at a loss as what to do?

[wes4dbt]

Download the file. Also, you probably should add this to your app.config

<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>

Google something like "crdb_adoplus.dll error" and you will find plenty of information. Though I thought this error was fixed with the current version of CR for VS 2010.

[DexterRose]

The mystery deepens!

When I did a search for crdb_adoplus.dll no results were found. However when I was snooping thru the SAP files, I found this dll in 2 different places. It was in the win32_x86 folder and another version in the win64_x86 folder in the SAP string shown in the error message as shown below.



Note: It is not in the dotnet1 folder. I tried putting these files in both the dotnet folder and in a new dotnet1 folder and it still does not work.

What do I need to do now?

I am on a 64 bit Win 7 computer and this is in a win32_x86 folder?

[wes4dbt]

Did you update the app.config?

[DexterRose]

yes. I had this all along. see one of my first posts in this problem.

[wes4dbt]

This is what I have installed

[wes4dbt]

One other thought, is your target cpu set to x86. What .Net Framework are you using?

[DexterRose]

I have:



using .Net4

I think you may have found the problem. How do I get the Runtime engine for 32bit? And what do you mean by "is your target cpu set to x86"?

[wes4dbt]

I found it here on my computer C:\\Program Files\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\Crystal Reports for .NET Framework 4.0

this link might help http://search.sap.com/ui/notes?id=00...&ssocompatible

target cpu is set in the project compile->advanced compile option. The same place you set the .Net Framework version.

If none of this solves your problem there is one other thing you might check. It sounds stupid but I was having problems and they asked if I had a "C:\temp" folder. I did and when I renamed the folder to myTemp the problem went a way. That was several years ago, just a thought.

[DexterRose]

I don't know what this means or how to do it:?

Once the packages are downloaded, copy them to the same folder as the product.xml file

[wes4dbt]

If you copy the link into your browser in will download the file. Just copy the download to that folder. Also, you should run the download on your machine so it installs.

[DexterRose]

I have the 32bit version of CR loaded on my computer and now have the 3 SAP Pgms showing in Control Panel just as you do.

I have not done: "copy them to the same folder as the product.xml file" because I don't know how or what this means.

I am getting the same error as I started with as shown below. Remember I don't have a "dotnet1" folder.

What do you suggest now?

[wes4dbt]

I have not done: "copy them to the same folder as the product.xml file" because I don't know how or what this means.

What don't you understand? You copy the files you downloaded to that folder.

If the dotnet1 folder doesn't exist, then create it. Make sure the crdb_adoplus.dll is located in the exact location that the error says it can't find it.

[DexterRose]

I created a dotnet1 folder and copied the crdb_adoplus.dll and related files into it.

I copied the 2 files (CRRuntime_32bit_13_0_7.msi and CRRuntime_64bit_13_0_7.msi) which I just downloaded into the
"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\Crystal Reports for .NET Framework 4.0" folder.

I changed my app.config folder to"

<startup useLegacyV2RuntimeActivationPolicy="true">
          <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0,Profile=Client"/>
          <supportedRuntime version="v2.0.50727"></supportedRuntime>
        </startup>

Now I have graduated to the following error:



After research I found this:



My CrystalDecisions.crystalreports.engine.dll is V2.0.50727.

I have downloaded "CRforVS_13_0_10.exe" which I am assuming is the correct dll to replace V2.0.50727.

Is this correct and is my next step to install this "CRforVS_13_0_10.exe" on my computer and set a reference to it?

[wes4dbt]

In post #26 you said you have all three files install like my example, I don't see why you would need anything else. I really don't know what your problem is, this site has the best CR experts that I have found. http://scn.sap.com/welcome?original_...ms.sdn.sap.com

Good luck

[DexterRose]

Well as they say in Politics, I misspoke. I thought I did but I just noticed there is a difference. I don't have Framework 4. See below:



How do I get Framework 4 as you have?

All I have in References is Version2.

[DexterRose]

Well, SAP had me download and install the latest version of CR, but I still had the same problem.

This obviously meant I was doing something wrong - ie operator error.

It turns out the solution to my problem was in the way I had set a shortcut to the exe for my application. If I set the shortcut to where the VB setup put the exe, I had no problem. I had done it a different way which caused the problem.. therefore operator error.

Thanks to everyone for your help on this.