Images and PDF Export POST SP2

I've come accross the same problem having also installed SP2. Still looking
for the answer.
I did notice that exporting via the preview window in Visual Studio works
perfectly. It's only exporting to pdf via a browser that causes the
scrambled images.
Does anyone have a work around, besides changing every report to read a png
image? We still need transparency.
Ryan
>On Follow Up.. this appears to be images other than JPEG's, which according
>to documentation are all rendered as PNG's.
>"Rob Johnson" wrote:
>> After installing RS SP2, images included in my reports display fine in
>> HTML
>> View, Excel View and TIFF View, but when exported to PDF they are not
>> displaying properly (they appear garbled, much like a scrambled TV
>> signal).
>>
>> Any ideas or thoughts?Same issue here, although my image is being converted at runtime to png via a
.Net assembly. I get the same results through the browser and VS IDE.
"Ryan Opfer" wrote:
> I've come accross the same problem having also installed SP2. Still looking
> for the answer.
> I did notice that exporting via the preview window in Visual Studio works
> perfectly. It's only exporting to pdf via a browser that causes the
> scrambled images.
> Does anyone have a work around, besides changing every report to read a png
> image? We still need transparency.
> Ryan
> >On Follow Up.. this appears to be images other than JPEG's, which according
> >to documentation are all rendered as PNG's.
> >"Rob Johnson" wrote:
> >> After installing RS SP2, images included in my reports display fine in
> >> HTML
> >> View, Excel View and TIFF View, but when exported to PDF they are not
> >> displaying properly (they appear garbled, much like a scrambled TV
> >> signal).
> >>
> >> Any ideas or thoughts?
>
>|||I use a custom centering/scaling function as the data source for my image
control. Converting the function's output to either GIF or JPEG eliminated
the problem for me. I have my image control's format set to JPEG. The
problem appears for me when the function's output is set to PNG.
"Ryan Opfer" wrote:
> I've come accross the same problem having also installed SP2. Still looking
> for the answer.
> I did notice that exporting via the preview window in Visual Studio works
> perfectly. It's only exporting to pdf via a browser that causes the
> scrambled images.
> Does anyone have a work around, besides changing every report to read a png
> image? We still need transparency.
> Ryan
> >On Follow Up.. this appears to be images other than JPEG's, which according
> >to documentation are all rendered as PNG's.
> >"Rob Johnson" wrote:
> >> After installing RS SP2, images included in my reports display fine in
> >> HTML
> >> View, Excel View and TIFF View, but when exported to PDF they are not
> >> displaying properly (they appear garbled, much like a scrambled TV
> >> signal).
> >>
> >> Any ideas or thoughts?
>
>|||I've tried a couple of images and didn't see PNG corruption when exporting
to PDF. Would one of you please email me a sample PNG that is exhibiting
this behavior so I can take a look? Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>I use a custom centering/scaling function as the data source for my image
> control. Converting the function's output to either GIF or JPEG
> eliminated
> the problem for me. I have my image control's format set to JPEG. The
> problem appears for me when the function's output is set to PNG.
> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>|||We don't currently support true color w/alpha PNG files, only indexed color
(color type 3). If your graphics editing program allows you to specify the
color type of your PNG and save it as a type 3 file you should be fine.
Prior to SP2, we converted all images to bitmaps which bloated the PDF file.
We now compress but have less flexibility on certain image types.
I've opened a bug for this issue so we can hopefully get it fixed in Yukon.
The easiest work-around for our SQL Server 2000 release is to save as a type
3 file or use a jpg.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
> Thanks Donovan for looking into this. Here is our logo
> (logoRenderedFromBrowser.png). It was originally a GIF image but when
> rendered to the browser it becomes a png image (perhaps a reason why we
> can export to PDF via visual studio but not from the browser). Also
> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
> directly after export to pdf via the browser.
> Again, prior to SP2 all reports exported as expected via the browser to
> pdf. One can only assume that there's been a change with sp2.
> Thanks in advance,
> Ryan
>
> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG. The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine
>> >> in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>
>|||Thanks Donovan for the information. I was in error when I had said that we
were originally using a GIF image and that RS was converting it when
rendering for the browser. We are indeed using png files at 24 bit.
I did save the image as png-8 (which I assume is color type 3) which does
fix this problem--although it's lousy quality.
So thanks again for the solution/work around.
Ryan
It is interesting though that you mention that RS doesn't currently support
true color w/alpha PNG files. I'm not even using PNG, it's RS that is
converting it to
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
> We don't currently support true color w/alpha PNG files, only indexed
> color (color type 3). If your graphics editing program allows you to
> specify the color type of your PNG and save it as a type 3 file you should
> be fine. Prior to SP2, we converted all images to bitmaps which bloated
> the PDF file. We now compress but have less flexibility on certain image
> types.
> I've opened a bug for this issue so we can hopefully get it fixed in
> Yukon. The easiest work-around for our SQL Server 2000 release is to save
> as a type 3 file or use a jpg.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG. The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read
>> a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display fine
>> >> in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>>
>>
>|||Ah, OK. I couldn't quite understand the GIF part of your message. :)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
news:ep6g6EAXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> Thanks Donovan for the information. I was in error when I had said that
> we were originally using a GIF image and that RS was converting it when
> rendering for the browser. We are indeed using png files at 24 bit.
> I did save the image as png-8 (which I assume is color type 3) which does
> fix this problem--although it's lousy quality.
> So thanks again for the solution/work around.
> Ryan
> It is interesting though that you mention that RS doesn't currently
> support true color w/alpha PNG files. I'm not even using PNG, it's RS
> that is converting it to
> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> We don't currently support true color w/alpha PNG files, only indexed
>> color (color type 3). If your graphics editing program allows you to
>> specify the color type of your PNG and save it as a type 3 file you
>> should be fine. Prior to SP2, we converted all images to bitmaps which
>> bloated the PDF file. We now compress but have less flexibility on
>> certain image types.
>> I've opened a bug for this issue so we can hopefully get it fixed in
>> Yukon. The easiest work-around for our SQL Server 2000 release is to save
>> as a type 3 file or use a jpg.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
>> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG.
>> The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>> I've come accross the same problem having also installed SP2. Still
>> looking
>> for the answer.
>> I did notice that exporting via the preview window in Visual Studio
>> works
>> perfectly. It's only exporting to pdf via a browser that causes the
>> scrambled images.
>> Does anyone have a work around, besides changing every report to read
>> a
>> png
>> image? We still need transparency.
>> Ryan
>> >On Follow Up.. this appears to be images other than JPEG's, which
>> >according
>> >to documentation are all rendered as PNG's.
>> >"Rob Johnson" wrote:
>> >> After installing RS SP2, images included in my reports display
>> >> fine in
>> >> HTML
>> >> View, Excel View and TIFF View, but when exported to PDF they are
>> >> not
>> >> displaying properly (they appear garbled, much like a scrambled TV
>> >> signal).
>> >>
>> >> Any ideas or thoughts?
>>
>>
>>
>>
>>
>|||One more export issue. When exporting to pdf using the 8 bit png image
(color type 3) from the browser, transparency doesn't work (and it use to
under SP1). As proof that the image is transparent, I can print using the
new print button and transparency works fine. Also when exporting to pdf
via Visual Studio transparency works fine as well (of course so did the 24
bit png).
At least it's not scrambled though!
Ryan
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:%23MmyV8AXFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Ah, OK. I couldn't quite understand the GIF part of your message. :)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
> news:ep6g6EAXFHA.3348@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for the information. I was in error when I had said that
>> we were originally using a GIF image and that RS was converting it when
>> rendering for the browser. We are indeed using png files at 24 bit.
>> I did save the image as png-8 (which I assume is color type 3) which does
>> fix this problem--although it's lousy quality.
>> So thanks again for the solution/work around.
>> Ryan
>> It is interesting though that you mention that RS doesn't currently
>> support true color w/alpha PNG files. I'm not even using PNG, it's RS
>> that is converting it to
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:eXILSR1WFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> We don't currently support true color w/alpha PNG files, only indexed
>> color (color type 3). If your graphics editing program allows you to
>> specify the color type of your PNG and save it as a type 3 file you
>> should be fine. Prior to SP2, we converted all images to bitmaps which
>> bloated the PDF file. We now compress but have less flexibility on
>> certain image types.
>> I've opened a bug for this issue so we can hopefully get it fixed in
>> Yukon. The easiest work-around for our SQL Server 2000 release is to
>> save as a type 3 file or use a jpg.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ryan Opfer" <ropfer@.usa.ibs.org> wrote in message
>> news:%23IailDwWFHA.3584@.TK2MSFTNGP14.phx.gbl...
>> Thanks Donovan for looking into this. Here is our logo
>> (logoRenderedFromBrowser.png). It was originally a GIF image but when
>> rendered to the browser it becomes a png image (perhaps a reason why we
>> can export to PDF via visual studio but not from the browser). Also
>> attached is the scrambled logo (scrambledImage.jpg) screen shot taken
>> directly after export to pdf via the browser.
>> Again, prior to SP2 all reports exported as expected via the browser to
>> pdf. One can only assume that there's been a change with sp2.
>> Thanks in advance,
>> Ryan
>>
>> "Donovan Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
>> news:%23b0JjJnWFHA.2256@.TK2MSFTNGP14.phx.gbl...
>> I've tried a couple of images and didn't see PNG corruption when
>> exporting
>> to PDF. Would one of you please email me a sample PNG that is
>> exhibiting
>> this behavior so I can take a look? Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ken Fox" <KenFox@.discussions.microsoft.com> wrote in message
>> news:DF0704F5-B6DF-4BEF-A042-0DE8D7E0F30D@.microsoft.com...
>>I use a custom centering/scaling function as the data source for my
>>image
>> control. Converting the function's output to either GIF or JPEG
>> eliminated
>> the problem for me. I have my image control's format set to JPEG.
>> The
>> problem appears for me when the function's output is set to PNG.
>> "Ryan Opfer" wrote:
>>> I've come accross the same problem having also installed SP2. Still
>>> looking
>>> for the answer.
>>>
>>> I did notice that exporting via the preview window in Visual Studio
>>> works
>>> perfectly. It's only exporting to pdf via a browser that causes the
>>> scrambled images.
>>>
>>> Does anyone have a work around, besides changing every report to
>>> read a
>>> png
>>> image? We still need transparency.
>>>
>>> Ryan
>>> >On Follow Up.. this appears to be images other than JPEG's, which
>>> >according
>>> >to documentation are all rendered as PNG's.
>>>
>>> >"Rob Johnson" wrote:
>>>
>>> >> After installing RS SP2, images included in my reports display
>>> >> fine in
>>> >> HTML
>>> >> View, Excel View and TIFF View, but when exported to PDF they are
>>> >> not
>>> >> displaying properly (they appear garbled, much like a scrambled
>>> >> TV
>>> >> signal).
>>> >>
>>> >> Any ideas or thoughts?
>>>
>>>
>>>
>>
>>
>>
>>
>

