Imbedded charts in SQL Reporting

Can any third party charting tools be embedded within SQL Reports?
If so, is the Enterprise version of SQL Reporting required? We are
interested in developing a ASP.NET web site which has SQL Reports in it.
Those reports need charts embedded in them and the charts go beyond the
default charts shipped with the Standard Edition of SQL Reporting Services.Have a look at the following sites and go through their documentation. You
may have to research on pricing, development time etc...
http://www.cizer.com/portalcsvs/DesktopDefault.aspx
http://www.dundas.com/products/casestudies/index.aspx?Section=CaseStudies&Campaign=ReportingServi
Good luck!
Rajesh Meenrajan
MCSD.NET
http://meenrajan.blogspot.com
"bteclt" wrote:
> Can any third party charting tools be embedded within SQL Reports?
> If so, is the Enterprise version of SQL Reporting required? We are
> interested in developing a ASP.NET web site which has SQL Reports in it.
> Those reports need charts embedded in them and the charts go beyond the
> default charts shipped with the Standard Edition of SQL Reporting Services.

Images on a report

Hi being new to reporting services this is probably simple, so here goes.

Using Visual Studio 2005 to create the report. I have a SQLExpress db.

In the Product table that I want to run the report on there is a field called ImageName it contains the image filename e.g CanonIXUS.jpg

and I have a directory with all the images in it.

So how do I get the report writer to show the Image for the product in the row?

Thanks

Please check the documentation:
http://msdn2.microsoft.com/en-us/library/ms156482(SQL.90).aspx

In your case, it sounds like you want to add an "external" image where you will need to dynamically construct the path with an expression.

-- Robert

|||

Hi,

Thanks for that.

However all the documentation talks of an image wizard and various properties when you drag an image control onto a report.

Unfortunatly after adding a report (test.rdlc) to my VS2005 project none of these options seem to be available to me. I can easily display data but I don't have a place to select the various properties for an image eg. "external" .

Any Ideas ?

|||

You can use the VS property browser to set the image properties. To set the source of an image to "external", select the image, go to the Properties window and locate the Source property.

-Albert

Images on a report

Hi being new to reporting services this is probably simple, so here goes.

Using Visual Studio 2005 to create the report. I have a SQLExpress db.

In the Product table that I want to run the report on there is a field called ImageName it contains the image filename e.g CanonIXUS.jpg

and I have a directory with all the images in it.

So how do I get the report writer to show the Image for the product in the row?

Thanks

Please check the documentation:
http://msdn2.microsoft.com/en-us/library/ms156482(SQL.90).aspx

In your case, it sounds like you want to add an "external" image where you will need to dynamically construct the path with an expression.

-- Robert

|||

Hi,

Thanks for that.

However all the documentation talks of an image wizard and various properties when you drag an image control onto a report.

Unfortunatly after adding a report (test.rdlc) to my VS2005 project none of these options seem to be available to me. I can easily display data but I don't have a place to select the various properties for an image eg. "external" .

Any Ideas ?

|||

You can use the VS property browser to set the image properties. To set the source of an image to "external", select the image, go to the Properties window and locate the Source property.

-Albert

sql

Images in Reporting Services from database

I have a data table which contains a bmp image saved as a byte array. I am trying to have this image presented in a report, however, I get a red X after I follow the wizard.

I also tried it with the SQL Northwind database and I have the same issue. I am running SQL Reporting services 2005. Any suggestions on what could be going wrong?

Joe

after placing the image you have select the image source i.e. database in your case and then you have select the field name which contains image and the MIME type as image/bmp or try image/png.

this should work

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any ideal what's wrong?

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any idea what's wrong?

|||Please read this RS BOL topic: http://msdn2.microsoft.com/en-us/library/ms156342(SQL.90).aspx

Particularly read the comment near the top if the images came originally from an Access database, because in that case the actual image data is an OLE image and you have to write an expression to remove the OLE image header from the data. This also applies to the Northwind sample database.

Furthermore, I recommend to install SQL Server 2005 SP1 for Reporting Services.

-- Robert

sql

Images in Reporting Services from database

I have a data table which contains a bmp image saved as a byte array. I am trying to have this image presented in a report, however, I get a red X after I follow the wizard.

I also tried it with the SQL Northwind database and I have the same issue. I am running SQL Reporting services 2005. Any suggestions on what could be going wrong?

Joe

after placing the image you have select the image source i.e. database in your case and then you have select the field name which contains image and the MIME type as image/bmp or try image/png.

this should work

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any ideal what's wrong?

|||

I have tried with both image/bmp and image/png on northwind DB as recommended. I still get red cross. Any idea what's wrong?

