Showing posts with label gif. Show all posts
Showing posts with label gif. Show all posts

Wednesday, March 28, 2012

Images rendering poorly?

Has anyone else out there had any problems with images rendering improperly
in the reports? When I add our company logo (a gif) to a report, it looks
fine in the development environment. Also, when I export the reports (say,
to a pdf) the images are fine, but when I view the report in a browser
(through the reporting services) the image is slightly skewed. Has anyone
else run across this, and if so, any idea on how to fix this?
Thanks for any help offered.Yes Hammer I have also had this problem for some time now. I have tried all
forms of image input into the report (embedded, project, database, and web)
and all have the same results; a lower quality image.
Anyone else?
"The Hammer" <david.hamilton@.datashapers.com> wrote in message
news:OCHYNpw1EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Has anyone else out there had any problems with images rendering
> improperly
> in the reports? When I add our company logo (a gif) to a report, it looks
> fine in the development environment. Also, when I export the reports (say,
> to a pdf) the images are fine, but when I view the report in a browser
> (through the reporting services) the image is slightly skewed. Has anyone
> else run across this, and if so, any idea on how to fix this?
> Thanks for any help offered.
>

Monday, March 26, 2012

Images are not shown

Hi,
I have an image in a report. (Set to External, Url is set to
http://localhost/JB/images/name.gif).
When I try to display the report in HTML or PDF, the image is not shown.
All my webs are set to intergrated security. In the IIS log I see, that the
report server tries to access the image via Anonymous.
Why?
How I can change that he use integrated security? ( I have tried to set the
'unattended report processing', but no change)
Thanks
EricHello Eric,
Based on my experience, this issue can occur because images folder is not
set up to a virtual directory. You could only use link /images/name.gif
inside the virutal directory JB. For example, when you access
http://localhost/JB/images/name.gif directly in IE, the image cannot be
shown. However, if you copy name.gif to the folder of the virtual directory
JB, you could access the image directly via the URL
http://localhost/JB/name.gif
Therefore, I suggest that you create a new VD to point to the images folder
so that you could access the images directly in IE. After that, you could
use the URL in Report design.
Because the issue is a IIS related issue, if you need further assistance on
the issue, please post the quesiton in the following newsgroup:
microsoft.public.inetserver.iis
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Eric" <jug@.nospam.nospam>
| Subject: Images are not shown
| Date: Mon, 27 Jun 2005 11:18:47 +0200
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46745
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| I have an image in a report. (Set to External, Url is set to
| http://localhost/JB/images/name.gif).
| When I try to display the report in HTML or PDF, the image is not shown.
|
| All my webs are set to intergrated security. In the IIS log I see, that
the
| report server tries to access the image via Anonymous.
|
| Why?
| How I can change that he use integrated security? ( I have tried to set
the
| 'unattended report processing', but no change)
|
| Thanks
| Eric
|
|
||||Hello Eric,
Sorry for my typo, we shall be able to access the image properly though it
is not directly under JB virtual directory
http://localhost/JB/images/name.gif
Please check if you could access the image directly in IE. If not, IIS
newsgroup is more proper place to submist this issue.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| From: petery@.online.microsoft.com (Peter Yang [MSFT])
| Organization: Microsoft
| Date: Tue, 28 Jun 2005 02:23:28 GMT
| Subject: RE: Images are not shown
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
|
| Hello Eric,
|
| Based on my experience, this issue can occur because images folder is not
| set up to a virtual directory. You could only use link /images/name.gif
| inside the virutal directory JB. For example, when you access
| http://localhost/JB/images/name.gif directly in IE, the image cannot be
| shown. However, if you copy name.gif to the folder of the virtual
directory
| JB, you could access the image directly via the URL
| http://localhost/JB/name.gif
|
| Therefore, I suggest that you create a new VD to point to the images
folder
| so that you could access the images directly in IE. After that, you could
| use the URL in Report design.
|
| Because the issue is a IIS related issue, if you need further assistance
on
| the issue, please post the quesiton in the following newsgroup:
|
| microsoft.public.inetserver.iis
|
| Regards,
|
| Peter Yang
| MCSE2000/2003, MCSA, MCDBA
| Microsoft Online Partner Support
|
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
|
| =====================================================|
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
| --
| | From: "Eric" <jug@.nospam.nospam>
| | Subject: Images are not shown
| | Date: Mon, 27 Jun 2005 11:18:47 +0200
| | Lines: 17
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:46745
| | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| |
| | Hi,
| |
| | I have an image in a report. (Set to External, Url is set to
| | http://localhost/JB/images/name.gif).
| | When I try to display the report in HTML or PDF, the image is not shown.
| |
| | All my webs are set to intergrated security. In the IIS log I see, that
| the
| | report server tries to access the image via Anonymous.
| |
| | Why?
| | How I can change that he use integrated security? ( I have tried to set
| the
| | 'unattended report processing', but no change)
| |
| | Thanks
| | Eric
| |
| |
| |
||||Hello Peter,
Thanks for answering.
Yes, I can access the image directly in IE.
How I mentioned before, the problem is that the report server doesn't access
the URL with Integrated security.
The report self (HTML Preview) runs under integrated security.
Thanks
Eric
"Peter Yang [MSFT]" <petery@.online.microsoft.com> schrieb im Newsbeitrag
news:RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl...
> Hello Eric,
> Sorry for my typo, we shall be able to access the image properly though it
> is not directly under JB virtual directory
> http://localhost/JB/images/name.gif
> Please check if you could access the image directly in IE. If not, IIS
> newsgroup is more proper place to submist this issue.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | From: petery@.online.microsoft.com (Peter Yang [MSFT])
> | Organization: Microsoft
> | Date: Tue, 28 Jun 2005 02:23:28 GMT
> | Subject: RE: Images are not shown
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | MIME-Version: 1.0
> | Content-Type: text/plain
> | Content-Transfer-Encoding: 7bit
> |
> | Hello Eric,
> |
> | Based on my experience, this issue can occur because images folder is
> not
> | set up to a virtual directory. You could only use link /images/name.gif
> | inside the virutal directory JB. For example, when you access
> | http://localhost/JB/images/name.gif directly in IE, the image cannot be
> | shown. However, if you copy name.gif to the folder of the virtual
> directory
> | JB, you could access the image directly via the URL
> | http://localhost/JB/name.gif
> |
> | Therefore, I suggest that you create a new VD to point to the images
> folder
> | so that you could access the images directly in IE. After that, you
> could
> | use the URL in Report design.
> |
> | Because the issue is a IIS related issue, if you need further assistance
> on
> | the issue, please post the quesiton in the following newsgroup:
> |
> | microsoft.public.inetserver.iis
> |
> | Regards,
> |
> | Peter Yang
> | MCSE2000/2003, MCSA, MCDBA
> | Microsoft Online Partner Support
> |
> | When responding to posts, please "Reply to Group" via your newsreader so
> | that others may learn and benefit from your issue.
> |
> | =====================================================> |
> |
> | This posting is provided "AS IS" with no warranties, and confers no
> rights.
> |
> |
> |
> |
> | --
> | | From: "Eric" <jug@.nospam.nospam>
> | | Subject: Images are not shown
> | | Date: Mon, 27 Jun 2005 11:18:47 +0200
> | | Lines: 17
> | | X-Priority: 3
> | | X-MSMail-Priority: Normal
> | | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
> | | X-RFC2646: Format=Flowed; Original
> | | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
> | | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
> | | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:46745
> | | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | |
> | | Hi,
> | |
> | | I have an image in a report. (Set to External, Url is set to
> | | http://localhost/JB/images/name.gif).
> | | When I try to display the report in HTML or PDF, the image is not
> shown.
> | |
> | | All my webs are set to intergrated security. In the IIS log I see,
> that
> | the
> | | report server tries to access the image via Anonymous.
> | |
> | | Why?
> | | How I can change that he use integrated security? ( I have tried to
> set
> | the
> | | 'unattended report processing', but no change)
> | |
> | | Thanks
> | | Eric
> | |
> | |
> | |
> |
>|||Peter,
I have the same problem as Eric. I followed your instructions and can view
the logo.jpg in IE, and also in my report designer.
My problem is after deploying the report to the report server and running
the report, the report will not show the image.
The SP1 Read Me said that external images in image controls are now
supported, and that I must configure an account for unattended report
execution. I did this, but still cannot view the image when the deployed
report runs on the report server.
-- Mike J|||Hello Eric,
Based on my test, this behavior seems to be as designed. I think this is
because the referenced images are usually on public sites which only
requires anonymous authentication. Usually reporting service shall re-try
with the impersonated credential of the client. Apparently it does not do
so in getting image from other web sites/VDs.
We have to enable "anonymouse authentication" on the image folder of other
VD so that the report can work properly.
Please rest assured your feedback and concerns on this issue is routed to
the proper channel. Also, you may want to submit your feedback by following
method:
Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.
E-mail - To send comments or suggestions via e-mail, use the following
Microsoft Wish Program e-mail address, mswish@.microsoft.com.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
| From: "Eric" <jug@.nospam.nospam>
| References: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
<fPG2gh4eFHA.2656@.TK2MSFTNGXA01.phx.gbl>
<RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Images are not shown
| Date: Tue, 28 Jun 2005 09:30:33 +0200
| Lines: 142
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <u27iIN7eFHA.1400@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46852
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello Peter,
|
| Thanks for answering.
| Yes, I can access the image directly in IE.
|
| How I mentioned before, the problem is that the report server doesn't
access
| the URL with Integrated security.
|
| The report self (HTML Preview) runs under integrated security.
|
| Thanks
| Eric
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> schrieb im Newsbeitrag
| news:RH00wn4eFHA.940@.TK2MSFTNGXA01.phx.gbl...
| > Hello Eric,
| >
| > Sorry for my typo, we shall be able to access the image properly though
it
| > is not directly under JB virtual directory
| >
| > http://localhost/JB/images/name.gif
| >
| > Please check if you could access the image directly in IE. If not, IIS
| > newsgroup is more proper place to submist this issue.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| >
| >
| > --
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | From: petery@.online.microsoft.com (Peter Yang [MSFT])
| > | Organization: Microsoft
| > | Date: Tue, 28 Jun 2005 02:23:28 GMT
| > | Subject: RE: Images are not shown
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | MIME-Version: 1.0
| > | Content-Type: text/plain
| > | Content-Transfer-Encoding: 7bit
| > |
| > | Hello Eric,
| > |
| > | Based on my experience, this issue can occur because images folder is
| > not
| > | set up to a virtual directory. You could only use link
/images/name.gif
| > | inside the virutal directory JB. For example, when you access
| > | http://localhost/JB/images/name.gif directly in IE, the image cannot
be
| > | shown. However, if you copy name.gif to the folder of the virtual
| > directory
| > | JB, you could access the image directly via the URL
| > | http://localhost/JB/name.gif
| > |
| > | Therefore, I suggest that you create a new VD to point to the images
| > folder
| > | so that you could access the images directly in IE. After that, you
| > could
| > | use the URL in Report design.
| > |
| > | Because the issue is a IIS related issue, if you need further
assistance
| > on
| > | the issue, please post the quesiton in the following newsgroup:
| > |
| > | microsoft.public.inetserver.iis
| > |
| > | Regards,
| > |
| > | Peter Yang
| > | MCSE2000/2003, MCSA, MCDBA
| > | Microsoft Online Partner Support
| > |
| > | When responding to posts, please "Reply to Group" via your newsreader
so
| > | that others may learn and benefit from your issue.
| > |
| > | =====================================================| > |
| > |
| > | This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > |
| > |
| > |
| > |
| > | --
| > | | From: "Eric" <jug@.nospam.nospam>
| > | | Subject: Images are not shown
| > | | Date: Mon, 27 Jun 2005 11:18:47 +0200
| > | | Lines: 17
| > | | X-Priority: 3
| > | | X-MSMail-Priority: Normal
| > | | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| > | | x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.2527
| > | | X-RFC2646: Format=Flowed; Original
| > | | Message-ID: <eNd76kveFHA.2420@.TK2MSFTNGP12.phx.gbl>
| > | | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | | NNTP-Posting-Host: c-213-160-47-98.customer.ggaweb.ch 213.160.47.98
| > | | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:46745
| > | | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | |
| > | | Hi,
| > | |
| > | | I have an image in a report. (Set to External, Url is set to
| > | | http://localhost/JB/images/name.gif).
| > | | When I try to display the report in HTML or PDF, the image is not
| > shown.
| > | |
| > | | All my webs are set to intergrated security. In the IIS log I see,
| > that
| > | the
| > | | report server tries to access the image via Anonymous.
| > | |
| > | | Why?
| > | | How I can change that he use integrated security? ( I have tried to
| > set
| > | the
| > | | 'unattended report processing', but no change)
| > | |
| > | | Thanks
| > | | Eric
| > | |
| > | |
| > | |
| > |
| >
|
|
|sql

Friday, March 23, 2012

image located on web, url for image stored in database

Hi,

I have a website and i am uploading the gif image to the database. i have used varchar(500) as the datatype and i am saving the file in the webserver so the path to it c:\intepub\....a.gif

my upload table has the folliwing feilds

UploadId Int Identity, Description, FileName, DiskPath varchar(500), weblocation varchar(500). I have a main sproc for the report where i am doing a inner join with other table to get the path of the gif..

So my question is how can i get a picture to show up on the report. .

What kinda datatype the gif file should be stored in the database? If it is stored as a varchar how can i access it and what is best way to reference that particular.

any help will appreciated....

Regards

Karen

This should help:

http://technet.microsoft.com/en-us/library/ms156482.aspx

But I must ask, why do you want to store the image in your database? Why not just host it on a website?

|||Anyone know a way to do this? I want to create a report that will use a table from sql that has a url which points to an image. I want this image to show up in a table in my report. The end goal is to have a searchable report with parameters that supplies immages (from the web) based on search criteria.
|||

Greg,

I have stored the image as a gif file on my webserver, but i couldnt access it, but now i gave the url to it and then specified it as a external image and everything works fine.. i am storing the reference to the image.... in the database.

Thanks a lot.

Regards

Karen

|||If I understand this post, I am having simmilar difficulties. I want to have a table in sql that has verious links to images locaed on the web. I want to display these images in my report. I'm quite confused and pretty new to this so if you can treat me like I know nothing at all and show me step by step what you did I'd really appreciat it.
|||

I have merged the two threads as they are highly related.

|||

Mflancour,

I am uploading the image using a file upload control in the database. and i am storing the like a URL http://Ipaddress/Nameoftheapplication/anyfolders/andsubfoldersintheapplication/Filename.gif. This field is set up in a my database as varchar(500) so i will be storing the above information in that field.

Then, in reporting service .... get the field that u want to access in the particular dataset

From the tool box select image and follow the wizard and select Database and then select the dataset and the field

then select the image and in the properties change the source to external and preview it.

and it should work

hope this helps.

Karen

|||Nevermind figured it out based on your earlier posts
sql

Wednesday, March 21, 2012

image files

I've uploaded a gif file to RS using Reports Manager, but when I go to view
the image in RS/RM, it does not display. Only a red X displays.
I'm using RS 2000 with Form based authentication.
Please Help!!!!On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> I've uploaded a gif file to RS using Reports Manager, but when I go to view
> the image in RS/RM, it does not display. Only a red X displays.
> I'm using RS 2000 with Form based authentication.
> Please Help!!!!
I would suggest embedding the image in the report itself. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||how do I embed an image?
"EMartinez" wrote:
> On Mar 13, 2:56 pm, Nikki <N...@.discussions.microsoft.com> wrote:
> > I've uploaded a gif file to RS using Reports Manager, but when I go to view
> > the image in RS/RM, it does not display. Only a red X displays.
> >
> > I'm using RS 2000 with Form based authentication.
> >
> > Please Help!!!!
> I would suggest embedding the image in the report itself. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>