Generate images from SharePoint picture library?

I have a picture which saved in the sharepoint piture library, I can see it
via IE, the url is http://sharepoint/My20Pictures/01.jpg
But when I add it as an external image, it does't show when I review the
report.
Please advise! Thanks a lot!When you drag the image control and a option list shows up, when you selected
web, and you must have given URL at that time it gave any error ? Just check.
if it gives then there is a problem in accessing the jpg, So you need to
sort out there itself to proceed. Just check for access as well.
Amarnath
"CEO" wrote:
> I have a picture which saved in the sharepoint piture library, I can see it
> via IE, the url is http://sharepoint/My20Pictures/01.jpg
> But when I add it as an external image, it does't show when I review the
> report.
> Please advise! Thanks a lot!|||Thanks Amarnath,
There wasn't any problem when I darg the image control and type in the URL
for the picture, the image can be seen in the design model.
I think it is a permission issue when it go live, because sharepoint save
the picture in sql server database. And the reporting services running under
Local System.
But I'm not sure how to add user permission to show the picture.
Thanks!
"Amarnath" wrote:
> When you drag the image control and a option list shows up, when you selected
> web, and you must have given URL at that time it gave any error ? Just check.
> if it gives then there is a problem in accessing the jpg, So you need to
> sort out there itself to proceed. Just check for access as well.
> Amarnath
> "CEO" wrote:
> > I have a picture which saved in the sharepoint piture library, I can see it
> > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> >
> > But when I add it as an external image, it does't show when I review the
> > report.
> >
> > Please advise! Thanks a lot!|||Infact when you select from the image control and preview it really connects
live and if it works, it has connection permission. So probabily, you can
check out the error, what exactly it gives, otherwise if you can add your
image(jpg) as a project and access from reports.
Amarnath
"CEO" wrote:
> Thanks Amarnath,
> There wasn't any problem when I darg the image control and type in the URL
> for the picture, the image can be seen in the design model.
> I think it is a permission issue when it go live, because sharepoint save
> the picture in sql server database. And the reporting services running under
> Local System.
> But I'm not sure how to add user permission to show the picture.
> Thanks!
>
> "Amarnath" wrote:
> > When you drag the image control and a option list shows up, when you selected
> > web, and you must have given URL at that time it gave any error ? Just check.
> > if it gives then there is a problem in accessing the jpg, So you need to
> > sort out there itself to proceed. Just check for access as well.
> >
> > Amarnath
> >
> > "CEO" wrote:
> >
> > > I have a picture which saved in the sharepoint piture library, I can see it
> > > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> > >
> > > But when I add it as an external image, it does't show when I review the
> > > report.
> > >
> > > Please advise! Thanks a lot!|||I have the same problem with the authentication. I found in IIS log, that
requests for the picture from the pic library returns error 401. how to solve
the permissions problem?
Thanks
"Amarnath" wrote:
> Infact when you select from the image control and preview it really connects
> live and if it works, it has connection permission. So probabily, you can
> check out the error, what exactly it gives, otherwise if you can add your
> image(jpg) as a project and access from reports.
> Amarnath
>
> "CEO" wrote:
> > Thanks Amarnath,
> >
> > There wasn't any problem when I darg the image control and type in the URL
> > for the picture, the image can be seen in the design model.
> >
> > I think it is a permission issue when it go live, because sharepoint save
> > the picture in sql server database. And the reporting services running under
> > Local System.
> >
> > But I'm not sure how to add user permission to show the picture.
> >
> > Thanks!
> >
> >
> > "Amarnath" wrote:
> >
> > > When you drag the image control and a option list shows up, when you selected
> > > web, and you must have given URL at that time it gave any error ? Just check.
> > > if it gives then there is a problem in accessing the jpg, So you need to
> > > sort out there itself to proceed. Just check for access as well.
> > >
> > > Amarnath
> > >
> > > "CEO" wrote:
> > >
> > > > I have a picture which saved in the sharepoint piture library, I can see it
> > > > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> > > >
> > > > But when I add it as an external image, it does't show when I review the
> > > > report.
> > > >
> > > > Please advise! Thanks a lot!

Generate a GUID in MS SQL (t/SQL)

Hello,
I'm writing a MS SQL script to roll-up an Event List in Sharepoint, and
I have it working except I haven't found a way to generate a GUID using
t/SQL in MS SQL. Is there a function or script or something I can use
to generate a GUID value? I can do this in ASP or ColdFusion or a few
other ways, but keeping this totally in MS SQL as a stored procedure I
can schedule to run periodically would be the simplest.
Thanks for any suggestions or ideas on this.
Also, from a Sharepoint standpoint, SPS nor WSS supports roll-ups for
Events or any list, which is why I'm writing this on my own. Also
there are third party plugins, but most are around $1600 or more, which
is crazy since this can be done in MS SQL if I can only figure out the
GUID bit.
Thanks for any help or assistance --
SamSam
Try newid(), I don't have access to the query analyzer tonight, but
from memory it should a litlte like:
<sql snippet>
DECLARE @.MyUUID AS uniqueidentifier
SET @.MyUUID = newid()
SELECT @.MyUUID
</sql:snippet>
HTH,
Duncan.|||Have you tried this method?
SELECT NEWID()
Keith Kratochvil
"Alex" <samalex@.gmail.com> wrote in message
news:1141685000.839522.40640@.i39g2000cwa.googlegroups.com...
> Hello,
> I'm writing a MS SQL script to roll-up an Event List in Sharepoint, and
> I have it working except I haven't found a way to generate a GUID using
> t/SQL in MS SQL. Is there a function or script or something I can use
> to generate a GUID value? I can do this in ASP or ColdFusion or a few
> other ways, but keeping this totally in MS SQL as a stored procedure I
> can schedule to run periodically would be the simplest.
> Thanks for any suggestions or ideas on this.
> Also, from a Sharepoint standpoint, SPS nor WSS supports roll-ups for
> Events or any list, which is why I'm writing this on my own. Also
> there are third party plugins, but most are around $1600 or more, which
> is crazy since this can be done in MS SQL if I can only figure out the
> GUID bit.
> Thanks for any help or assistance --
> Sam
>