|||Please read this RS BOL topic: http://msdn2.microsoft.com/en-us/library/ms156342(SQL.90).aspx

Particularly read the comment near the top if the images came originally from an Access database, because in that case the actual image data is an OLE image and you have to write an expression to remove the OLE image header from the data. This also applies to the Northwind sample database.

Furthermore, I recommend to install SQL Server 2005 SP1 for Reporting Services.

-- Robert

images in HTML reports

How to render image in HTML reports?
I have a webapp which invokes Reporting Services web service to generate
reports in HTML format. The reports are for internet users - the image is not
accessible to these internet users because they cannot access the report
server directly which is in the intranet. Is there a solution to this problem
at all?
Thanks
SanjayYes, although it is not simple. You need to use the RenderStream method to
get the image and put it in a place where it is available to the Internet
users. You need to pass this path into the initial Render() call using the
<StreamRoot> deviceInfo.
For what it is worth, this will be much easier in SQL 2005 RS.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> How to render image in HTML reports?
> I have a webapp which invokes Reporting Services web service to generate
> reports in HTML format. The reports are for internet users - the image is
> not
> accessible to these internet users because they cannot access the report
> server directly which is in the intranet. Is there a solution to this
> problem
> at all?
> Thanks
> Sanjay|||That works for me for the intranet users but not for the internet users
because the location where I can generate the image with RenderStream is not
available on internet.
Including an External Web image could work for me because I'm including the
same banner image in my reports, but when I tried to include an External Web
Image like
http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
in my report in report designer, I got message 'Invalid Image'. Is that
expected or is it because of some restrictions in my environment?
Thanks
Sanjay
"Brian Welcker [MS]" wrote:
> Yes, although it is not simple. You need to use the RenderStream method to
> get the image and put it in a place where it is available to the Internet
> users. You need to pass this path into the initial Render() call using the
> <StreamRoot> deviceInfo.
> For what it is worth, this will be much easier in SQL 2005 RS.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> > How to render image in HTML reports?
> > I have a webapp which invokes Reporting Services web service to generate
> > reports in HTML format. The reports are for internet users - the image is
> > not
> > accessible to these internet users because they cannot access the report
> > server directly which is in the intranet. Is there a solution to this
> > problem
> > at all?
> >
> > Thanks
> > Sanjay
>
>|||All images in the reports are effectively "internal". URL only means that
the Report Server retrieves the image from a URL. We need to actually store
the image for consistency (caching, snapshots, etc.). We don't have a 'late
bound' image.
I don't understand why you can't copy the image to a directory on the
external web site.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> That works for me for the intranet users but not for the internet users
> because the location where I can generate the image with RenderStream is
> not
> available on internet.
> Including an External Web image could work for me because I'm including
> the
> same banner image in my reports, but when I tried to include an External
> Web
> Image like
> http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> in my report in report designer, I got message 'Invalid Image'. Is that
> expected or is it because of some restrictions in my environment?
> Thanks
> Sanjay
> "Brian Welcker [MS]" wrote:
>> Yes, although it is not simple. You need to use the RenderStream method
>> to
>> get the image and put it in a place where it is available to the Internet
>> users. You need to pass this path into the initial Render() call using
>> the
>> <StreamRoot> deviceInfo.
>> For what it is worth, this will be much easier in SQL 2005 RS.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> > How to render image in HTML reports?
>> > I have a webapp which invokes Reporting Services web service to
>> > generate
>> > reports in HTML format. The reports are for internet users - the image
>> > is
>> > not
>> > accessible to these internet users because they cannot access the
>> > report
>> > server directly which is in the intranet. Is there a solution to this
>> > problem
>> > at all?
>> >
>> > Thanks
>> > Sanjay
>>|||I can't copy the image to a directory on the external web site because I
don't have access to the report server from the external web site machine as
a result of which I have an intermediate ReportsGeneratorService sitting in
the intranet which generates the reports. In addition I don't have access to
create image files on the external web site machine from the intranet-sitting
ReportsGeneratorService. For Security Reasons. Any suggestions?
Can I manipulate the HTML on the external web-site to pick up the images
from a location in the external web-site?
"Brian Welcker [MS]" wrote:
> All images in the reports are effectively "internal". URL only means that
> the Report Server retrieves the image from a URL. We need to actually store
> the image for consistency (caching, snapshots, etc.). We don't have a 'late
> bound' image.
> I don't understand why you can't copy the image to a directory on the
> external web site.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
> > That works for me for the intranet users but not for the internet users
> > because the location where I can generate the image with RenderStream is
> > not
> > available on internet.
> > Including an External Web image could work for me because I'm including
> > the
> > same banner image in my reports, but when I tried to include an External
> > Web
> > Image like
> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
> > in my report in report designer, I got message 'Invalid Image'. Is that
> > expected or is it because of some restrictions in my environment?
> >
> > Thanks
> > Sanjay
> > "Brian Welcker [MS]" wrote:
> >
> >> Yes, although it is not simple. You need to use the RenderStream method
> >> to
> >> get the image and put it in a place where it is available to the Internet
> >> users. You need to pass this path into the initial Render() call using
> >> the
> >> <StreamRoot> deviceInfo.
> >>
> >> For what it is worth, this will be much easier in SQL 2005 RS.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
> >> > How to render image in HTML reports?
> >> > I have a webapp which invokes Reporting Services web service to
> >> > generate
> >> > reports in HTML format. The reports are for internet users - the image
> >> > is
> >> > not
> >> > accessible to these internet users because they cannot access the
> >> > report
> >> > server directly which is in the intranet. Is there a solution to this
> >> > problem
> >> > at all?
> >> >
> >> > Thanks
> >> > Sanjay
> >>
> >>
> >>
>
>|||Yes, this is what StreamRoot is for. You can put whatever location you want
for picking up the images in the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:23B5C014-89AB-41AA-8A33-C9CA8381D0AB@.microsoft.com...
>I can't copy the image to a directory on the external web site because I
> don't have access to the report server from the external web site machine
> as
> a result of which I have an intermediate ReportsGeneratorService sitting
> in
> the intranet which generates the reports. In addition I don't have access
> to
> create image files on the external web site machine from the
> intranet-sitting
> ReportsGeneratorService. For Security Reasons. Any suggestions?
> Can I manipulate the HTML on the external web-site to pick up the images
> from a location in the external web-site?
> "Brian Welcker [MS]" wrote:
>> All images in the reports are effectively "internal". URL only means that
>> the Report Server retrieves the image from a URL. We need to actually
>> store
>> the image for consistency (caching, snapshots, etc.). We don't have a
>> 'late
>> bound' image.
>> I don't understand why you can't copy the image to a directory on the
>> external web site.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:FEC10F8E-F9C2-4938-9F16-3E3565EA723C@.microsoft.com...
>> > That works for me for the intranet users but not for the internet users
>> > because the location where I can generate the image with RenderStream
>> > is
>> > not
>> > available on internet.
>> > Including an External Web image could work for me because I'm including
>> > the
>> > same banner image in my reports, but when I tried to include an
>> > External
>> > Web
>> > Image like
>> > http://msdn.microsoft.com/library/toolbar/3.0/images/banners/msdn_masthead_ltr.gif
>> > in my report in report designer, I got message 'Invalid Image'. Is that
>> > expected or is it because of some restrictions in my environment?
>> >
>> > Thanks
>> > Sanjay
>> > "Brian Welcker [MS]" wrote:
>> >
>> >> Yes, although it is not simple. You need to use the RenderStream
>> >> method
>> >> to
>> >> get the image and put it in a place where it is available to the
>> >> Internet
>> >> users. You need to pass this path into the initial Render() call using
>> >> the
>> >> <StreamRoot> deviceInfo.
>> >>
>> >> For what it is worth, this will be much easier in SQL 2005 RS.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> >> news:1A5971D1-5DB8-4B28-8AB1-38DFC1E1C25D@.microsoft.com...
>> >> > How to render image in HTML reports?
>> >> > I have a webapp which invokes Reporting Services web service to
>> >> > generate
>> >> > reports in HTML format. The reports are for internet users - the
>> >> > image
>> >> > is
>> >> > not
>> >> > accessible to these internet users because they cannot access the
>> >> > report
>> >> > server directly which is in the intranet. Is there a solution to
>> >> > this
>> >> > problem
>> >> > at all?
>> >> >
>> >> > Thanks
>> >> > Sanjay
>> >>
>> >>
>> >>
>>

