Full text search for Arabic and English

Hi all,

I have a database which i use for Arabic and English text, i want to know if i can use the full text search for this database. The default language is Latin but i can recreate the db using Arabic BIN as default.

Thanks in advance

Haidar,
While SQL Server (7.0 and 2000 - Which version are you using?) both fully support the Arabic language, Full-Text Search only supports a "subset" of SQL Server supported languages and Arabic is not one of those languages. However, you can use the Neutral "Language for Word Breaker" when you setup the FT Catalog via the FT Indexing Wizard under SQL Server 2000. If you're using SQL Server 7.0,
you will have to set the entire server to the "Neutral" language setting via sp_configure. The supported subset of languages supported by SQL Server for
FTS is documented in the Books Online (BOL)....

In addition to the BOL documentation, there is now on MSDN - "Arabic Language Support in Microsoft SQL Server 2000" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_arabicsupport.asp that might also be helpful to you.

Finally, you might also want to download and test a Microsoft developed Arabic wordbreaker and you can download the Microsoft Arabic Word-Breaker (Arabic Search Engine) at
http://www.microsoft.com/middleeast/arabicdev/beta/search/ as this might be a solution to your problem!

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

sql

Full screen when viewing a report by default

Is there a way that I can link to a report and have the report come up in full screen (without toggling the button in the toolbar)? I am hosting a report in our intranet site and I would like it to load the report without the header information above the tabs. Right now I have to click the little toggle to go to full screen.

I did try to run the javascript from the frame where the link to the report is hosted, but it said access denied.

Hi, Im not not sure where this originates from but a report writer in our org passed me this , to open reports from my application.

OpenPopUp(Button2, "http://bfr06/Reportserver?/Non+Rencs+Reports/bck_live_Supplier_NCR_Notification_Reply&rs:command=render&NCR=" & lblNCR_REF.Text, "", 750, 300)

Basically in the Server Reporting docs is a list of Params which the server uses, also using the JS Openpopup idea you can specify window properties too.

Hope that helps.

Alan

Full Screen in Report Manager?

Hi all...
I'm curious if there is a way to default to "full screen" mode when a
user first views a report through report manager. The users here can
click the arrows on the right side and thus make the "header" of the
page collapse, but is there a way to default to that so that the users
don't have to click the arrows?
I had read something about the option to collapse the parameter portion
of the report coming with SP1, which we just installed, but haven't
been able pinpoint how to do it.
We've also given users to ability to access reports via our intranet by
physically typing in the address to our intranet. That address
redirects to the report server - wondering if this may make a
difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattIn the link you use to call the report add in &rc:Toolbar=false and
possibly &rc:Parameters=false to remove everything.
ie
src="http://myreportserver/ReportServer?%2fReportfolder%2fParameter&rc%3aParameters=false&rc:LinkTarget=_self&rc:ToolBar=false"|||Thanks for the info! I know that the answer to my problem is in there
somewhere, but when I copy what you have after
"myreportserver/ReportServer" in the link above and add it to the URL
that my project points to, I'm being asked for login/password, and that
shouldn't be happening?
Am I able to take parts of what you wrote above to make the parameters
not be viewable? Sorry to wollow in the details of this as I'm guessing
it's not all that complicated, but it's the first time I've given this
a shot, so thanks for your patience.
Matt|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Thanks once again for the help.
When I add the piece to suppress parameters and/or the toolbar, I end
up with this link as what is entered for the TargetURL for the
solution:
http://servername/ReportServer&rc:ToolBar=false
When I hit F5 to push the changes to the server, I end up getting the
following:
"A connection could not be made to the report server
http://servername/ReportServer&rc:ToolBar=false"
Any idea what I'm missing or doing wrong here? Do I need a "?" directly
after "reportserver"....this is one of those things that is a small
problem, but the annoyance that it is causing is growing!!
Again, thanks for the help...
Matt

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Ful Text Search

People,

I'm working with Full-Text Indexing on SQL 2000 SP3. And like to use the Default Language for word Breaker = Portuguese.

Or something like this.

I have already tried on Technet and MSDN Web Site.
But didn't have success.

Suggestions??

Thanks a lot.See page 39
http://www.microsoft.com/israel/msdn/downloads/netweb/SISiteServer.ppt

I was searching for it some time before. And that is all I have found ;)|||I had already found this document too.

But using the Neutral word breaker I don't get Verbal functions in my language. (Portuguese Brazil).

Thanks a Lot!