Does Image Control support missing images?

Is there a clever way to display an alternate image or message if the image
control cannot find the image as specified in the External URL?
In other words... we supply the image name via a field... But if the image
does not exist, we get the red X. I want to display something other than the
red X.
Any ideas?
Thanks,
JimIf you have SP1 installed, then you could use an expression like this to
"hide" non-existing external images.
=iif(Trim(Fields!ExternalImagePath.Value) = "", Nothing,
Fields!ExternalImagePath.Value)
I.e. if the image.Value expression evaluates to Nothing, no red X will be
shown.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim L" <jim@.noaddress.com> wrote in message
news:uL31USbdEHA.1648@.TK2MSFTNGP11.phx.gbl...
> Is there a clever way to display an alternate image or message if the
image
> control cannot find the image as specified in the External URL?
> In other words... we supply the image name via a field... But if the
image
> does not exist, we get the red X. I want to display something other than
the
> red X.
> Any ideas?
> Thanks,
> Jim
>|||Thanks Robert for taking the time to respond... however...
What I am looking for is this - The field will be populated with the name of
the image, we just don't know if the image will be there or not.
The image control in ASP.Net supports this - it will display a text message
instead of the Red X.
Jim
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23NIFYbbdEHA.1952@.TK2MSFTNGP11.phx.gbl...
> If you have SP1 installed, then you could use an expression like this to
> "hide" non-existing external images.
> =iif(Trim(Fields!ExternalImagePath.Value) = "", Nothing,
> Fields!ExternalImagePath.Value)
> I.e. if the image.Value expression evaluates to Nothing, no red X will be
> shown.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jim L" <jim@.noaddress.com> wrote in message
> news:uL31USbdEHA.1648@.TK2MSFTNGP11.phx.gbl...
> > Is there a clever way to display an alternate image or message if the
> image
> > control cannot find the image as specified in the External URL?
> >
> > In other words... we supply the image name via a field... But if the
> image
> > does not exist, we get the red X. I want to display something other than
> the
> > red X.
> >
> > Any ideas?
> >
> > Thanks,
> > Jim
> >
> >
>|||An image in Reporting Services is not an ASP.NET image control. The desired
functionality is currently not supported. The closest you can get today is:
* either "hiding" non-existing external images through expressions as
outlined in the previous posting
* or use an expression on the Visibility property of the Image reportitem to
conditionally hide non-existing images. The expression would make a call
into a custom assembly with the image path value as parameter and would
return true if the image exists - which would then not hide the Image
reportitem. So it is doable right now, but there is some work involved to
get it done.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim L" <jim@.noaddress.com> wrote in message
news:OWg%23LibdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Thanks Robert for taking the time to respond... however...
> What I am looking for is this - The field will be populated with the name
of
> the image, we just don't know if the image will be there or not.
> The image control in ASP.Net supports this - it will display a text
message
> instead of the Red X.
> Jim
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23NIFYbbdEHA.1952@.TK2MSFTNGP11.phx.gbl...
> > If you have SP1 installed, then you could use an expression like this to
> > "hide" non-existing external images.
> > =iif(Trim(Fields!ExternalImagePath.Value) = "", Nothing,
> > Fields!ExternalImagePath.Value)
> >
> > I.e. if the image.Value expression evaluates to Nothing, no red X will
be
> > shown.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "Jim L" <jim@.noaddress.com> wrote in message
> > news:uL31USbdEHA.1648@.TK2MSFTNGP11.phx.gbl...
> > > Is there a clever way to display an alternate image or message if the
> > image
> > > control cannot find the image as specified in the External URL?
> > >
> > > In other words... we supply the image name via a field... But if the
> > image
> > > does not exist, we get the red X. I want to display something other
than
> > the
> > > red X.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Jim
> > >
> > >
> >
> >
>

Does any version supprt embedding EMF (vector based) images into Reports?