Images do not display in Reporting Sevices on Windows 2003 Server

Hi,
I have reporting services installed on windows 2003 server.
Embedded Images do display in designer preview, but they do not display in
Report Manager or browser. When I use localhost instead of my machine name in
report url, then images are displayed. I have installed service pack 1 & 2
for RS. After that I installed SP4 for SQL Server. Can some body help in this
regard?
Thanks in anticipation.Hi
Following issue is resolved.
Please look at following link. "_" in the machine name is the
culprit. I used the IP and it worked fine. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Saeed Ahmad" wrote:
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in this
> regard?
> Thanks in anticipation.
>|||I've narrowed this down a bit. It seems to happen only with line art no
matter what file format your using (png, gif etc.) The only way I've found
around it (which isn't acceptable in my opinion) is to use the "fit"
parameter for the image.
From what I've read - RS sends a jscript to resize image in browser. I'm
guessing it fails to work because it is line art.
"Saeed Ahmad" <Saeed Ahmad@.discussions.microsoft.com> wrote in message
news:B47ABB44-24D6-433D-A621-9DCBE48690C1@.microsoft.com...
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name
> in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in
> this
> regard?
> Thanks in anticipation.
>sql

Images are not showing in the report.

new bie to sql server reporting here.

I have made a report here in Sql server Reporting and added a picture in the header of report.

Picture type is embeded in the report.

when i run the report by using Webservice of report server. in my asp.net web application all the contents of the reports are showing fine. but not picture ,,picture is missing there .

i am unable to find tha error.

kind help me to solve this solution

Thanks

ASIF

Make sure the image dimensions do not exceed the space of the header. Resize the image in the designer and preview until you get a good fit.

Image size while export

Hello,

I'm using Reporting Services 2005.

I have image that data value set to take the image from a web server.

I also set the sizing to "AutoSize".

In the report while the image size is more than I set in the design mode the report, the image grow and all other object in the report move.

but while I export to the excel the image size in the excel is the same size I set in the design mode.

While I export to PDF the image grow but all other objects are not moving and the image go up on other object.

can you help me ?

How are you positioning this image? Is this a single image or multiple images in a data table/matrix?|||Single image|||

I'm not sure why this is happening but I suspect it's down to the implementation of each Rendering Extension. You see each output format (HTML, XLS, PDF etc...) is programmed separately and it sounds like they treat image rendering differently.

Considering it's a single image and assuming that this image doesn't change size, the best advice I can give you is to check the dimensions of the image and to set them explicitly within the report instead of using the Auto option. That way you'll also have a better feel for what effect the image has on the rest of the report at design time.

Also try putting the image in the header or the footer to prevent it from affecting other report items in the body of the report.

Sorry I couldn't be of more help.

Image Property from Business object in Reporting Service 2005

Hi

I have a question from Reporting service 2005
I use Business Objects in My Report
and one of My object's property's type is "Image" or "BitMap"

when i Drop that property in my report and set value in "Fields!MyPicture.Value" and Run that then i see "#Error"

when i drop an "Image" from Toolbar and set that in "Database" and set value in "Fields!MyPicture.Value" and Run that then i see a red "X"

how can i show my image property from business object in my Report (.rdlc)

Thanks alot

Please read my answer in your other thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=467270&SiteID=1

-- Robert

Image Property from Business object in Reporting Service 2005

Hi

I have a question from Reporting service 2005
I use Business Objects in My Report
and one of My object's property's type is "Image" or "BitMap"

when i Drop that property in my report and set value in "Fields!MyPicture.Value" and Run that then i see "#Error"

when i drop an "Image" from Toolbar and set that in "Database" and set value in "Fields!MyPicture.Value" and Run that then i see a red "X"

how can i show my image property from business object in my Report (.rdlc)

thanks alotI have not used RS2005, but in Rs2000 that you need drop and drag a image component to your report and set database filed to this image, and then drag the image to you grid or matrix.
hope this can help you

Image problem

Hello,

I'm using SQL 2005 & reporting service 2005

I have a picture control and the image come from a web. (http://myserver/logo.jpg)

The report contain parameters.

While user generate the reporting the image display without a problem.

But if user change his parameters selected (without close the reports) than click on generate report the image doesn't dispaly and red X show.

If user click on the refresh icon in the report the image load again.

Any sugestion how to solve this problem ?

Thanks

I had a similar problem before and had to use an embedded image instead to get rid of the problem.|||This issue was addressed in SP1. After applying SP1, are you still seeing the issue?|||I still didn;t applay SP1 because the "Select All" in ,ulti selection list removed in SP1|||If you don't want to apply SP1, then the only workaround is to use an embedded image instead.|||Thanks

Image Problem

I have a web application which invokes MS reporting service, gets the result
of a render call and writes the result out to the Response object. Everything
is fine except when the rendered format is html and the report contains an
â'Externalâ' image (image in Report Project) - here the browser asks for the
report server login credentials before serving the image. If the login is not
correct, the image is not served. Is there any way the image can be made
available to the browser in this case?Take a look at the SP1 ReadMe item
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> I have a web application which invokes MS reporting service, gets the
result
> of a render call and writes the result out to the Response object.
Everything
> is fine except when the rendered format is html and the report contains an
> â'Externalâ' image (image in Report Project) - here the browser asks for
the
> report server login credentials before serving the image. If the login is
not
> correct, the image is not served. Is there any way the image can be made
> available to the browser in this case?
>
>|||"Ravi Mumulla (Microsoft)" wrote:
> Take a look at the SP1 ReadMe item
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> > I have a web application which invokes MS reporting service, gets the
> result
> > of a render call and writes the result out to the Response object.
> Everything
> > is fine except when the rendered format is html and the report contains an
> > ââ?¬Ë?Externalââ?¬â?¢ image (image in Report Project) - here the browser asks for
> the
> > report server login credentials before serving the image. If the login is
> not
> > correct, the image is not served. Is there any way the image can be made
> > available to the browser in this case?
> >
> >
> >
> >
>
>|||i have installed SP1 on the SERVER and still get this error.
does sp1 need to be installed on the Client'
i have not seen this work ever!!!
"Ravi Mumulla (Microsoft)" wrote:
> Take a look at the SP1 ReadMe item
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> > I have a web application which invokes MS reporting service, gets the
> result
> > of a render call and writes the result out to the Response object.
> Everything
> > is fine except when the rendered format is html and the report contains an
> > ââ?¬Ë?Externalââ?¬â?¢ image (image in Report Project) - here the browser asks for
> the
> > report server login credentials before serving the image. If the login is
> not
> > correct, the image is not served. Is there any way the image can be made
> > available to the browser in this case?
> >
> >
> >
> >
>
>|||SP1 should be installed on the Server and on all Development Workstations
where you develop reports. There is nothing to install on the clients.
Now your problems are directly the result of you not setting the Unattended
Execution Account up properly. When you have set that up you'll find that it
works.
From the link that Ravi sent you:
When the report is run on the report server, the report server uses the
unattended execution account to retrieve the image. If the unattended
execution account is not specified, the image is retrieved using no
credentials (anonymous user account). If either of these accounts have
insufficient rights to access the image, the image will not be displayed in
the report. For more information about setting the unattended execution
account on the report server, see "Configuring an Account for Unattended
Report Processing" in Reporting Services Books Online.
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"luzer" <luzer@.discussions.microsoft.com> wrote in message
news:A65244C5-368B-4A00-B8F6-051806250686@.microsoft.com...
>i have installed SP1 on the SERVER and still get this error.
> does sp1 need to be installed on the Client'
> i have not seen this work ever!!!
> "Ravi Mumulla (Microsoft)" wrote:
>> Take a look at the SP1 ReadMe item
>> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
>> --
>> Ravi Mumulla (Microsoft)
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
>> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
>> > I have a web application which invokes MS reporting service, gets the
>> result
>> > of a render call and writes the result out to the Response object.
>> Everything
>> > is fine except when the rendered format is html and the report contains
>> > an
>> > â?~Externalâ?T image (image in Report Project) - here the browser asks
>> > for
>> the
>> > report server login credentials before serving the image. If the login
>> > is
>> not
>> > correct, the image is not served. Is there any way the image can be
>> > made
>> > available to the browser in this case?
>> >
>> >
>> >
>> >
>>|||the problem was related to Anonymous access on IIS6 messed up.
thanks
"Peter Blackburn (www.sqlreportingservice" wrote:
> SP1 should be installed on the Server and on all Development Workstations
> where you develop reports. There is nothing to install on the clients.
> Now your problems are directly the result of you not setting the Unattended
> Execution Account up properly. When you have set that up you'll find that it
> works.
> From the link that Ravi sent you:
> When the report is run on the report server, the report server uses the
> unattended execution account to retrieve the image. If the unattended
> execution account is not specified, the image is retrieved using no
> credentials (anonymous user account). If either of these accounts have
> insufficient rights to access the image, the image will not be displayed in
> the report. For more information about setting the unattended execution
> account on the report server, see "Configuring an Account for Unattended
> Report Processing" in Reporting Services Books Online.
>
> Peter Blackburn
> Hitchhiker's Guide to SQL Server 2000 Reporting Services
> http://www.sqlreportingservices.net
>
>
>
> "luzer" <luzer@.discussions.microsoft.com> wrote in message
> news:A65244C5-368B-4A00-B8F6-051806250686@.microsoft.com...
> >i have installed SP1 on the SERVER and still get this error.
> > does sp1 need to be installed on the Client'
> >
> > i have not seen this work ever!!!
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> >> Take a look at the SP1 ReadMe item
> >> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
> >>
> >> --
> >> Ravi Mumulla (Microsoft)
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> >> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> >> > I have a web application which invokes MS reporting service, gets the
> >> result
> >> > of a render call and writes the result out to the Response object.
> >> Everything
> >> > is fine except when the rendered format is html and the report contains
> >> > an
> >> > â?~Externalâ?T image (image in Report Project) - here the browser asks
> >> > for
> >> the
> >> > report server login credentials before serving the image. If the login
> >> > is
> >> not
> >> > correct, the image is not served. Is there any way the image can be
> >> > made
> >> > available to the browser in this case?
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>|||Hi,
What are you doing about the anonymous access on IIS6?
maybe it will resolved my problem...
thanks
"luzer" wrote:
> the problem was related to Anonymous access on IIS6 messed up.
> thanks
>
> "Peter Blackburn (www.sqlreportingservice" wrote:
> > SP1 should be installed on the Server and on all Development Workstations
> > where you develop reports. There is nothing to install on the clients.
> >
> > Now your problems are directly the result of you not setting the Unattended
> > Execution Account up properly. When you have set that up you'll find that it
> > works.
> >
> > From the link that Ravi sent you:
> >
> > When the report is run on the report server, the report server uses the
> > unattended execution account to retrieve the image. If the unattended
> > execution account is not specified, the image is retrieved using no
> > credentials (anonymous user account). If either of these accounts have
> > insufficient rights to access the image, the image will not be displayed in
> > the report. For more information about setting the unattended execution
> > account on the report server, see "Configuring an Account for Unattended
> > Report Processing" in Reporting Services Books Online.
> >
> >
> > Peter Blackburn
> > Hitchhiker's Guide to SQL Server 2000 Reporting Services
> > http://www.sqlreportingservices.net
> >
> >
> >
> >
> >
> >
> >
> > "luzer" <luzer@.discussions.microsoft.com> wrote in message
> > news:A65244C5-368B-4A00-B8F6-051806250686@.microsoft.com...
> > >i have installed SP1 on the SERVER and still get this error.
> > > does sp1 need to be installed on the Client'
> > >
> > > i have not seen this work ever!!!
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > >> Take a look at the SP1 ReadMe item
> > >> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
> > >>
> > >> --
> > >> Ravi Mumulla (Microsoft)
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> > >> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> > >> > I have a web application which invokes MS reporting service, gets the
> > >> result
> > >> > of a render call and writes the result out to the Response object.
> > >> Everything
> > >> > is fine except when the rendered format is html and the report contains
> > >> > an
> > >> > â?~Externalâ?T image (image in Report Project) - here the browser asks
> > >> > for
> > >> the
> > >> > report server login credentials before serving the image. If the login
> > >> > is
> > >> not
> > >> > correct, the image is not served. Is there any way the image can be
> > >> > made
> > >> > available to the browser in this case?
> > >> >
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >|||Other strange thing,
If the image is located in the same server that IIS, the image is right
displayed.
someone can tell me what is happen?
"luzer" wrote:
> the problem was related to Anonymous access on IIS6 messed up.
> thanks
>
> "Peter Blackburn (www.sqlreportingservice" wrote:
> > SP1 should be installed on the Server and on all Development Workstations
> > where you develop reports. There is nothing to install on the clients.
> >
> > Now your problems are directly the result of you not setting the Unattended
> > Execution Account up properly. When you have set that up you'll find that it
> > works.
> >
> > From the link that Ravi sent you:
> >
> > When the report is run on the report server, the report server uses the
> > unattended execution account to retrieve the image. If the unattended
> > execution account is not specified, the image is retrieved using no
> > credentials (anonymous user account). If either of these accounts have
> > insufficient rights to access the image, the image will not be displayed in
> > the report. For more information about setting the unattended execution
> > account on the report server, see "Configuring an Account for Unattended
> > Report Processing" in Reporting Services Books Online.
> >
> >
> > Peter Blackburn
> > Hitchhiker's Guide to SQL Server 2000 Reporting Services
> > http://www.sqlreportingservices.net
> >
> >
> >
> >
> >
> >
> >
> > "luzer" <luzer@.discussions.microsoft.com> wrote in message
> > news:A65244C5-368B-4A00-B8F6-051806250686@.microsoft.com...
> > >i have installed SP1 on the SERVER and still get this error.
> > > does sp1 need to be installed on the Client'
> > >
> > > i have not seen this work ever!!!
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > >> Take a look at the SP1 ReadMe item
> > >> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images.
> > >>
> > >> --
> > >> Ravi Mumulla (Microsoft)
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> > >> news:358C3D3A-707B-43A7-AC1F-CB0162976516@.microsoft.com...
> > >> > I have a web application which invokes MS reporting service, gets the
> > >> result
> > >> > of a render call and writes the result out to the Response object.
> > >> Everything
> > >> > is fine except when the rendered format is html and the report contains
> > >> > an
> > >> > â?~Externalâ?T image (image in Report Project) - here the browser asks
> > >> > for
> > >> the
> > >> > report server login credentials before serving the image. If the login
> > >> > is
> > >> not
> > >> > correct, the image is not served. Is there any way the image can be
> > >> > made
> > >> > available to the browser in this case?
> > >> >
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >sql

Image not displayed in report

Hello everyone,

I have a Reporting Services report which must show photographs stored in a SQL Server database. The trouble is that the photos just don't display. The report just shows the little red cross icon.

When I use MS-Access forms and reports it works fine. But I need this to work with Reporting Services!

Help please!

Jerome

What data type are the pictures stored in SQL DB? You may want to change the MIMEType of the Image control on your report to see if which one is correct. I've been using image/bmp to accommodate pictures stored as varbinary data type. HTH.|||

Hi.

I discovered that the problem has to do with the way Access stores images. It stores all the OLE data necessary to display the images in Access, but this is not compatible with SQL Server. I solved the problem by purchasing and installing DBPix software. It cost me US$ 100.

Cheers,

Jerome

|||

Technet has an article about how to access OLE images. See the section entitled 'Task List Item 2 – Database Images' in http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/migratereports.mspx. Note that the code as presented only works for OLE images created on an en-US system:

Code Snippet

=System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields.Picture.Value),105))

