Display BLOB Data Fields From Sybase DB into Crystal Reports

[Guest_imported]

Hi,

I have a question for any one who can suggest me a solution. I have a BLOB Field Data From a Sybase Data Base Stored procedure and am displaying it into a Crystal Report (it works fine). As I can understand, the only way to format a MEMO Field (Which I need to do) in Crystal Report is by using an SQL Expression from the field explorer as we can't have any Formula written for a MEMO or BLOB Field type in Crystal. My problem is, when I am trying to use a Stored procedure to Create an SQL Expression, I can't see the SQL Expression, at all, (Insert->Field Object) in the Field explorer BUT when I create a report from a Database TABLE, I can see the SQL Expression, which I can use. Is there any restriction that reports created from STORED PROCEDURES does not allow to create an SQL Expression at all ? (Which I badly need to Format a MEMO Field that I want to display in the Report). My CR Version is 8.5.0.217

-Kamal

 

[rosemaryl]

Dear Kamal,

Why don't you modify the stored procedure to bring the column in again as the first 254 characters or whatever portion you need?

That would seem the easiest way to do it. I have never attempted to write a sql experssion on a stored procedure so I can't help you there.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[rosemaryl]

Dear Kamal,

Also, when you say format, what do you mean.

You can use a blob field in some formulas, for example:

Isnull(blobfield) is valid.

So if you wanted to suppress a section that contained the blob field you can do that. What you cannot do is format it conditionally based upon the contents.

What exactly are you trying to do with the field?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[synapsevampire]

I thought that I'd answered this...

You can't use a column from a stored procedure in a SQL Expression, because it can't pass that SQL Expression back to the server, this would mean dynamically rewriting the SP. There are ways of doing similar things whil designing an SP, but they're not applicable here.

If you have a function required against a BLOB (or truncating it as Ro suggests), do it in the SP, it's faster anyway.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com