db url to image

Hi All, I am pretty new to reporting services, but i have question regarding how to display an image when i pull the url from a database. I cannot seem to figure out how to do it and it seems pretty simple. If anyone has any ideas please let me know.

Thanks so much

josh

Josh..

Set the source in the report as external and the mime type depending on whatever file it is.

Regards

Karen

|||

Hi Josh,

For that you can set the value property of Image to that field (ie: field which contain url) and the source property to External.If its a picture from a folder/directory(local) add like

"file://"+Fields!Picture.Value

Thanks,

Sonu

db timestamp

I have a timestamp in a date field of a table I have but when run it does not enter the date automatically and all I get is system.byte[] display where the dtae and time should be, how can i get it so this field places the date in automatically.?i have resolved this with GETDATE() syntax etc thank youps sorry by the time it got approved I was able to solve itsql

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advance
In Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:

>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? or
>perhaps point me to performance tables which contain this data?
>Thanks in advance

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advanceIn Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:

>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? o
r
>perhaps point me to performance tables which contain this data?
>Thanks in advance

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advanceIn Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:
>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? or
>perhaps point me to performance tables which contain this data?
>Thanks in advance

Db Object Dependencies in DTS Package

I know I can right-click on a table and check its dependencies.
However, this does not display any DTS packages. Is there any way to do that?
No DTS package dependency information is stored. DTS packages are
application code rather than SQL objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"David Jessee" <DavidJessee@.discussions.microsoft.com> wrote in message
news:93BCBE19-041C-42C7-9EFA-EA38BC8EAC84@.microsoft.com...
>I know I can right-click on a table and check its dependencies.
> However, this does not display any DTS packages. Is there any way to do
> that?

Db Object Dependencies in DTS Package

I know I can right-click on a table and check its dependencies.
However, this does not display any DTS packages. Is there any way to do tha
t?No DTS package dependency information is stored. DTS packages are
application code rather than SQL objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"David Jessee" <DavidJessee@.discussions.microsoft.com> wrote in message
news:93BCBE19-041C-42C7-9EFA-EA38BC8EAC84@.microsoft.com...
>I know I can right-click on a table and check its dependencies.
> However, this does not display any DTS packages. Is there any way to do
> that?

Db Object Dependencies in DTS Package

I know I can right-click on a table and check its dependencies.
However, this does not display any DTS packages. Is there any way to do that?No DTS package dependency information is stored. DTS packages are
application code rather than SQL objects.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"David Jessee" <DavidJessee@.discussions.microsoft.com> wrote in message
news:93BCBE19-041C-42C7-9EFA-EA38BC8EAC84@.microsoft.com...
>I know I can right-click on a table and check its dependencies.
> However, this does not display any DTS packages. Is there any way to do
> that?