Images With Custom DataSet Passed To SSRS Not Displaying

Hi,

I'm developing an ASP.NET application that creates on-demand reports with Reporting Services 2005 in report server.
I use a custom data set that contains the data that I want to bind to the report, and I use a WebService to pass that DataSet to the reporting services to accomplish my purpose.

The query passed to the reporting services is:

<Query>
<Method Namespace=http://myNameSpace.com Name="GetDataSetForReport"/> <SoapAction>http://myNameSpace.com/WebService/GetDataSetForReport</SoapAction>
<ElementPath IgnoreNamespaces="True">GetDataSetForReportResponse{}/GetDataSetForReportResult{}/diffgram{}/ReportDataSet{}/MyTable{Fields1,Fields2,Fields3,..,FieldsN,Image}</ElementPath>
</Query>

This works well and all the fields are displayed in the report fine except the Image Fields, that are not showing (the red X appears instead of the image).

The issue is that all the data that is bind to the dataset is contained in a SQL Server 2005 database, and the Image column in the table of that database is a VARBINARY(MAX) field (I insert the image into the database table).

Also, when I created the dataset in .NET, the column type of the dataset I declared for the Image field was Byte[], but that didn't work for me. I've also tried to declare as the field type Byte,SqlByte,Image,SqlBinary, etc without succesfull results.

I've also tried creating a XML Schema, declaring the Image field as base64Binary, then do DataSet.ReadXMLSchema(myschema) and then retrievied the data from sql server and filled the dataset, Again, the Images doesn`t display.

For finnishing my unsatisfactory tests, I've also tried to handle the image data with a MemoryStream object:


MemoryStream mem = new MemoryStream();
MemoryStream oStream = new MemoryStream();


mem.Write((Byte[])dr["Image"],0 , ((Byte[])dr["Image"]).Length); //dr is the datareader used to read from the DB


Image image = Image.FromStream(mem);

try

{


image.Save(oStream, ImageFormat.Png);

}

catch{}


newRow["Image"] = oStream.GetBuffer(); //newRow is a row of the custom DataSet.Table passed to the SSRS.


But again, the Image is not showing.

Any suggestions?


Thanks for you time.