External image not displayed in report manager

Hello,
I have a problem and I don't know how to solve it. I hope you guy's
know.
I have a report with a external image which refers to a image on a
SharePoint intranet site. When I preview the report in visual studio
the image is visible. But when I deploy the report to the report server
the image is not displayed and a red cross is showing. I have already
set the execution account on the report server but still not working.
When I enter the URL of the image in the browser on the report server
the image is visible. I don't understand what I do wrong? Hope someone
knows!
I use reporting service 2005
Regards,
Robbert Visscher
HollandI had this problem once. I had to enable anonymous access to the
virtual directory for the images folder.
Not sure if that is what your problem is, but maybe...
-Josh
robbert wrote:
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland|||I'm not sure, read that this was fixed in RS 2000 sp1, seems like 2005
should handle it.
Found this:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/540b31cf8bab7cfe/33b1edc0dabb5354?lnk=st&q=Reporting+Services+2005+References+to+external+URLs&rnum=4&hl=en#33b1edc0dabb5354
btw, my wife is Dutch: deLeeuw, going to meet the family there for my first
time next spring.
Steve MunLeeuw
"robbert" <robbert_visscher@.hotmail.com> wrote in message
news:1155673109.459815.285790@.p79g2000cwp.googlegroups.com...
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland
>|||The image is on a Share Point site so the images are collected in a
Share Point database. But in my preview it works fine so I don't
understand why it not works in de report manager?|||Import(upload) the image file on to the report manger|||Thanks for your answer but it is not a good solution. It has to work
like this way. But why is it not working? It works fine in visual
studio. I have already read a lot of questions on the Internet about
this problem but no one can solve the problem. Maby it is a bug? I
think that the unattended execution account is not working with
reporting service 2005. I have already installed SP1 and the latest
hotfix. So does anyone know what it could be or confirm it is a Bug?
Regards,
Robbert
Holland|||Again, it sounds like a permission issue to me. When you try it using
the Preview tab, it is using your credentials. When it runs via Report
Manager, it does not use your credentials.
Does the ID that SSRS is running under have access to SharePoint?
-Josh
robbert wrote:
> Thanks for your answer but it is not a good solution. It has to work
> like this way. But why is it not working? It works fine in visual
> studio. I have already read a lot of questions on the Internet about
> this problem but no one can solve the problem. Maby it is a bug? I
> think that the unattended execution account is not working with
> reporting service 2005. I have already installed SP1 and the latest
> hotfix. So does anyone know what it could be or confirm it is a Bug?
> Regards,
> Robbert
> Holland|||Hello Josh,
Thanks for your answer! I have set the credentials in the report
manager which are the same as mine credentials. I have set the
unattended execution account and the Windows service identity as the
same I use in visual studio. Also when I acces the URL in the browser
the image is visible. I have access to the share point site because I
see the image in the browser. I hope you know a solution! Thanks!
Robbert
Holland
Josh schreef:
> Again, it sounds like a permission issue to me. When you try it using
> the Preview tab, it is using your credentials. When it runs via Report
> Manager, it does not use your credentials.
> Does the ID that SSRS is running under have access to SharePoint?
> -Josh
>
> robbert wrote:
> > Thanks for your answer but it is not a good solution. It has to work
> > like this way. But why is it not working? It works fine in visual
> > studio. I have already read a lot of questions on the Internet about
> > this problem but no one can solve the problem. Maby it is a bug? I
> > think that the unattended execution account is not working with
> > reporting service 2005. I have already installed SP1 and the latest
> > hotfix. So does anyone know what it could be or confirm it is a Bug?
> >
> > Regards,
> >
> > Robbert
> > Holland|||Robbert,
And you enabled anonymous access on that sharepoint site?
-Josh
robbert wrote:
> Hello Josh,
> Thanks for your answer! I have set the credentials in the report
> manager which are the same as mine credentials. I have set the
> unattended execution account and the Windows service identity as the
> same I use in visual studio. Also when I acces the URL in the browser
> the image is visible. I have access to the share point site because I
> see the image in the browser. I hope you know a solution! Thanks!
> Robbert
> Holland
> Josh schreef:
> > Again, it sounds like a permission issue to me. When you try it using
> > the Preview tab, it is using your credentials. When it runs via Report
> > Manager, it does not use your credentials.
> >
> > Does the ID that SSRS is running under have access to SharePoint?
> >
> > -Josh
> >
> >
> > robbert wrote:
> > > Thanks for your answer but it is not a good solution. It has to work
> > > like this way. But why is it not working? It works fine in visual
> > > studio. I have already read a lot of questions on the Internet about
> > > this problem but no one can solve the problem. Maby it is a bug? I
> > > think that the unattended execution account is not working with
> > > reporting service 2005. I have already installed SP1 and the latest
> > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > >
> > > Regards,
> > >
> > > Robbert
> > > Holland|||Helle Josh,
Anonymous acces we can not enabled that because of security. But i have
set a unattended execution account so I dont need that right?
Robbert
Josh schreef:
> Robbert,
> And you enabled anonymous access on that sharepoint site?
> -Josh
>
> robbert wrote:
> > Hello Josh,
> >
> > Thanks for your answer! I have set the credentials in the report
> > manager which are the same as mine credentials. I have set the
> > unattended execution account and the Windows service identity as the
> > same I use in visual studio. Also when I acces the URL in the browser
> > the image is visible. I have access to the share point site because I
> > see the image in the browser. I hope you know a solution! Thanks!
> >
> > Robbert
> > Holland
> >
> > Josh schreef:
> >
> > > Again, it sounds like a permission issue to me. When you try it using
> > > the Preview tab, it is using your credentials. When it runs via Report
> > > Manager, it does not use your credentials.
> > >
> > > Does the ID that SSRS is running under have access to SharePoint?
> > >
> > > -Josh
> > >
> > >
> > > robbert wrote:
> > > > Thanks for your answer but it is not a good solution. It has to work
> > > > like this way. But why is it not working? It works fine in visual
> > > > studio. I have already read a lot of questions on the Internet about
> > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > think that the unattended execution account is not working with
> > > > reporting service 2005. I have already installed SP1 and the latest
> > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > >
> > > > Regards,
> > > >
> > > > Robbert
> > > > Holland|||When I added an "external" image to a report (using a URL as the image
source), I received a warning stating that images would not display
correctly unless an unattended execution account or anonymous access
was configured. Because this was an "OR", I am assuming that you only
need 1 or the other.
My thought was to enable anonymous access, try your report, and disable
anonymous again, just to see if that solves the problem.
Sorry I can't be of more help.
-Josh
robbert wrote:
> Helle Josh,
> Anonymous acces we can not enabled that because of security. But i have
> set a unattended execution account so I dont need that right?
> Robbert
> Josh schreef:
> > Robbert,
> >
> > And you enabled anonymous access on that sharepoint site?
> >
> > -Josh
> >
> >
> >
> > robbert wrote:
> > > Hello Josh,
> > >
> > > Thanks for your answer! I have set the credentials in the report
> > > manager which are the same as mine credentials. I have set the
> > > unattended execution account and the Windows service identity as the
> > > same I use in visual studio. Also when I acces the URL in the browser
> > > the image is visible. I have access to the share point site because I
> > > see the image in the browser. I hope you know a solution! Thanks!
> > >
> > > Robbert
> > > Holland
> > >
> > > Josh schreef:
> > >
> > > > Again, it sounds like a permission issue to me. When you try it using
> > > > the Preview tab, it is using your credentials. When it runs via Report
> > > > Manager, it does not use your credentials.
> > > >
> > > > Does the ID that SSRS is running under have access to SharePoint?
> > > >
> > > > -Josh
> > > >
> > > >
> > > > robbert wrote:
> > > > > Thanks for your answer but it is not a good solution. It has to work
> > > > > like this way. But why is it not working? It works fine in visual
> > > > > studio. I have already read a lot of questions on the Internet about
> > > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > > think that the unattended execution account is not working with
> > > > > reporting service 2005. I have already installed SP1 and the latest
> > > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > > >
> > > > > Regards,
> > > > >
> > > > > Robbert
> > > > > Holland|||I had the same problem. The image i was originally trying to access was a
bitmap file. I re-saved it as a jpeg and then it worked fine.
robbert wrote:
>Hello,
>I have a problem and I don't know how to solve it. I hope you guy's
>know.
>I have a report with a external image which refers to a image on a
>SharePoint intranet site. When I preview the report in visual studio
>the image is visible. But when I deploy the report to the report server
>the image is not displayed and a red cross is showing. I have already
>set the execution account on the report server but still not working.
>When I enter the URL of the image in the browser on the report server
>the image is visible. I don't understand what I do wrong? Hope someone
>knows!
>I use reporting service 2005
>Regards,
>Robbert Visscher
>Holland|||It are jpeg files and they work in visual studio. The problem still is
that i get red crosses in the report manager. I don't understand it.
IanGregson schreef:
> I had the same problem. The image i was originally trying to access was a
> bitmap file. I re-saved it as a jpeg and then it worked fine.
> robbert wrote:
> >Hello,
> >
> >I have a problem and I don't know how to solve it. I hope you guy's
> >know.
> >
> >I have a report with a external image which refers to a image on a
> >SharePoint intranet site. When I preview the report in visual studio
> >the image is visible. But when I deploy the report to the report server
> >the image is not displayed and a red cross is showing. I have already
> >set the execution account on the report server but still not working.
> >When I enter the URL of the image in the browser on the report server
> >the image is visible. I don't understand what I do wrong? Hope someone
> >knows!
> >
> >I use reporting service 2005
> >
> >Regards,
> >
> >Robbert Visscher
> >Holland