Image From DB - There but not there

Tribe,
I'm struggling with the poorly implemented image handling in SSRS
(which is represented through ASP.NET via
Microsoft.Reporting.WebForms)
First off, SSRS/Reporting team - External Images should mean exactly
that. The report should express EXACTLY what I enter into the Value
field for an External type image in a report. The fact that the engine
interprets and munges this field is an utter travesty. If I enter "/
myDBImageDumper.aspx" this text is what should be expressed out
through the Web report viewer. Period. The use of this property
"UnattendedExecutionAccount" in order to allow the report engine to
render local images is a complete and total hack
Now, in dealing with a simple database supplied image in the reporting
body of a report, I've got an Image type field in a SQLExpress table.
I've loaded this field through a web FileUpload and stored the bytes
in the field. I can render these bytes out through a web page by using
the Response.WriteBinary(reader[IMAGEFIELDPOS]);
I mention this as I know that the image now in the database in the
correct mime format (jpeg).
So, back to the report. I've added an image field to the body of the
report (I want it in the header by alas that is also an
impossibility). To this field I've assigned the mime type "image/
jpeg", the Source of Database, and a Value of:
=System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
"InvoiceHeader_InvoiceHeader")
And of course the image does not render.
Adding that same value to a text field however allows the Base64 to
get dumped out in to that field. Which proves the data is there.
However, I'm baffled as to how to get this image to show up.
Clues anyone
DCTribe,
I lied. I can get the image to show up in the body of the report by
using just the straight byte dump:
=First(Fields!UserCompanyImage.Value, "InvoiceHeader_InvoiceHeader")
But what I'm really trying to do is to get the image up in the header.
So I've got another identical image up in the header and I've got its
Value set to :
=Reportitems!imageLogo.Value
Where imageLogo is the name of the first, body of the report, image.
The header image does not render.
Clues 2?
DC
On Oct 8, 2:44 pm, bangeye <davecl...@.gmail.com> wrote:
> Tribe,
> I'm struggling with the poorly implemented image handling in SSRS
> (which is represented through ASP.NET via
> Microsoft.Reporting.WebForms)
> First off, SSRS/Reporting team - External Images should mean exactly
> that. The report should express EXACTLY what I enter into the Value
> field for an External type image in a report. The fact that the engine
> interprets and munges this field is an utter travesty. If I enter "/
> myDBImageDumper.aspx" this text is what should be expressed out
> through the Web report viewer. Period. The use of this property
> "UnattendedExecutionAccount" in order to allow the report engine to
> render local images is a complete and total hack
> Now, in dealing with a simple database supplied image in the reporting
> body of a report, I've got an Image type field in a SQLExpress table.
> I've loaded this field through a web FileUpload and stored the bytes
> in the field. I can render these bytes out through a web page by using
> the Response.WriteBinary(reader[IMAGEFIELDPOS]);
> I mention this as I know that the image now in the database in the
> correct mime format (jpeg).
> So, back to the report. I've added an image field to the body of the
> report (I want it in the header by alas that is also an
> impossibility). To this field I've assigned the mime type "image/
> jpeg", the Source of Database, and a Value of:
> =System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
> "InvoiceHeader_InvoiceHeader")
> And of course the image does not render.
> Adding that same value to a text field however allows the Base64 to
> get dumped out in to that field. Which proves the data is there.
> However, I'm baffled as to how to get this image to show up.
> Clues anyone
> DC|||Tribe,
Here's the trick (what a mess)
In order to get a dynamic JPEG image out of your database and into the
header of your report you must:
Add a textfield to the body of your report.
Assign the value of that textfield (call this text field
txtImageData):
= Convert.ToBase64String(Fields!MyImageStreamField)
Add an image type to your report header.
Assign the Mime type to image/jpeg and the Source to Database
Assign the value to :
= Convert.FromBase64String(ReportItems!txtImageData.Value)
Your image will then have the byte data that was originally in your
image column in your database table.
DC
On Oct 8, 3:04 pm, bangeye <davecl...@.gmail.com> wrote:
> Tribe,
> I lied. I can get the image to show up in the body of the report by
> using just the straight byte dump:
> =First(Fields!UserCompanyImage.Value, "InvoiceHeader_InvoiceHeader")
> But what I'm really trying to do is to get the image up in the header.
> So I've got another identical image up in the header and I've got its
> Value set to :
> =Reportitems!imageLogo.Value
> Where imageLogo is the name of the first, body of the report, image.
> The header image does not render.
> Clues 2?
> DC
> On Oct 8, 2:44 pm, bangeye <davecl...@.gmail.com> wrote:
> > Tribe,
> > I'm struggling with the poorly implemented image handling in SSRS
> > (which is represented through ASP.NET via
> > Microsoft.Reporting.WebForms)
> > First off, SSRS/Reporting team - External Images should mean exactly
> > that. The report should express EXACTLY what I enter into the Value
> > field for an External type image in a report. The fact that the engine
> > interprets and munges this field is an utter travesty. If I enter "/
> > myDBImageDumper.aspx" this text is what should be expressed out
> > through the Web report viewer. Period. The use of this property
> > "UnattendedExecutionAccount" in order to allow the report engine to
> > render local images is a complete and total hack
> > Now, in dealing with a simple database supplied image in the reporting
> > body of a report, I've got an Image type field in a SQLExpress table.
> > I've loaded this field through a web FileUpload and stored the bytes
> > in the field. I can render these bytes out through a web page by using
> > the Response.WriteBinary(reader[IMAGEFIELDPOS]);
> > I mention this as I know that the image now in the database in the
> > correct mime format (jpeg).
> > So, back to the report. I've added an image field to the body of the
> > report (I want it in the header by alas that is also an
> > impossibility). To this field I've assigned the mime type "image/
> > jpeg", the Source of Database, and a Value of:
> > =System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
> > "InvoiceHeader_InvoiceHeader")
> > And of course the image does not render.
> > Adding that same value to a text field however allows the Base64 to
> > get dumped out in to that field. Which proves the data is there.
> > However, I'm baffled as to how to get this image to show up.
> > Clues anyone
> > DC

IIS6 connect to sql server on another machine w/windows authentication

Can someone point me at an article that tells how to allow theASP.net worker process to connect, via windows authentication, to aremote sql server instance ?

Start with:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000008.asp

The remote server access is in the connection string, specifying server and instance.

Jeff

|||

Also make sure remote connections enabled on the remote SQL instnace. Check this KB:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277