Hi all,
Does any version of Reporting Services support embedding vector based images
(such as EMF's, or WMF's) into Reports?
RobHello Robert,
Based on my scope, SQL 2000/2005 reporting services do not support embed
EMF files in a report though you could render a report to EMF type files by
using Image Rendering Extension.
You may want to use image converter to convert EMF/WMF files to JPG etc so
that you could embed them into a report. Also, you could send your feedback
by clicking Send feddback button in toolbar in SQL 2005 Books Online.
All product or service suggestions received become the sole property of
Microsoft. Should a suggestion be implemented, Microsoft is under no
obligation to provide compensation.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
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: "Robert Hooker" <rhooker@.newsgroup.nospam>
>Subject: Does any version supprt embedding EMF (vector based) images into
Reports?
>Date: Tue, 13 Dec 2005 10:22:35 -0700
>Lines: 8
>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: <eqaLQnAAGHA.344@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: mail.optiframe.com 12.155.152.130
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:64952
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi all,
>Does any version of Reporting Services support embedding vector based
images
>(such as EMF's, or WMF's) into Reports?
>Rob
>
>

Does a large amount 'image' data affect overall SQL performance?

Recently we added a new table into our SQL2000 database specifically to store scanned in images of documents. This new table contains a PK field, a couple of datetime fields, a couple of char(1) fields and one 'image' field.

Before adding this table, the database size was approx 6GB. Six months after adding this new table, the database has grown to 18GB - 11GB of this is due to the scanned in images.

Would this new table affect the SQL performance with regards to accessing other data in the database that has nothing related to the new table?

If so, would moving this new table into it's own database be recommended?

Thanks

Rod

In order to determine the 'best' response to your question, you may find this article useful.

Images –Store in Database or Store in File System
http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45

Document stored as image, problem with inflectional search

