Showing posts with label document. Show all posts
Showing posts with label document. Show all posts

Thursday, March 29, 2012

Embedding PDF Document

Does reporting services allow emdedding of PDF documents? I dont want to convert the document to JPEG as the size increases many times (for me the image size is around 1.6MB vs. 100KB for PDF) and i have several of these images. Would appreciate if anyone has done similar exercise to embed document within reports.
thanks !!Not sure what we would really embed it in? HTML isn't really a format that
supports embedding. You can embed docs in e-mail messages as well as link to
docs on a web page. I suppose we could have an MHTML format that embedded a
PDF file but this hasn't been high on the priority list.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
> Does reporting services allow emdedding of PDF documents? I dont want to
> convert the document to JPEG as the size increases many times (for me the
> image size is around 1.6MB vs. 100KB for PDF) and i have several of these
> images. Would appreciate if anyone has done similar exercise to embed
> document within reports.
> thanks !!|||But where is the PDF document stored? You can't 'embed' documents in a web
page. Can you just link to the document on a web site from the report? You
could even store the PDF in the Report Server database and link to it.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:111C7F98-B8FF-4F7A-AF74-E14F9EE1650E@.microsoft.com...
> Thanks Brian !
> The issue I have is that I need to embed pre-generated PDF documents into
> the report and I am not sure how can I do that unless I convert the PDF
> into JPEG and then use the IMAGE control to embed. This works fine -
> however the size increase makes the report useless. For example, a 100KB
> PDF becomes 1.6MB JPEG file and you can imagine the generate and print
> pains if I have 10-20 of those images.
> Would love to have the feature where PDF or WORD docs can be imported into
> report pages -- is there an alternative like may be using a 3rd party
> activex or something like that?
> thanks again,
> Ashok
>
>
> "Brian Welcker [MSFT]" wrote:
>> Not sure what we would really embed it in? HTML isn't really a format
>> that
>> supports embedding. You can embed docs in e-mail messages as well as link
>> to
>> docs on a web page. I suppose we could have an MHTML format that embedded
>> a
>> PDF file but this hasn't been high on the priority list.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Ashok Jain" <Ashok Jain@.discussions.microsoft.com> wrote in message
>> news:0D468114-DF97-4800-ADB8-411D1C362954@.microsoft.com...
>> > Does reporting services allow emdedding of PDF documents? I dont want
>> > to
>> > convert the document to JPEG as the size increases many times (for me
>> > the
>> > image size is around 1.6MB vs. 100KB for PDF) and i have several of
>> > these
>> > images. Would appreciate if anyone has done similar exercise to embed
>> > document within reports.
>> >
>> > thanks !!
>>

Embedding Fonts While Exporting To PDF

Hi,
My report requires a special type of font. I have the font installed on the
report server. When I export the report as PDF and view the document on the
report server I am able to see the new font. But when I open the same
document on a machine which doesn't have the font installed, I don't get to
see the font. I understand that there is some way you can configure your pdfs
so that the fonts are embedded within the PDF so that all the clients need
not have the font installed to view the document. Is there any way we can
embed fonts in pdfs using reporting services?
Any help is greatly appreciated.
Thanks,
GeorgeYou can't embed fonts into PDF exports in this version of SRS. Maybe next
version which is due maybe middle of next year. Crystal Reports allows you
to embed fonts in version 9.
"george" wrote:
> Hi,
> My report requires a special type of font. I have the font installed on the
> report server. When I export the report as PDF and view the document on the
> report server I am able to see the new font. But when I open the same
> document on a machine which doesn't have the font installed, I don't get to
> see the font. I understand that there is some way you can configure your pdfs
> so that the fonts are embedded within the PDF so that all the clients need
> not have the font installed to view the document. Is there any way we can
> embed fonts in pdfs using reporting services?
> Any help is greatly appreciated.
> Thanks,
> Georgesql

Embedded Word Document in RDL

I have a word document that I would to migrate to reporting services
2005. Instead of recreating the word document in reporting services, I
would like to know if I can embed the word document in a report? If
not, what other options are there?
Thanks.If you would like the word document to be hosted by RS then in your project
add a new existing item and then select your Word file. Then you can deploy
it. Note that when you update it and want to redeploy I have found that I
have to delete it from the report server first prior to deployment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>I have a word document that I would to migrate to reporting services
> 2005. Instead of recreating the word document in reporting services, I
> would like to know if I can embed the word document in a report? If
> not, what other options are there?
> Thanks.
>|||On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you would like the word document to be hosted by RS then in your project
> add a new existing item and then select your Word file. Then you can deploy
> it. Note that when you update it and want to redeploy I have found that I
> have to delete it from the report server first prior to deployment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "TCogan" <tco...@.starcon.org> wrote in message
> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>
> >I have a word document that I would to migrate to reporting services
> > 2005. Instead of recreating the word document in reporting services, I
> > would like to know if I can embed the word document in a report? If
> > not, what other options are there?
> > Thanks.- Hide quoted text -
> - Show quoted text -
I have tried that and that does work. But I was trying to find the
best way to migrate the word document into an RDL file. I want it to
be an RDL file because I have some other data that I want to
incorporate into the report from a database. I am not sure this can
be done, but I would like to avoid from having to recreate the word
document in an RDL file.|||There might be a third party tool that allows this but not straight out of
the box.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174503465.010122.233220@.p15g2000hsd.googlegroups.com...
> On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> If you would like the word document to be hosted by RS then in your
>> project
>> add a new existing item and then select your Word file. Then you can
>> deploy
>> it. Note that when you update it and want to redeploy I have found that I
>> have to delete it from the report server first prior to deployment.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "TCogan" <tco...@.starcon.org> wrote in message
>> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>>
>> >I have a word document that I would to migrate to reporting services
>> > 2005. Instead of recreating the word document in reporting services, I
>> > would like to know if I can embed the word document in a report? If
>> > not, what other options are there?
>> > Thanks.- Hide quoted text -
>> - Show quoted text -
> I have tried that and that does work. But I was trying to find the
> best way to migrate the word document into an RDL file. I want it to
> be an RDL file because I have some other data that I want to
> incorporate into the report from a database. I am not sure this can
> be done, but I would like to avoid from having to recreate the word
> document in an RDL file.
>

Tuesday, March 27, 2012

embed office document

is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?
No, this is really not possible. You would need to translate the text into RDL to do this. We are looking at the ability to provide rich text formatting (including embedded HTML) in a future release.|||Please add this feature.

embed office document

is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?No, this is really not possible. You would need to translate the text into RDL to do this. We are looking at the ability to provide rich text formatting (including embedded HTML) in a future release.|||Please add this feature.

Monday, March 26, 2012

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.