Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with free hand sql

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
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question