PDF Full Text Search

Hi all,

I have a table configured to support Full-Text Search and in this tables a column stores documents of three types, Word, Excel and PDF. Everything works fine with Word and Excel documents.

In order to search PDF documents I've installed "IFilter 5.0", which is published in Acrobat's page, but nothing. What else should I do, is there any other solution?

I've read that I can create a particular filter, so the question is where can find information about creating customized filters? But first, is it a good business to create a new filter?

Thanks in advance.Dear mvargasp,
I have a problem about FTS. I think you could help me...
I wrote to forum but nobody reply to me...

I need your help,
Thanks alot
Yusuf
--------
I've a problem. I'm inexperienced about FTS.
I have a TEXT datatype field in my table and I store MS Word documents.

I want to do full text search on this TEXT datatype field.
So I build catalog and run

"Select * from table where Contains (textfield,'Yusuf')" sql in analyzer.

but null value returns. however I know the table has 3 records.

Anyway, I insert a varchar field in the table and edit my fts catalog.
and then insert 3 records in the table.than rebuild catalog and I try
"Select * from table where Contains (varcharfield,'Yusuf')"
this sql returns true records.

I know that I can FTS in TEXT datatype field but I can't. I don't know why.
I need your help.
thanks alot

Yusuf|||Hi Yusuf,

It seems that you have created a catalog and rebuild it then, but you have not populate it. So What you must do after you create or rebuild a catalog is to populate it. I order to do so, you must right click your catalog in the Enterprise Manager and then click Populate.

After this the FTS must work.

God Bless.

PDF export and invisible columns

I have a report with some columns that are visible\invisible based on a
parameter value. The report renders fine in HTML and when exported to Excel.
But when its exported to PDF the report shows blank white space for some of
the columns that are invisible, e.g. the report is 3 pages wide when the
collumns are all visible, it is 1 page wide when some are invisible, but if
you export the 1 page wide report to PDF it still comes out as 3 pages wide,
with the last 2 pages just alll blank space.
ANything I can do?Did you find any solutions? I had teh same problem.
I am setting the visibility for the Rows through the expression. They are
not showing in HTML mode. However, If I export to PDF it shows some white
spaces.
"NH" wrote:
> I have a report with some columns that are visible\invisible based on a
> parameter value. The report renders fine in HTML and when exported to Excel.
> But when its exported to PDF the report shows blank white space for some of
> the columns that are invisible, e.g. the report is 3 pages wide when the
> collumns are all visible, it is 1 page wide when some are invisible, but if
> you export the 1 page wide report to PDF it still comes out as 3 pages wide,
> with the last 2 pages just alll blank space.
> ANything I can do?|||Hi,
No, never found a solution. I am afraid that you dont get many replies to
your queries in this forum.
"GC" wrote:
> Did you find any solutions? I had teh same problem.
> I am setting the visibility for the Rows through the expression. They are
> not showing in HTML mode. However, If I export to PDF it shows some white
> spaces.
>
> "NH" wrote:
> > I have a report with some columns that are visible\invisible based on a
> > parameter value. The report renders fine in HTML and when exported to Excel.
> > But when its exported to PDF the report shows blank white space for some of
> > the columns that are invisible, e.g. the report is 3 pages wide when the
> > collumns are all visible, it is 1 page wide when some are invisible, but if
> > you export the 1 page wide report to PDF it still comes out as 3 pages wide,
> > with the last 2 pages just alll blank space.
> >
> > ANything I can do?|||I have experienced something like this before...the problem is that in
order to shrink up the hidden columns then you will need to set the
visibility property on each column, not just the tablerow. Very
tedious but I believe that this may be what your report needs...
Matt A|||i have a similar problem. html & xls work fine, but when you export to
csv, the columns are hidden no matter what you do...
reportdude wrote:
> I have experienced something like this before...the problem is that in
> order to shrink up the hidden columns then you will need to set the
> visibility property on each column, not just the tablerow. Very
> tedious but I believe that this may be what your report needs...
> Matt A|||Thanks for the Update. I have tried the option of applying the Expression for
the Visibiliy of every cell in that Row. Still it doesn't make any difference.
This is creating space at the end of the Report. ( I have few Sub Reports).
If I set the hidden false then the white spaces are disappearing. However
this works well in HTML Viewer.
"reportdude" wrote:
> I have experienced something like this before...the problem is that in
> order to shrink up the hidden columns then you will need to set the
> visibility property on each column, not just the tablerow. Very
> tedious but I believe that this may be what your report needs...
> Matt A
>

