I am SSRS BIS for SQL 2008. I have created a very simple report based on the query SELECT fgimage FROM inmast WHERE (fpartno = 'PD11733 ') This query returns one record. fgimage has the data type of image. In it is a bit map image that is < 1 meg in size. The image displays fine in Made2Manage (the program the database was written for). I have tried other records and have the same issue with them, so I don't believe the data is corupted. I have created an image in the report image source: database Use this Field: [fgimage] MIME Type: image/bmp I receive no errors or warnings when I build the report. When I try to preview it inside of Bis I get "An error occured durring client rendering. Perameter is not valid.". When I run it through the browser I get a red X instead of the picture. I am very new to SSRS so please make your replies accordingly. Thank you, Scott

Can you try the steps in the blog below http://road-blogs.blogspot.com/2010/04/ssrs-reports-using-database-images.htmlCheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Thanks for the quick reply. The link refers to 2005 not 2008. Additionally it uses a data type of VARBINARY instead of image. My settings to display the picture seem to be the same as thiers.

http://www.kodyaz.com/articles/display-database-image-using-sql-server-2008-reporting-services.aspx This blog will give the steps for 2008, but the data type is still varbinary i guessCheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Following is one (good) way of storing images in the database: CREATE TABLE ProductPhoto( ProductPhotoID int IDENTITY(1,1) PRIMARY KEY ThumbNailPhoto varbinary(max) NULL, ThumbnailPhotoFileName nvarchar(50) NULL, LargePhoto varbinary(max) NULL, LargePhotoFileName nvarchar(50) NULL, ModifiedDate datetime NOT NULL) Image export/import link: http://www.sqlusa.com/bestpractices/imageimportexport/ Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

I can not change the way the data is stored in the database. The database was designed to work with a single program (Made2Manage). I don't need assistance in storing the data, only in retrieving it into SSRS. Using a 3rd party program to retrieve the information into SSRS seems overly complicated and expensive. The functionality I need should and does appear to be built into SSRS. I am just not using it correctly.

Hi Scott, From the error message, the issue is on your report parameter instead of image rendering. The image process seemed to be right. So, please check why the report says the parameter is not valid? 1. Does the query work in SSMS query box? 2. Have you define any report parameter? if yes, how? thanks, Jerry

The query works in SSMS and in the Query Designer. The report has no perameters. Thanks, Scott

Any progress?Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training

None. I have however moved on to other reports for the time being.