how to show binary data in report

I want to display the content stored in image column. Can anyone tell me how?
The content is actually XML text, encoded and stored in a image type.This link should help you.
http://msdn2.microsoft.com/en-us/library/aa179439(SQL.80).aspx
Also if you have the Sample Reports installed the Product Catalog report
shows you how to do this.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Jason Wang" <JasonWang@.discussions.microsoft.com> wrote in message
news:2D1F3430-D9B7-499D-B77E-0CF6DC464F21@.microsoft.com...
>I want to display the content stored in image column. Can anyone tell me
>how?
> The content is actually XML text, encoded and stored in a image type.

How to set up search on text stored in an image type of data?

I am saving large text document in an image type of column in a SQL Server 2000 table.

How will I set up searching of words/ phrases for data stored in this column?

what type of documents are they? If it is just plaintext you really should store it in an nvarhcar(max) field instead. That way you can use SQL queries to search the text.

|||

But nvarchar has a length problem. If it's a word document that is stored and this doc's length is greater than varchar max size, then we have to use image or ntext datatype. Because of this I have to use image data type.

|||

That's going to be a challenge because the image data type is storing a byte array so i'm not sure if it is possible to search it without first pulling it down and manipulating it in your code behind.

how to set image as background image to report

i want to set background image to report can any one tell how to set to whole report. i can set image to header, fotter, details, etc but cannot set for whole reportif you have CR XI, there are some examples of templates, one of the templates is a confidential underlay. That is a least one way to do this. also look for underlay following sections (in section expert) add your graphic to a page header, and select underlay following sections.|||Try this:
Insert another Page Header section (PHb), expand this new section that it would be the size of your page. Place your picture in the center of the PHb.
Then in the Section Expert, select the PHb section and check the "Underlay Following Sections".