PDF and Excel Issues

I have two issues when exporting a report to Excel or pdf.
1. When exporting to pdf, the underline font attribute is lost. Is
this a version issue or is there something I can do to circumvent this
(other than place a border on the text box which will look bad)?
2. When exporting to pdf and Excel, I am getting a lot of white space
at the start of the report (in pdf) or between list items (in excel).
The pdf white space is almost an entire page.
I am using Reporting Services SP1.I am not seeing the first issue. I can successfully export textboxes with
underline set.
On the second one, do you have CanGrow on textboxes with extra content in
them (spaces, returns)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lara" <wwilliam@.umn.edu> wrote in message
news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
>I have two issues when exporting a report to Excel or pdf.
> 1. When exporting to pdf, the underline font attribute is lost. Is
> this a version issue or is there something I can do to circumvent this
> (other than place a border on the text box which will look bad)?
> 2. When exporting to pdf and Excel, I am getting a lot of white space
> at the start of the report (in pdf) or between list items (in excel).
> The pdf white space is almost an entire page.
> I am using Reporting Services SP1.|||Perhaps the first issue is a font issue on the client? I am going to
research this tomorrow. The underline was not in a text box, rather
in a table group header.
I do have some text boxes with cangrow, but they are pretty limited in
size. When I looked at the PDF, it was not really empty space, rather
it was not writing some of the report items. I have a table in a list
box for employee data. The report required a parameter which would
then render the report for that company. Some of the employee tables
were not writing to PDF - it would skip the first 6-7 employees and
pick up from there. I was actually able to address this with
rewriting some of the report. The list was grouping on a number of
items, some of which could be null. I addressed the null in the
stored procedure so that it was replaced with an actual value, and
that seemed to work. Those nasty nulls can sneak up on you! It
should be noted that this was consistant for specific parameters which
caused larger reports. The small one to two page reports didn't seem
to have an issue, with or without nulls.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> I am not seeing the first issue. I can successfully export textboxes with
> underline set.
> On the second one, do you have CanGrow on textboxes with extra content in
> them (spaces, returns)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Lara" <wwilliam@.umn.edu> wrote in message
> news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> >I have two issues when exporting a report to Excel or pdf.
> >
> > 1. When exporting to pdf, the underline font attribute is lost. Is
> > this a version issue or is there something I can do to circumvent this
> > (other than place a border on the text box which will look bad)?
> >
> > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > at the start of the report (in pdf) or between list items (in excel).
> > The pdf white space is almost an entire page.
> >
> > I am using Reporting Services SP1.|||OK, I misspoke when I related my solution to the missing data. I had
been trying a couple of things, and the null grouping wasn't the
solution. Actually, here is the skinny.
I have a table of employee data. I had a list which grouped the
employee id inside a group for location which was inside a group for
company. All of these list groups were necessary to provide the
different pieces of information to the user. A text box with the
employee name was placed in the employee list group and also a table
provided the detail employee information necessary. When this is
rendered to the Report Manager, all is visible as expected. When I
render to PDF, the first several employees are missing with the larger
reports.
To work around this issue, I instead placed a table header with the
employee name on the table and removed the Employee id list. This
table was then placed in the location group. All data is now
rendered as expected in PDF. This is not as the users hoped, as the
text box allowed me to move the employee name where they wanted on the
report and I am a bit more limited with the table grouping.
If you would like any further information, please feel free to contact
me at lara(dot)rubbelke(at)born(dot)com.
Thanks!
wwilliam@.umn.edu (Lara) wrote in message news:<ca6a3f4a.0406291706.5162366a@.posting.google.com>...
> Perhaps the first issue is a font issue on the client? I am going to
> research this tomorrow. The underline was not in a text box, rather
> in a table group header.
> I do have some text boxes with cangrow, but they are pretty limited in
> size. When I looked at the PDF, it was not really empty space, rather
> it was not writing some of the report items. I have a table in a list
> box for employee data. The report required a parameter which would
> then render the report for that company. Some of the employee tables
> were not writing to PDF - it would skip the first 6-7 employees and
> pick up from there. I was actually able to address this with
> rewriting some of the report. The list was grouping on a number of
> items, some of which could be null. I addressed the null in the
> stored procedure so that it was replaced with an actual value, and
> that seemed to work. Those nasty nulls can sneak up on you! It
> should be noted that this was consistant for specific parameters which
> caused larger reports. The small one to two page reports didn't seem
> to have an issue, with or without nulls.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> > I am not seeing the first issue. I can successfully export textboxes with
> > underline set.
> >
> > On the second one, do you have CanGrow on textboxes with extra content in
> > them (spaces, returns)?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Lara" <wwilliam@.umn.edu> wrote in message
> > news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> > >I have two issues when exporting a report to Excel or pdf.
> > >
> > > 1. When exporting to pdf, the underline font attribute is lost. Is
> > > this a version issue or is there something I can do to circumvent this
> > > (other than place a border on the text box which will look bad)?
> > >
> > > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > > at the start of the report (in pdf) or between list items (in excel).
> > > The pdf white space is almost an entire page.
> > >
> > > I am using Reporting Services SP1.