Exporting to multiple files from a single source table using DTS

Hi Friends

I have been trying to solve this problem for the last 2 days but no luck.

Here is the problem that I am facing.

The task on had is to transfer data from a single table (the source) to multiple files (Destination) based on the record type.

I have tried to changing the Datasource property of the Text File Connection object dynamically by using an ActiveX Script. But the data is still being written only to one file.

Can anyone please help me.

Thanks in advance.

Srinivas.Can't you split up your export by using views with restrictions on your recordtype instead of your table?|||manthenasri, does DTS allow you to redirect output on the fly? From what I have seen the source and destination is fixed at design time.

Have you tried BCP with a query? You could use DTS to script your BCP commands to a CMD file. Then at the cmd prompt you could use DTSRUN to build the CMD file and then execute the CMD file. Or just set up a procedure to script the BCP commands and use xp_cmdshell.

Sort of bassackwards but it's the best I could come up with.|||Hello Paul

I do not know much about BCP. But here is the problem that i have to solve.

I have a table by name T1 which has the following data

Business Unit Name SSN RATE
1 Joe 923456789 40
1 Jenny 568234569 50
3 Mike 234198634 35
3 Meri 743579374 45

Now i need to create a two files by name 1.ben and 3.ben on the fly.
and them put in the data related to Joe and Jenny into 1.ben and the data for Mike and Meri into 3.ben. If there is more data related to other business units i need to create those files also.

