Problem with free hand sql

[Former Member]

Hi all,

I have a strange issue.

I have created deski reports based on free hand sql.

Data base: Sql server 2000.

I have defined a column as long text (varchar) at the database level.

Now when I run the report only 1000 characters are displayed for that column

In database we do have more then 1000 charactersu2019 for that column.

BO version Xi r2 (Plain)

This used to work fine in the lower version of BO.

Any suggestions.

Regards

Jay

[Former Member · Accepted solution]

This is a limitation with BO XI R2.

The free hand sql in XI r2 somehow do not retrive more then 1000 characters.

However if we use a universe you can use the File>>parameters>> controls tab

"Limit size of long text objects to a specfic value".

There is no issue when you use deski 5 for the same.

Regards

Kultar

[former_member212749]

Hi,

Is that Perticular Object having long text or Character.In the Universe.

Regards

Prashant