Password protection on subscription-based Excel reports

I know RS doesn't offer this now.
I'm trying to figure out a workaround.
I need to:
-run a report on a schedule
-render it to excel
-password protect it
-email it
Subscriptions would be fine if it weren't for the password issue.
I've got DotNet code create the reprot and render it as an Excel
spreadsheet.
I've got code to password-protect the spreadsheet.
I want code to control the above code - to run at a certain time and
then deliver it via email. But it doesn't look like the Subscriptions
object will do this. Subscriptions appears to create the report and
deliver it, but not allow intervention for something like password
protection.My suggestion is that you use a script outside of Reporting Services to send
the mail. You can use CDO or .NET web mail. YOu can then schedule this using
Windows scheduler.
Try using the following code in a VB Console Application (you need to add a
reference of System.Web.dll to your project):
Imports System.Web.Mail
Module Module1
Dim oMail As MailMessage = New MailMessage
Sub Main()
oMail.From = "user@.mydomain.com"
oMail.To = "administrator@.classroom.com"
oMail.Subject = "Sending Using Web Mail"
oMail.BodyFormat = MailFormat.Text
oMail.Body = "Password protected file."
Dim myfile As String = "c:\Myfile.xls"
Dim oAttachment As MailAttachment = New MailAttachment(myfile)
oMail.Attachments.Add(oAttachment)
SmtpMail.SmtpServer = "10.1.1.200"
SmtpMail.Send(oMail)
oMail = Nothing
oAttachment = Nothing
End Sub
End Module
HTH
Charles Kangai, MCT, MCDBA
"Jay" wrote:
> I know RS doesn't offer this now.
> I'm trying to figure out a workaround.
> I need to:
> -run a report on a schedule
> -render it to excel
> -password protect it
> -email it
> Subscriptions would be fine if it weren't for the password issue.
> I've got DotNet code create the reprot and render it as an Excel
> spreadsheet.
> I've got code to password-protect the spreadsheet.
> I want code to control the above code - to run at a certain time and
> then deliver it via email. But it doesn't look like the Subscriptions
> object will do this. Subscriptions appears to create the report and
> deliver it, but not allow intervention for something like password
> protection.
>|||The best solution here is to create a custom delivery extension.
--
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"Jay" <jaytaylor_it@.hotmail.com> wrote in message
news:a737af3c.0411291503.60317abc@.posting.google.com...
>I know RS doesn't offer this now.
> I'm trying to figure out a workaround.
> I need to:
> -run a report on a schedule
> -render it to excel
> -password protect it
> -email it
> Subscriptions would be fine if it weren't for the password issue.
> I've got DotNet code create the reprot and render it as an Excel
> spreadsheet.
> I've got code to password-protect the spreadsheet.
> I want code to control the above code - to run at a certain time and
> then deliver it via email. But it doesn't look like the Subscriptions
> object will do this. Subscriptions appears to create the report and
> deliver it, but not allow intervention for something like password
> protection.|||Thanks. This looks like the way to go. I think I"ll have to go outside RS. I
don't think a delivery extension can handle this.
"Charles Kangai" wrote:
> My suggestion is that you use a script outside of Reporting Services to send
> the mail. You can use CDO or .NET web mail. YOu can then schedule this using
> Windows scheduler.
> Try using the following code in a VB Console Application (you need to add a
> reference of System.Web.dll to your project):
> Imports System.Web.Mail
> Module Module1
> Dim oMail As MailMessage = New MailMessage
> Sub Main()
> oMail.From = "user@.mydomain.com"
> oMail.To = "administrator@.classroom.com"
> oMail.Subject = "Sending Using Web Mail"
> oMail.BodyFormat = MailFormat.Text
> oMail.Body = "Password protected file."
> Dim myfile As String = "c:\Myfile.xls"
> Dim oAttachment As MailAttachment = New MailAttachment(myfile)
> oMail.Attachments.Add(oAttachment)
> SmtpMail.SmtpServer = "10.1.1.200"
> SmtpMail.Send(oMail)
> oMail = Nothing
> oAttachment = Nothing
> End Sub
> End Module
>
> HTH
> Charles Kangai, MCT, MCDBA
>
> "Jay" wrote:
> > I know RS doesn't offer this now.
> >
> > I'm trying to figure out a workaround.
> >
> > I need to:
> >
> > -run a report on a schedule
> > -render it to excel
> > -password protect it
> > -email it
> >
> > Subscriptions would be fine if it weren't for the password issue.
> >
> > I've got DotNet code create the reprot and render it as an Excel
> > spreadsheet.
> > I've got code to password-protect the spreadsheet.
> >
> > I want code to control the above code - to run at a certain time and
> > then deliver it via email. But it doesn't look like the Subscriptions
> > object will do this. Subscriptions appears to create the report and
> > deliver it, but not allow intervention for something like password
> > protection.
> >|||Thanks. I don't get it, though - it looks like whatever custom delivery
extension I'd create, I'd still need to use RS's CreateSubscription method.
How woud I be able to insert password protection into the process when the
subscription kicks off?
"Peter Blackburn (www.sqlreportingservice" wrote:
> The best solution here is to create a custom delivery extension.
> --
> Peter Blackburn
> Windows Server Systems - SQL Server MVP
> Hitchhiker's Guide to SQL Server 2000 Reporting Services
> http://www.sqlreportingservices.net
>
> "Jay" <jaytaylor_it@.hotmail.com> wrote in message
> news:a737af3c.0411291503.60317abc@.posting.google.com...
> >I know RS doesn't offer this now.
> >
> > I'm trying to figure out a workaround.
> >
> > I need to:
> >
> > -run a report on a schedule
> > -render it to excel
> > -password protect it
> > -email it
> >
> > Subscriptions would be fine if it weren't for the password issue.
> >
> > I've got DotNet code create the reprot and render it as an Excel
> > spreadsheet.
> > I've got code to password-protect the spreadsheet.
> >
> > I want code to control the above code - to run at a certain time and
> > then deliver it via email. But it doesn't look like the Subscriptions
> > object will do this. Subscriptions appears to create the report and
> > deliver it, but not allow intervention for something like password
> > protection.
>
>

