I believe (based on 6.5 knowledge) you can use the SQL Server function
CONVERT to "change" a TEXT field to a VARCHAR, like this:
select convert(varchar, your_text_field)
from yourtable
-----Original Message-----
From: Pecora, James [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 24, 2000 2:52 PM
To: '[EMAIL PROTECTED]'
Subject: SQL - Cubes and Crystal Reports
We are using Crystal Reports against OLAP cubes. The layout of many of the
reports can only be accomplished in Crystal with a "flattened" rowset. To
retrieve a flattened rowset from OLAP we are creating stored procedures in
SQL Server which in turn makes use of the OPENQUERY call passing a valid MDX
statement to OLAP [as a linked server]. This architecture works quite well
with one exception: the columns that come back in the flattened rowset are
interpreted inside Crystal as data type Memo. This is a serious problem in
that Memo fields have very limited functionality inside Crystal Reports.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
