Monday, February 27, 2012

HELP!

Using SQL 2000 with SP1 installed, Just doing some examples with northwind, when I try to create a report with the images stored in the Categories table, I get the red X's that show when there isn't a valid image. When I pull the data into access and view the pics they show. Any advice?You'd have to convert the image to Base64 encoding. Try this:
=System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
cture.Value), 105))
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian B" <Brian B@.discussions.microsoft.com> wrote in message
news:4292B678-BED0-4BCE-9B3B-923B1684A02F@.microsoft.com...
> Using SQL 2000 with SP1 installed, Just doing some examples with
northwind, when I try to create a report with the images stored in the
Categories table, I get the red X's that show when there isn't a valid
image. When I pull the data into access and view the pics they show. Any
advice?

No comments:

Post a Comment