Password Protected Excel File

Hi

I'm in need of a bit of assitance here. Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.

On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected. This is throwing an error when I try to run the package.

Does anyone know how to read a password protected excel file?

Thanks
Kismet123You cannot access a password-protected Excel file using the Jet OLE DB Provider, period.

I probably shouldn't mention this, but as an interesting tidbit of useless knowledge, the Provider can access the file if it is open at the same time in the Excel application...and without even providing the password. But doing so causes a huge memory leak in the Excel process that's going to bring things down sooner or later.
Q319998 BUG: Memory Leak When You Query Open Excel Worksheet with ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319998

-Doug
|||Thanks for that information Doug. Could you possibly tell me what the Password property is referring to when you create an Excel Connection Manager. I thought it would have something to do with if the connection you are making is password protected.

Kismet

Password Protect excel

I want to deliver reports in Excel format via a data-driven subscription to a
fileshare. Can I password-protect the Excel files?To my knowledge, password protection for excel rendering isn't supported in
RS. You can probably render to a folder location and write a FileWatcher or
service to custom manipulate the rendered excel reports in order to password
protect.
Adrian M.
"Dave Morrow" <DaveMorrow@.discussions.microsoft.com> wrote in message
news:1D098B85-B9E0-4F92-9C6D-6F918F96706F@.microsoft.com...
>I want to deliver reports in Excel format via a data-driven subscription to
>a
> fileshare. Can I password-protect the Excel files?

Password Proctected Excel Subscription

I need to send protected information via a reporting services subscripiton. Unfortunately the receiver can not access our reporting services web page so I have to send it as an excel attachment with email. Is there a way I can protect the spreadsheet automatically before it is sent via the subscription.

Thanks

Reporting Services doesn't currently have a DRM/IRM or Excel password feature, so you would have to post-process the Excel files that RS generates.|||Thanks but I'm still not sure how I'd do that without programming.|||You will have to do some programming, or open the Excel files in Excel and modify them.