Reporting Oracle Long datatypes

I am including a Oracle Long datatype dataset field in a table report item textbox cell and only getting 100 characters of the field displayed. Is this the maximum length possible or is it possible to display more characters?
I am connecting to the Oracle database with the Oracle provider for OLE DB and having no problems with other datatypes.Which version of the Oracle client is installed? It has to be the Oracle
8.1.7 client or later. Some people on the newsgroup have reported issues
with garbage returned when using the Oracle 8.1.5 client against an Oracle
9i server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RW" <RW@.discussions.microsoft.com> wrote in message
news:52AE66B5-576F-4BF3-B215-CC3193C0955E@.microsoft.com...
> I am including a Oracle Long datatype dataset field in a table report item
textbox cell and only getting 100 characters of the field displayed. Is this
the maximum length possible or is it possible to display more characters?
> I am connecting to the Oracle database with the Oracle provider for OLE DB
and having no problems with other datatypes.

Reporting Financial Ratings

I'm running into 'CLS-compliance' problems trying to use characters such as "+" and "-" as reporting fields. For example, Standard and Poors ratings have these characters to indicate a notch between main letter rating categories. I have reports that need to display distributions of these various ratings in column charts. However, the X axis labels refuse to print because of these characters!

Any suggestions? This is an awfully common type of labelling in this business!

Thanks

Try Char(43) instead of "+" and Char(45) instead of "-".