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.
Question:
Is there a way to control (In SQL) how fields record sets are cast, we would
need to force memo/blob into varchar...Or is there a way to convert a
recordset field type??
Another Question:
Is there any work around available inside Crystal Reports i.e. converting
the memo columns to strings or numeric types?
Thanks
------------------------------------------------------------------------------
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.
