Hit highlight

Hi,
Does anyone know a simple way to highlight matches using full text indexes
in SQL Server 2005?
[]s
Jos
I responded to you on the private newsgroup - you may also want to look at
this http://www.indexserverfaq.com/sqlhithighlighting.htm
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
"Jos Antonio Farias" <jalf@.infocon.com.br> wrote in message
news:OACAh4eIGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Does anyone know a simple way to highlight matches using full text indexes
> in SQL Server 2005?
> []s
> Jos
>
|||Thanks Hilary.
"Hilary Cotter" <hilary.cotter@.gmail.com> escreveu na mensagem
news:OV4lrEqIGHA.3700@.TK2MSFTNGP15.phx.gbl...
>I responded to you on the private newsgroup - you may also want to look at
>this http://www.indexserverfaq.com/sqlhithighlighting.htm
> --
> 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
> "Jos Antonio Farias" <jalf@.infocon.com.br> wrote in message
> news:OACAh4eIGHA.3984@.TK2MSFTNGP14.phx.gbl...
>

Highlighting in tables.

I would like to highlight every other line in a table to enhance readability. Is there an easy way to do this? If so, how?

TIAHi Tia,

I just started writing custom code today - so naturally I think it can solve all problems!

I'm thinking you may be able to write custom code to set the table row's background
property based on if it is an "even" or "odd" row. I looked around and there doesn't
seem to be an easy way like we have on ASP.Net grid controls. Has anyone
done something like this using custom code?

Jane|||actually I thgt abt it for a while and its not very complicated. in your properties tab for that textbox or for the row, click on the color property and click on "Expressions" and you can write an expression over there like a regular one

 IIF(Fields!yourval.value <10, " Red", "Blue")

hth|||Dinakar,

Thanks! the expression I finally chose was:

=iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")

set on the row level properties tab in BackgroundColor. This highlights every other row of my table, making it easier to read.

Regards,

Daniel|||

chanbe backgound property of the table as =iif(((rownumber("table1") mod 2)=0),"White","#FFEBBD")

here "table1" is ur table name

sql

Highlighting a row

Hi,
While previewing the report, Is there any way to highlight the selected row as we do in SpreadSheets (Like Excel)?
I need to hightlight the row which was selected by the user and not a particular row.
If you have any idea, pls help me
ThanksHi,

Yes, it's possible in RDC Method of Crystal Report Design Document Module.

you can catch the table.field click event at run time, in that event make code for change the field background color.

Thanks.

Originally posted by harmonycitra
Hi,

While previewing the report, Is there any way to highlight the selected row as we do in SpreadSheets (Like Excel)?

I need to hightlight the row which was selected by the user and not a particular row.

If you have any idea, pls help me

Thanks|||Thanks,

But I'm using ASP to run my report, using RDC Code and Crystal Report ActiveXViewer Control to display the report.

In this, how can I write the code?

Thanks,

Highlight words from search expression

Hi,
I want to create a search engine which will display a short text
description in the surrounding of the searched words. The problem is I
can't find the exact words in my search phrase in the results because
of stemming. Is there any way I can which words in the results were
responsible finding this particular result due to stemming?
Thanks,
Lior
Microsoft's stemming algorithm is based on the Ported Stemming algorithm.
You can roll your own implementation of this, or something like this
http://www.indexserverfaq.com/sqlhithighlighting.htm
"Lior Shorshi" <lishorsh@.gmail.com> wrote in message
news:1177242161.666784.11460@.y5g2000hsa.googlegrou ps.com...
> Hi,
> I want to create a search engine which will display a short text
> description in the surrounding of the searched words. The problem is I
> can't find the exact words in my search phrase in the results because
> of stemming. Is there any way I can which words in the results were
> responsible finding this particular result due to stemming?
> Thanks,
> Lior
>

Highlight row

Hi,

After the report is rendered in the report viewer control (In windows forms application), I want to provide user with a facility to highlight rows (data). Is it possible with SSRS/Report viewer?

For example, amongst the list of 100 invoices, user should be able to highlight 10 invoices.

Thanks in advance.

Paresh

Not real easily. The only approach I can think of is to have a multi-value parameter on the report which contains invoice numbers. The user would need to select invoice report parameter values equal to the invoice numbers to highlight, then rerun the report checking to see if the row matched the selected report parameter values.

In other words, not real easily.

Highlight Results from search

>From what I have so far, Sql Server does not provide a way to return
its query results hits in a highlighted format. I was able to
programmatically get this working for simple searches, where I simply
do a find and replace based on the search criteria. But this will not
work for plural results or irregular type finds. For example, if I do
a search for "mouse", and sql server returns "mice", I have no way of
knowing to highlight "mice". I read that this can be done using
lemmatizer and stemmer algorithms. Is there an easier way of doing
this? If not, does anyone know of any .net api's or code I can get
started with?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179421330.863970.28850@.p77g2000hsh.googlegro ups.com...
> its query results hits in a highlighted format. I was able to
> programmatically get this working for simple searches, where I simply
> do a find and replace based on the search criteria. But this will not
> work for plural results or irregular type finds. For example, if I do
> a search for "mouse", and sql server returns "mice", I have no way of
> knowing to highlight "mice". I read that this can be done using
> lemmatizer and stemmer algorithms. Is there an easier way of doing
> this? If not, does anyone know of any .net api's or code I can get
> started with?
> Thanks
>
sql

Highlight Keywords

I am using asp.net (C#) to create full text searching using SQL Server
2005 in our application. Everything is working fine, but I am trying
to highlight the resultset keywords from the full text results. Can
sql server provide you with a way to highlight the keywords from the
full text search?
I was able to kind of hack it by programatically replacing my keyword
search terms with the sql server resultset. However, when I do certain
searches, like "Frank's", sql server will return Frank using my
CONTAINS query, and I want the other results like "Frank" to be
highlighted too. Anyone know a good way to go about doing this?
Thanks
You have to implement your own version of Porter stemmer algorithm for this.
You can use Indexing Services for this, here is a link describing how to do
this.
http://www.indexserverfaq.com/sqlhithighlighting.htm
"guate911" <guatemala911@.gmail.com> wrote in message
news:1179417689.771131.84700@.k79g2000hse.googlegro ups.com...
>I am using asp.net (C#) to create full text searching using SQL Server
> 2005 in our application. Everything is working fine, but I am trying
> to highlight the resultset keywords from the full text results. Can
> sql server provide you with a way to highlight the keywords from the
> full text search?
> I was able to kind of hack it by programatically replacing my keyword
> search terms with the sql server resultset. However, when I do certain
> searches, like "Frank's", sql server will return Frank using my
> CONTAINS query, and I want the other results like "Frank" to be
> highlighted too. Anyone know a good way to go about doing this?
> Thanks
>