Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

Sunday, 16 December 2012

image/pjpeg vs. image/jpg MIME types

If you got into this nasty issue that IE uploads your jpeg images as pjpeg (progressive jpeg).

My solution was just to ignore it when displaying it, since for instance I was displaying it on an rdlc report which does not support pjpeg


SELECT 
   CASE WHEN U.SignatureContentType = 'image/pjpeg'
       THEN 'image/jpeg' ELSE U.SignatureContentType END SignatureContentType,
   U.SignatureFileContent,..........



Another screaming developer from this issue ;)
http://www.zigpress.com/2010/01/14/non-standard-imagepjpeg-mimetype-on-ie

Thursday, 13 December 2012

ASP.NET: Display an image from database within rdlc report using Report Viewer

1) Make sure that the image in the DB (MS SQL Server):



FileContentType nvarchar(255)
FileContent varbinary(MAX)


2) Load the dataset with the above columns within your Dataset.

3) Add an "Image" report item to the rdlc report file to display the image:


Please refer to this post if you are having an issue with pjpeg MIME types:
http://afsawaf.blogspot.com/2012/12/imagepjpeg-vs-imagejpg-mime-types.html

Sunday, 21 October 2012

SSRS: Show \ Hide chart gridlines


Right click the axis for which you would like to show\hide the grid-lines:

Context menu will display:
        Show Major Gridlines
        Show Minor Gridlines