Problem viewing data

[Former Member]

I have a VS2005 program with Crystal Reports in it. These work a treat on my pc. When I run through Citrix however, some lines of data may or may not be missing. What do I do to stop this happening?

[Former Member]

how are you connecting to your data source?

if you are using ODBC what are the ODBC setting on your machine and on the server?

[Former Member]

Hiya, thank you for your reply.

I am connecting to that database by sending a connection string through to the SqlConnection class

[Former Member]

what type of connect do you use

can you post the connection string ( replace specific words with ** to protect the innocent)

[Former Member]

My string is

SqlConnection requestConnection = new SqlConnection("Data Source=*;Initial Catalog=;User ID=;Password=*");

requestConnection.Open();

where SqlConnection is System.Data.SqlClient.SqlConnection

and the connection string is passed in rather than hard coded

[Former Member]

therefore if you are using the same usename SQL should return the same data.

what am I missing here?

[Former Member]

Yep same data is being returned. Just through my pc all the data is on the report fine and dandy. On the Citrix report (same database, connection string and exact record) the data was missing. This seems to be random. Yesterday all the data printed on the Crystal report through Citrix, this morning only some does. So it randomly misses out lines sometimes and not others. And does look totally random. The same record prints on my pc perfectly each time.

[Former Member]

is this a 'view' thing?

are the report totals correct?

if you print the report from Citrix does this print correctly?

[Former Member]

There are no totals on this report. The report is just listing 5 fields of a single record (it's a little label). When I printed it this morning over Citrix, I noticed some of the fields were missing. I then printed the same record using the app locally on my pc, and the field values were all there beautifully.

[Former Member]

Can you edit the report for testing to put in some lable text. (they can be removed after)

and ensure it uses the same format as the existing fields

what font are you using?

[Former Member]

Font of fields is Arial, 9.75pt

There's TextObjects of plain text on the report and they print every single time. These are the same font and Arial, 8.25pt, style=Bold

I suppose I could put the values into TextObjects. Would like to know what this issue is though really for the future. And the code is nice and simple and tidy at the moment!

[Former Member]

Change all fields to Arial, 8.25pt, style=Bold

[Former Member]

Will do that.

How do you think that will help?

[Former Member]

if the data is there ( and I can't see why it's not) then the issue is actually printing it on the paper and the issue may be with the font not working with this printer if the static text always prints ( and is in BOLD) then lets just try that and if it works and you can verify that is the issue then you will know where to solve the issue.

as someone** else has posted elsewhere debugging is a case of divide and conquer. (**Michael Meyers-Jouan)

Edited by: AlunJD on Aug 17, 2011 1:54 PM

[Former Member]

Morning, it turned out to be some sort of print driver issue. Oddly if the label printer was set to 4x6 instead of the 2x4 labels that they actually are, the data could always be viewed. Seemed to be some odd Citrix - Printer driver issue which seems happy now. Thank you very much for your time!