For images created on other locales, check out this post: http://forums.devarticles.com/showpost.php?p=51707&postcount=3.

Thanks.

Image not displayed in report

Hello everyone,

I have a Reporting Services report which must show photographs stored in a SQL Server database. The trouble is that the photos just don't display. The report just shows the little red cross icon.

When I use MS-Access forms and reports it works fine. But I need this to work with Reporting Services!

Help please!

Jerome

What data type are the pictures stored in SQL DB? You may want to change the MIMEType of the Image control on your report to see if which one is correct. I've been using image/bmp to accommodate pictures stored as varbinary data type. HTH.|||

Hi.

I discovered that the problem has to do with the way Access stores images. It stores all the OLE data necessary to display the images in Access, but this is not compatible with SQL Server. I solved the problem by purchasing and installing DBPix software. It cost me US$ 100.

Cheers,

Jerome

|||

Technet has an article about how to access OLE images. See the section entitled 'Task List Item 2 – Database Images' in http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/migratereports.mspx. Note that the code as presented only works for OLE images created on an en-US system:

Code Snippet

=System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields.Picture.Value),105))

For images created on other locales, check out this post: http://forums.devarticles.com/showpost.php?p=51707&postcount=3.

Thanks.

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

Image from Business Object property?

Hello!
I'm using the local reporting services engine within a WinForm
application. I have a Business Object that contains a field which returns a
Bitmap. The Bitmap is created from other values within the same business
object. An example of the properties are below.
I'm binding my report to my BusinessObject and everything is going quite
well with the exception of displaying the graph bitmap within an Image
ReportItem. I've tried different Source types for the Image properties -
Database, Embedded, External but none seem to like the Bitmap within a
property on the Object Data Source.
I saw a few ways to develop a CustomerReportItem and will head down that
road but it seems like I'm missing something really simple. Any thoughts or
helpful tips are welcome.
Thanx,
Mike Q
public class MyBusinessObject
{
public decimal IndexValue
{
get
{
some calculations;
}
}
public Bitmap IndexGraph
{
get
{
Bitmap Result = Bitmap.FromFile("GraphTemplate.bmp");
Graphics g = Graphics.FromImage(Result);
Pen RedPen = new Pen(Brushes.Red, 5);
g.DrawLine(RedPen, 40, 0, 40, 50); // These values are calculated based on
the Index value.
return Result;
}
}
}I found the answer - instead of returning a Bitmap - return a byte[] from
the business object property
Thanx,
-q
"Mike Q" <MQuinn_q@.Yahoo.com> wrote in message
news:OMHy2SVrIHA.4280@.TK2MSFTNGP02.phx.gbl...
> Hello!
> I'm using the local reporting services engine within a WinForm
> application. I have a Business Object that contains a field which returns
> a Bitmap. The Bitmap is created from other values within the same
> business object. An example of the properties are below.
> I'm binding my report to my BusinessObject and everything is going quite
> well with the exception of displaying the graph bitmap within an Image
> ReportItem. I've tried different Source types for the Image properties -
> Database, Embedded, External but none seem to like the Bitmap within a
> property on the Object Data Source.
> I saw a few ways to develop a CustomerReportItem and will head down that
> road but it seems like I'm missing something really simple. Any thoughts
> or helpful tips are welcome.
> Thanx,
> Mike Q
>
> public class MyBusinessObject
> {
> public decimal IndexValue
> {
> get
> {
> some calculations;
> }
> }
> public Bitmap IndexGraph
> {
> get
> {
> Bitmap Result = Bitmap.FromFile("GraphTemplate.bmp");
> Graphics g = Graphics.FromImage(Result);
> Pen RedPen = new Pen(Brushes.Red, 5);
> g.DrawLine(RedPen, 40, 0, 40, 50); // These values are calculated based
> on the Index value.
> return Result;
> }
> }
> }

