Long type data truncated on report

[ptabkra]

Hi!

I have a (Oracle) long type data passed onto Stimulsoft report but only the first 100 characters are being displayed and the rest of the characters are truncated.
I noticed that when the column is retrieved, it is set to as "String" datatype so I tried to set it to be type "long" and this error is returned and so i set it back to type String:

Expression in Text property of 'Text2' can't be evaluated

Any thoughts about this please and how can this display issue be resolved? Thanks! -ptabkra

[Brendan]

The long data type in .NET translates to a 64bit integer so you would not be able to convert a string of characters to a long data type.

How are you retreiving the data? Is it coming from your app or are you querying it directly from the report? Have you checked if the data is coming back truncated?

Have you set the word wrap property for the text component if it is a case of the text being cut off?

[ptabkra]

I am retrieving data from a database and thru my query directly on report Designer.

It is coming back correctly when i query it on thru my sql dev tool.
However, when i query it on Designer, it is coming back truncated.

Yup, word wrap property is set correctly. so i checked on the string length and it is only returning Length = 100.

How would I display it correctly?

Thnx.

[Brendan]

Are you using the Oracle Database pack from the downloads section or are you using OleDb?

[ptabkra]

Hi Brendan,
I'm using OleDb connection.

[Edward]

Hi.

Please check that the data can be received correctly through OleDbConnection outside the report, i.e. in VS Server Explorer.

Thank you.

[ptabkra]

Hi All,
Data can be retrieved correctly through OleDbConnection outside the report

Issue fixed by adding: Extended Properties="ChunkSize=65535" on the connection string.

Cheers,
Karen

[Edward]

Thank you for this information.