non-typesafe data reporting

I have vb.net 2005 code that generates data that needs to be reported.
The results need to be reported in generic text fields in the rdlc
report. Sometimes I will report 2 text values while the next time I
may report 3 values in the report text box.
My problem is that I can't pass this program generated data to the text
fields on the report. I used to do this and can still do this in
crystal reports and active reports by generating text objects on the
report followed by creating an instance of the report. Next the
instance property (any of the text boxes) value is set by means of
setting the parameter. Lastly generate the report.
In summary, I need to be able to pass specific program generated text
values to text boxes to a Microsoft report by NOT using a dataset or
datatable.
Thanks all
(crystal example)
Dim i As New CrystalReport1
i.SetParameterValue("Parameter_X", "test value for text box on
report")Use hidden report parameters. Then hide or show the textbox based on whether
the parameter is filled in or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <Chris.Grimm@.ormet.com> wrote in message
news:1134161274.196063.122960@.g47g2000cwa.googlegroups.com...
>I have vb.net 2005 code that generates data that needs to be reported.
> The results need to be reported in generic text fields in the rdlc
> report. Sometimes I will report 2 text values while the next time I
> may report 3 values in the report text box.
> My problem is that I can't pass this program generated data to the text
> fields on the report. I used to do this and can still do this in
> crystal reports and active reports by generating text objects on the
> report followed by creating an instance of the report. Next the
> instance property (any of the text boxes) value is set by means of
> setting the parameter. Lastly generate the report.
> In summary, I need to be able to pass specific program generated text
> values to text boxes to a Microsoft report by NOT using a dataset or
> datatable.
> Thanks all
> (crystal example)
> Dim i As New CrystalReport1
> i.SetParameterValue("Parameter_X", "test value for text box on
> report")
>

Non-noise words are incorrectly recognised as noise words.

Hi.
I have an Sql server 2005 beta2 problem with the full-text index
functionality.
I have a table with a full text index. In the definition of the full-text
index, I have specified the neutral language. The problem domain specifies
that texts can be in arbitrary languages.
create fulltext index on mytable
(
myfield language 0x0
)
..
Then I insert a record containing the word "and" (which in Danish means
duck). When searching for that record
select * from mytable where contains(myfield, 'and')
nothing is returned, and I get the message,"Informational: The full-text
search condition contained noise word(s)."
Apperantly, it uses the noise-word list for english, when I insert records
and search on that field.
I thought that when I specify the language as 0x0, the full-text index
should be language neutral and that would mean that it doesn't filter out
noise words(because those are language specific). Am I mistaken, or is it an
Sql Server 2005 beta2 bug?
Thanks in advance,
Peter Striman> I have an Sql server 2005 beta2 problem with the full-text index
> functionality.
Please post to the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1|||Hello,
For questions of SQL server 2005, please post at the following newsgroup:
Welcome to the Microsoft SQL Server 2005 Community Technology (CTP)
Newsgroups
<http://communities.microsoft.com/ne...sqlserver2005&s
lcid=us>
Thanks for cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
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.sql

Noisewords during insertation and during query

Hello, I wonder:

When I insert a text into a fulltexttable, the noisewords will be eliminated. Fine!

When I query, will the noiswords be eliminated automatically as well?

Thanks

Thomas

Thomas Boffo, (FRA) wrote:

When I insert a text into a fulltexttable, the noisewords will be eliminated. Fine!

? Where did you get that information from ? The noisewords will not be eliminated in the table, they will not be listed in the fulltext catalog, but they are still existing in the table.

Thomas Boffo, (FRA) wrote:

When I query, will the noiswords be eliminated automatically as well?

Depending on your setup language for wordbreaking the noise words will be eliminated according to the entries in the (language sensitive) noise word catalog.

Jens K. Suessmeyer

httpL://www.sqlserver2005.de

Noise words issue in full text seach Sql server 2000

Hi All,

I have been using full text search in my application for search purpose.
But on certain words i.e Noise Words such as And,After,About etc.
I am receiving the following error:

Execution of a full-text operation failed. A clause of the query contained only ignored words.

I tried a lot to sort out this issue,but this is going to be out of my scope.
If anybody can help me then it would be really appreciable.

Thanks in Advance,
Vivek RathoreFull-text maintains a list of noise words in different files which are language specific. When you receive the Msg 7619 The query contained only ignored words" SQL server has eliminated all words in the query. If you would like to search on those words you can try utilizing FREETEXT or editing the files maintaining the list of noise words.

These noise-word lists should be sufficient for most normal operations, but can be modified for specific environments with a text editor. For more information, see the Indexing Service 2.0 documentation in the Windows NT 4.0 Option Pack.