Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 08, 2008 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 04:02 AM

    Hi,

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

    Regards

    Prashant

    Add comment
    10|10000 characters needed characters exceeded