Showing posts with label word. Show all posts
Showing posts with label word. Show all posts

Friday, March 30, 2012

problem in freetext search in MS SQL Server

hi
i have problem in fulltex search, when i search any
english word it give me perfect result.
In my table i have define fulltext search on a column
name content_html, data type of column is ntext it
stores htlm content.
now when i search any unicode character(gujarati word)
it shows me content which not contain the search
value.
if anyone know the solution
pls help urgent
What word breaker are you using? You really should store your data in
columns of the image data type and have a document type column containing
the value of htm or html.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Mahesh" <mahesh.anjani@.gmail.com> wrote in message
news:1141816487.482238.60840@.j33g2000cwa.googlegro ups.com...
> hi
> i have problem in fulltex search, when i search any
> english word it give me perfect result.
> In my table i have define fulltext search on a column
> name content_html, data type of column is ntext it
> stores htlm content.
> now when i search any unicode character(gujarati word)
> it shows me content which not contain the search
> value.
> if anyone know the solution
> pls help urgent
>

Wednesday, March 28, 2012

Problem in Export to PDF or Excel

My report contains some Korean wording. When I export to PDF, the Korean
word appear as ?. Then I export the report in Excel format, there is no
problem in the Korean wording. But when I try to print it, the default page
orientation is 'Landscape' and there is default left and right margin no
matter how I adjust the report size in reporting services. Can anybody help
me ?You should be able to fix the orientation to landscape by switching the size
of the page (8.5x11 versus 11x8.5).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:5B32F2DF-371B-4951-85BB-B5F550C64095@.microsoft.com...
> My report contains some Korean wording. When I export to PDF, the Korean
> word appear as ?. Then I export the report in Excel format, there is no
> problem in the Korean wording. But when I try to print it, the default
> page
> orientation is 'Landscape' and there is default left and right margin no
> matter how I adjust the report size in reporting services. Can anybody
> help
> me ?|||But my report be shown in 'Portrait'.
"Jeff A. Stucker" wrote:
> You should be able to fix the orientation to landscape by switching the size
> of the page (8.5x11 versus 11x8.5).
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:5B32F2DF-371B-4951-85BB-B5F550C64095@.microsoft.com...
> > My report contains some Korean wording. When I export to PDF, the Korean
> > word appear as ?. Then I export the report in Excel format, there is no
> > problem in the Korean wording. But when I try to print it, the default
> > page
> > orientation is 'Landscape' and there is default left and right margin no
> > matter how I adjust the report size in reporting services. Can anybody
> > help
> > me ?
>
>|||What is the size of the report (page width, page height)?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:98F66BD1-48F0-43F1-AA23-32CE727DC2F1@.microsoft.com...
> But my report be shown in 'Portrait'.
> "Jeff A. Stucker" wrote:
>> You should be able to fix the orientation to landscape by switching the
>> size
>> of the page (8.5x11 versus 11x8.5).
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
>> news:5B32F2DF-371B-4951-85BB-B5F550C64095@.microsoft.com...
>> > My report contains some Korean wording. When I export to PDF, the
>> > Korean
>> > word appear as ?. Then I export the report in Excel format, there is
>> > no
>> > problem in the Korean wording. But when I try to print it, the default
>> > page
>> > orientation is 'Landscape' and there is default left and right margin
>> > no
>> > matter how I adjust the report size in reporting services. Can anybody
>> > help
>> > me ?
>>|||page width = 8.5
page height=11
"Jeff A. Stucker" wrote:
> What is the size of the report (page width, page height)?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:98F66BD1-48F0-43F1-AA23-32CE727DC2F1@.microsoft.com...
> > But my report be shown in 'Portrait'.
> >
> > "Jeff A. Stucker" wrote:
> >
> >> You should be able to fix the orientation to landscape by switching the
> >> size
> >> of the page (8.5x11 versus 11x8.5).
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> >> news:5B32F2DF-371B-4951-85BB-B5F550C64095@.microsoft.com...
> >> > My report contains some Korean wording. When I export to PDF, the
> >> > Korean
> >> > word appear as ?. Then I export the report in Excel format, there is
> >> > no
> >> > problem in the Korean wording. But when I try to print it, the default
> >> > page
> >> > orientation is 'Landscape' and there is default left and right margin
> >> > no
> >> > matter how I adjust the report size in reporting services. Can anybody
> >> > help
> >> > me ?
> >>
> >>
> >>
>
>|||Can anyone help me ?
My question is :
My report contains some Korean wording. When I export to PDF, the Korean
word appear as ?. Then I export the report in Excel format, there is no
problem in the Korean wording. But when I try to print it, the default page
orientation is 'Landscape' and there is default left and right margin no
matter how I adjust the report size in reporting services.
"May Liu" wrote:
> page width = 8.5
> page height=11
> "Jeff A. Stucker" wrote:
> > What is the size of the report (page width, page height)?
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> > news:98F66BD1-48F0-43F1-AA23-32CE727DC2F1@.microsoft.com...
> > > But my report be shown in 'Portrait'.
> > >
> > > "Jeff A. Stucker" wrote:
> > >
> > >> You should be able to fix the orientation to landscape by switching the
> > >> size
> > >> of the page (8.5x11 versus 11x8.5).
> > >>
> > >> --
> > >> Cheers,
> > >>
> > >> '(' Jeff A. Stucker
> > >> \
> > >>
> > >> Business Intelligence
> > >> www.criadvantage.com
> > >> ---
> > >> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> > >> news:5B32F2DF-371B-4951-85BB-B5F550C64095@.microsoft.com...
> > >> > My report contains some Korean wording. When I export to PDF, the
> > >> > Korean
> > >> > word appear as ?. Then I export the report in Excel format, there is
> > >> > no
> > >> > problem in the Korean wording. But when I try to print it, the default
> > >> > page
> > >> > orientation is 'Landscape' and there is default left and right margin
> > >> > no
> > >> > matter how I adjust the report size in reporting services. Can anybody
> > >> > help
> > >> > me ?
> > >>
> > >>
> > >>
> >
> >
> >