Can you please tell me how i can accomplish using BCP.

Thanks,
Srinivas.|||I think the BCP command you want is...

bcp "select * from <dbname>.<owner>.<table> where <where clause>" queryout <file name> -c -T -S <server>

probably could wrap it all up like this:
create table manthenasri([Business Unit] int, [Name] varchar(15), SSN varchar(9), Rate int)
insert into manthenasri values(1,'Joe','923456789',40)
insert into manthenasri values(1,'Jenny','568234569',50)
insert into manthenasri values(3,'Mike','234198634',35)
insert into manthenasri values(3,'Meri','743579374',45)

declare @.bu int, @.TSQL varchar(255)
select @.bu = min([Business Unit]) from manthenasri
while @.bu is not null begin
set @.TSQL = 'bcp "select * from ' + db_name() + '..' + 'manthenasri where [Business Unit] = ' + cast(@.bu as varchar) + '" queryout ' + cast(@.bu as varchar) + '.ben -c -T -S ' + @.@.servername
print @.TSQL
-- master.dbo.xp_cmdshell(@.TSQL)
select @.bu = min([Business Unit]) from manthenasri where [Business Unit] > @.bu
end

Open Query Analyzer and run the above code. It should produce a few BCP commands. Make adjustments for your table and rerun the script. Next try cutting and pasting the results to a CMD prompt and see how it works. Once that's done you can un-comment the xp_cmdshell call and try running this on your server.

THIS IS UNTESTED CODE!

Look this over and post back with questions.|||Hi Srinivas ,

Use DTS designer add one data pump task for each condition and output file.

For example : Use select statement as the source of data pump task with where clause and desination to the the disired out put file.

cheers :)

Shaji

Originally posted by manthenasri
Hi Friends

I have been trying to solve this problem for the last 2 days but no luck.

Here is the problem that I am facing.

The task on had is to transfer data from a single table (the source) to multiple files (Destination) based on the record type.

I have tried to changing the Datasource property of the Text File Connection object dynamically by using an ActiveX Script. But the data is still being written only to one file.

Can anyone please help me.

Thanks in advance.

Srinivas.|||Hai Paul


Thank you for the BCP solution that you have given. I really appreciate you patience in giving me a sample program also.

The sample worked just fine except for the brackets enclosing the variable @.Tsql. I think these brackets should not be there. I had to remove these brackets.

But now have a problem of reading from multiple files and posting that data into table. I have to do an isert and also an update on the table. How can i do that?

Thank you very much once again.

Srinivas.