Hello,
I'm storing documents (txt, html, etc) as images in my database, and can
run regular 'contains' searches on my data just fine, but when I use
formsof(inflectional,word), it will only return results that contain the
word exactly, not any inflectional forms of it.
Is this some known issue about the way indexing is done or how SQL
processes images? Or could something be wrong on my end?
My @.@.version is:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Thanks!
- Parhaum
Parhaum,
First of all, thank you for providing the @.@.version info as this is most
important in troubleshooting SQL FTS issues such as this one! Secondly, can
you post the exact formsof(inflectional,word) query & word or phrase that
you are having problems with along with the output of the following SQL
code?
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
There are several known words when used with the US English wordbreaker that
do not generate the correct or expected inflectional, see this thread
(http://www.webservertalk.com/archive.../t-965368.html) for more details.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Parhaum Toofanian via droptable.com" <forum@.nospam.droptable.com> wrote
in message news:141e567797a94b829e022eb7c3eb7ca2@.droptable.co m...
> Hello,
> I'm storing documents (txt, html, etc) as images in my database, and can
> run regular 'contains' searches on my data just fine, but when I use
> formsof(inflectional,word), it will only return results that contain the
> word exactly, not any inflectional forms of it.
> Is this some known issue about the way indexing is done or how SQL
> processes images? Or could something be wrong on my end?
> My @.@.version is:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Thanks!
> - Parhaum
|||did you use the ms.locale metatag to indicate the type of language your html
docs are stored in?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Parhaum Toofanian via droptable.com" <forum@.nospam.droptable.com> wrote
in message news:141e567797a94b829e022eb7c3eb7ca2@.droptable.co m...
> Hello,
> I'm storing documents (txt, html, etc) as images in my database, and can
> run regular 'contains' searches on my data just fine, but when I use
> formsof(inflectional,word), it will only return results that contain the
> word exactly, not any inflectional forms of it.
> Is this some known issue about the way indexing is done or how SQL
> processes images? Or could something be wrong on my end?
> My @.@.version is:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Thanks!
> - Parhaum
|||First of all, thank you both for your quick replies! Regarding the locale,
I can probably check, but it's a database in my company that I'm developing
with, so I'd need to ask the DBA about it.
Second, background on the database. The table with the image data is
J_DOCU_CONTENT, and I have uploaded many files including 3 sample .txt
files with text like "park services" and "servicing the shuttle". There's
a table called T_DOCUMENT that contains some other information, but even
running the last query without the T_DOCUMENT information returns the same
result.
Trying to do an inflectional search on "service" returns 0 results. An
inflectional search on "services" returns the park services file, and so
on, as if it were a 'contains' exact match search.
:: Result of:
:: EXEC sp_help_fulltext_columns;
TABLE_OWNER<x>
TABLE_ID<id>
TABLE_NAMEJ_DOCU_CONTENT
FULLTEXT_COLUMN_NAMEDATA
FULLTEXT_COLID4
FULLTEXT_BLOBTP_COLNAMEDOCUMENT_TYPE
FULLTEXT_BLOBTP_COLID3
FULLTEXT_LANGUAGE0
:: Result of:
:: EXEC sp_help J_DOCU_CONTENT;
NameJ_DOCU_CONTENT
Owner<x>
Typeuser table
Created_datetime2005-04-14 15:38:09.013
Column_namePRIMARY_KEY
Typeint
Computedno
Length4
Prec10
Scale0
Nullableno
TrimTrailingBlanks(n/a)
FixedLenNullInSource(n/a)
CollationNULL
Column_nameVERSION
Typeint
Computedno
Length4
Prec10
Scale0
Nullableno
TrimTrailingBlanks(n/a)
FixedLenNullInSource(n/a)
CollationNULL
Column_nameDOCUMENT_TYPE
Typevarchar
Computedno
Length250
Prec
Scale
Nullableno
TrimTrailingBlanksno
FixedLenNullInSourceno
CollationSQL_Latin1_General_CP1_CI_AS
Column_nameDATA
Typeimage
Computedno
Length7000
Prec
Scale
Nullableno
TrimTrailingBlanks(n/a)
FixedLenNullInSource(n/a)
CollationNULL
No identity column defined.
No rowguidcol column defined.
constraint_type
PRIMARY KEY (clustered)
:: Result of:
:: SELECT t1.NAME FROM J_DOCU_CONTENT t0, T_DOCUMENT t1 WHERE
::(contains(t0.DATA, ' FORMSOF(INFLECTIONAL, service) ')
::AND
::(t0.PRIMARY_KEY = t1.CONTENT_ID))
NAME
(0 row(s) affected)
Message posted via http://www.droptable.com
|||Yikes. Tried to format it from the direct SQL output, and not sure now
which ended up looking worse...
Message posted via http://www.droptable.com

Do you recommend storing images directly into the DB?

The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.98% of all articles or opinions I've seen reccomend storing them outside the DB. SQL is not a good storage mechanism for files.

HTH|||Originally posted by fused
The images each are in Jpeg format (black and white, with some grey scale). File size wise, wouldnt be huge < 50 KB.

There wont be too many people using the system.

Would it be tedious to maintain? Many people recommend storing the path to the graphic instead.

Please advise. Thanks.

We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.|||Originally posted by jimpen
We have a proffesianally built imaging system that stores all the images on the disk and just references them from the database.

I agree that they should be left outside the DB.

Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.|||I have an ASP app that does this sort of thing. I read through the directories, and display the file names as hyperlinks without even using a db connection. This method works really well if you can get the user to name the files in such a way that the links on the page look ok...which is normally not an easy task, but it's worked pretty well for me...But this is an IntrAnet app. , not a web app..|||We use ASP.Net with C# on Windows IIS. You know the IP of the computer, create a sub directory (eg /Images) and use a component that looks in this directory (we use Borland C# Builder but Visual Studio will have this probably as well). To let users upload their images, you can use ASPUpload (www.aspupload.com)|||Originally posted by fused
Right now, we are planning a project to store some images. What's the scripting language that you use? Any advice? Thanks.

So you guys have a file server that has permission given to everyone? And when you upload the pic, the picture is moved to the shared file server? And a path is inserted into the sql server?

Please advise.

Ours is provided by a VAR of http://www.imagesoft.com/.

Read permissions are given by group as well as write. We have different sections that are available to different groups depending on what they need/are allowed to see.