IList as DataSource (NHibernate usage)

Hi Friends,
It is possible to use IList as Data Source in the Reporting Services? I am
using NHibernate for access the data.
Thanks,
Pedro.You would need to write a custom DataExtension that can consume your
DAL.

IIS security problem

Hi,
I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)I am not sure I understand the issue you're facing, can you explain some
more?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> Hi,
> I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS
has all the patches that I can find. While IIS running, this computer has
been hijacked or turn to proxy server to deliver spam mails. How can I
provent it (no smpt service running.)|||Note that you do not need to have either an email client nor an email server
running. There would be no way for your server to be hijacked if you do not
have these installed. Yes, you can use either but you do not need to. I am
configured where RS sends the email to an SMTP server which resides
elsewhere.
Bruce L-C
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> I keep getting email indicate that my computer was hijack and used as
proxy server to deliver hugh emails while IIS5.0 running. It is very
difficult to get budget to try sql reporting service specially it is not
secure. First I did implement sending email in sql reporting service by
changing in configuration file (drop off email files in a folder to smtp to
pick them up). Once I had this problem then I turned off smtp but I still
got emails indicated that my computer was hijacked. I installed lock down
IIS and all the patch for IIS5.0. I would like to try RS but if I still
cause problem to others, I might not be able to test or implement this
software. If you need more info. please let me know.
> "Tudor Trufinescu (MSFT)" wrote:
> > I am not sure I understand the issue you're facing, can you explain some
> > more?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > Hi,
> > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
IIS
> > has all the patches that I can find. While IIS running, this computer
has
> > been hijacked or turn to proxy server to deliver spam mails. How can I
> > provent it (no smpt service running.)
> >
> >
> >|||Thanks. Unfortunately, this is a test on my computer, I have to have mail client on this computer.
"Bruce Loehle-Conger" wrote:
> Note that you do not need to have either an email client nor an email server
> running. There would be no way for your server to be hijacked if you do not
> have these installed. Yes, you can use either but you do not need to. I am
> configured where RS sends the email to an SMTP server which resides
> elsewhere.
> Bruce L-C
> "csoon" <csoon@.discussions.microsoft.com> wrote in message
> news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> > I keep getting email indicate that my computer was hijack and used as
> proxy server to deliver hugh emails while IIS5.0 running. It is very
> difficult to get budget to try sql reporting service specially it is not
> secure. First I did implement sending email in sql reporting service by
> changing in configuration file (drop off email files in a folder to smtp to
> pick them up). Once I had this problem then I turned off smtp but I still
> got emails indicated that my computer was hijacked. I installed lock down
> IIS and all the patch for IIS5.0. I would like to try RS but if I still
> cause problem to others, I might not be able to test or implement this
> software. If you need more info. please let me know.
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > I am not sure I understand the issue you're facing, can you explain some
> > > more?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > > Hi,
> > > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
> IIS
> > > has all the patches that I can find. While IIS running, this computer
> has
> > > been hijacked or turn to proxy server to deliver spam mails. How can I
> > > provent it (no smpt service running.)
> > >
> > >
> > >
>
>

IIS Install

Hi All,
I am installing SQL 2005 and would like to know if there the reporting
services are the only thing in SQL that requires IIS. So I guess my
question is if I shutdown IIS on the box what will break? Thanks
-DavidDude , you are not trying to do something right !!, Just kidding.
Nothing happens because your frontend ie RM wont work otherwise everything
is intact. since it stores in report database.
Amarnath
"damccumb@.gmail.com" wrote:
> Hi All,
> I am installing SQL 2005 and would like to know if there the reporting
> services are the only thing in SQL that requires IIS. So I guess my
> question is if I shutdown IIS on the box what will break? Thanks
> -David
>