Missing columns(with data) on deployment machines.

[Former Member]

I am having a weird issue..

Windows application built with vb.net 2005

Crystal reports.net

I have a report with a sub report. Some of the columns in sub report are missing on customers machines. On the developer machine all are fine.

Debug info so far.

1. Tried the same report on customer machine and on the developer machine(missing columns on customer)

2. Tried customeru2019s database here on development machine (all columns displayed)

3. Tried on another computer at customer location (missing columns). Even tried new sql server install and database copied.

4. Tried on brand new os at the developer location (all columns displayed). Here we used the developers sql server

I am totally confused why this is happening. I am not new to crystal reports been working on CR since 2000. I can not think of anything. If used no sub reports everything is fine!

For report run time deployment i am using CRRedist2005_x86.msi rev number {38ECA77D-543C-4875-9D8A-9F21350DA05C}

Has anyone experienced this?

[Former Member · Accepted solution]

Ok,

Installed crredist2005_sp1_x86.zip on the deployed machine and found the report fileds populated properly.

https://smpdl.sap-ag.de/~sapidp/012002523100010010692008E/crredist2005_sp1_x86.zip

So it's a bug.

[Former Member]

The issue still present...!

I was misinformed by the customer about the problem fixed.. When i personally checked found still there is an issue.

Missing columns from the sub reports. Happening randomly. I have done a clean install on a virtual machine and report is working fine. but on the customer machines its not.

Does anyone has this issue.. Anything to check?

[Former Member]

1) How are you connecting to the database; OLE DB, ODBC, etc?

2) Is the same connection type used both in the main report and subreport(s)?

3) When you see the missing data, export the report to rpt format. Open that report in the Design view on your dev computer and see if the field is there, or if it is stripped out?

4) Confirm you are using CR assemblies of version 10.2.3600

5) Open the report in the Design view on your dev computer, go to the File menu, report options and enable the option" Verify on first print" (you can also do this programmatically after you connect the report to the database).

Ludek

[Former Member]

Thanks Ludek for the reply.

Please go thru the inline comments for you questions

1) How are you connecting to the database; OLE DB, ODBC, etc?

OleDb connection to SQL Server 2005 Express using the sql query(Command)

2) Is the same connection type used both in the main report and subreport(s)?

Yes exactly same.

3) When you see the missing data, export the report to rpt format. Open that report in the Design view on your dev computer and see if the field is there, or if it is stripped out?

I will let you know as soon as I get hold of my customer.

4) Confirm you are using CR assemblies of version 10.2.3600

On the development machine , Yesu2026 I will have to verify it with customeru2019s machine tomorrow

5) Open the report in the Design view on your dev computer, go to the File menu, report options and enable the option" Verify on first print" (you can also do this programmatically after you connect the report to the database).

Verify on every print is already enabled

Verify on first refresh is already enabled

Just note that this is happening only for sub reports

I created a test report with the sub report having exact same query and design, both the reports worked at customer location!

Thankyou again

[Former Member]

Strange, but I think this:

3) When you see the missing data, export the report to rpt format. Open that report in the Design view on your dev computer and see if the field is there, or if it is stripped out?

I will let you know as soon as I get hold of my customer.

will be interesting to see.

Ludek

[Former Member]

Sorry about the delayed response,

My work laptop had to be completely re-installed (because of hard drive issue)

So now re-installed development environment to the new hard drive and ran the project on the laptop (dev machine)u2026 ran reports.. Found the reports missing the columns just like customer reported!

Now opened the report and manually refreshed reports in visual studio IDE, saved the report and ran it from the application. All reports working as should be. So it looks like my report population logic is missing something somewhere. Here is the code I am using

-

---

Dim crConnInfo As New CrystalDecisions.Shared.ConnectionInfo

crConnInfo.ServerName = _serverName

crConnInfo.DatabaseName = _databaseName

crConnInfo.UserID = _userID

crConnInfo.Password = _password

Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables

Dim crTable As CrystalDecisions.CrystalReports.Engine.Table

Dim crTableLogonInfo As CrystalDecisions.Shared.TableLogOnInfo

Dim crReport As New _ CrystalDecisions.CrystalReports.Engine.ReportDocument

crReport.Load(_reportPath)

crTables = crReport.Database.Tables

For Each crTable In crTables

crTableLogonInfo = crTable.LogOnInfo

crTableLogonInfo.ConnectionInfo = crConnInfo

crTable.ApplyLogOnInfo(crTableLogonInfo)

Next

Dim crSubReport As _ CrystalDecisions.CrystalReports.Engine.ReportDocument

For Each crSubReport In crReport.Subreports

crTables = crSubReport.Database.Tables

For Each crTable In crTables

crTableLogonInfo = crTable.LogOnInfo

crTableLogonInfo.ConnectionInfo = crConnInfo

crTable.ApplyLogOnInfo(crTableLogonInfo)

Next

Next

CrystalReportViewer1.ReportSource = crReport

-

---

Important thing to note here is the credentials used for database login, server name and database name are different at design and at customer.

Did I miss anything in the code above?

[Former Member]

Your code looks good. I'm not sure, but I believe you are using CR 10.2 (bundles with .NET 2005 (CR assemblies of version 10.2.3600))? If that is the case, let's do the following:

1) Download the service pack from here:

https://smpdl.sap-ag.de/~sapidp/012002523100006007872008E/crvs05sp1.exe

2) Once the SP is applied, go to the design view of the report and right click on any unused space. Choose report and report options. Enable the options "Verify on First refresh" and "Verify Stored Procedures on First refresh".

3) Ensure that the SP is also on all computers that have the app installed. The SP 1 MSI is here:

https://smpdl.sap-ag.de/~sapidp/012002523100010010692008E/crredist2005_sp1_x86.zip

Ludek

[Former Member]

Hay Ludek,

Thanks for the reply... Looks like the problem is sorted out.. Still crossing my fingers as I have to confirm it at customer site tomorrow.

I am using sql string to populate the data so both my main report and the sub reports using the Command objects.. Looks like crystal some how getting confused with two commands and overwriting the command in the sub report with the main report!. What I did was just renamed the main report command as 'CommandMain' and the subreport command as 'CommandDetail' and the reports working fine on my test!

To find that out it took long time as it never happened on the dev machine, your tip... about saving the report with the problem as rpt and opening it in dev machine helped me a lot. Thank you very much for that usefull tip.

Thanks again Ludek. Once i check with the customer I will mark this thread as answered.

[Former Member]

I'll keep my fingers crossed.

Ludek

[Former Member]

Ludek,

The issue fixed now. Reports working fine.

Thanks again.

[Former Member]

Hi

Im facing similar problem such as yours

Could you please help me what you did to get your reports working on the deployment side ??

The issue is giving me nightmares. Please help

Regards

Srivatsa

[Former Member]

Shivatsa,

Check my reply on May 29, 2009 4:19 PM that should give you an idea and possibly resolution for the problem.

Note that I was using command to create a custom SQL to populate the data. I had problems only on the sub reports.

[Former Member]

Shivatsa, it may not be a bad idea to create a new thread with all the pertinent info as described here:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement

Ludek

[Former Member]

The issue still present...!

I was misinformed by the customer about the problem fixed.. When i personally checked found still there is an issue.

Missing columns from the sub reports. Happening randomly. I have done a clean install on a virtual machine and report is working fine. but on the customer machines its not.

Does anyone has this issue.. Anything to check?