Exporting PDF Problems

i ve used SOAP API in my web application and thus generated the report in
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>

exporting error

attached is the error msg that display everytime i export the informations generated by CR v8.5 to excel file. i thought the reason for the error msg is the consumption of the 65T rows allowed in excel because when i export the report having much fewer informations (retrieve the same report in the short period of time), the exportation was successul.

On the other hand, when i tried the previous report version, any exportation was successful even when the retrieval arguments in date range is 3 months.

Please help mei have known the cause of this error, this is due to the subreport i inserted so i just editted the report and delete the sub report. on the other hand, can anyone help me why does the error occur? is it a bug of the CR 8.5? F.Y.I the CR report is directly retrieve in a server... H.E.L.Psql

Exported PDF Security

Hi All
I am using SQL Reporting Services. I looked into the properties of the
generated .pdf file and it allows user to edit the file contents using a
full version Adobe Acrobat.
Is it possible to make the exported PDF file uneditable ? Any help on this
will be hisghly appreciated
Thanks
Vaibhav SharmaIf anyone says yes, well theyre wrong.
The issue here is not Reporting Services but rather the PDF Spec,
Using tools I will NOT mention here , I can edit any PDF , from any
source "AT-WILL"
The funny part is the tools I use are the same tools "I" use for allpdf
work and I have had developers/designers choke on their words many a
times over this exact issue.
I go by the xiom of , "If a client can read it, so can I" (client being
client tool, webbrowser, pdfviewer etc) but you can always take that a
step further and say "If I can read it I can change it"
NOW All that said is there a way to "Lock" a PDF Against edit for the
other 99% of people, yes, but I am unsure if RS has it implemented, I
have not seen it anywhere in the docs.|||RS does not support any type of locking of the PDF. You could write your own
extension to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> If anyone says yes, well theyre wrong.
> The issue here is not Reporting Services but rather the PDF Spec,
> Using tools I will NOT mention here , I can edit any PDF , from any
> source "AT-WILL"
> The funny part is the tools I use are the same tools "I" use for allpdf
> work and I have had developers/designers choke on their words many a
> times over this exact issue.
> I go by the xiom of , "If a client can read it, so can I" (client being
> client tool, webbrowser, pdfviewer etc) but you can always take that a
> step further and say "If I can read it I can change it"
> NOW All that said is there a way to "Lock" a PDF Against edit for the
> other 99% of people, yes, but I am unsure if RS has it implemented, I
> have not seen it anywhere in the docs.
>|||Any pointers on how to do that? I mean how to go about writing an extension.
TIA
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> RS does not support any type of locking of the PDF. You could write your
> own
> extension to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> If anyone says yes, well theyre wrong.
>> The issue here is not Reporting Services but rather the PDF Spec,
>> Using tools I will NOT mention here , I can edit any PDF , from any
>> source "AT-WILL"
>> The funny part is the tools I use are the same tools "I" use for allpdf
>> work and I have had developers/designers choke on their words many a
>> times over this exact issue.
>> I go by the xiom of , "If a client can read it, so can I" (client being
>> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> step further and say "If I can read it I can change it"
>> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> have not seen it anywhere in the docs.
>|||I know it is possible because 3rd parties have come up with additional
rendering extensions but looking at it another way (and definitely easier)
you could have a delivery extension (if you are sending this via
subscriptions). Your delivery extension could save the report as a pdf file,
then run it through whatever utility that locks the pdf and then you send it
on via the email. Look in the help on delivery extension.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Any pointers on how to do that? I mean how to go about writing an
extension.
> TIA
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> > RS does not support any type of locking of the PDF. You could write your
> > own
> > extension to do this.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> If anyone says yes, well theyre wrong.
> >>
> >> The issue here is not Reporting Services but rather the PDF Spec,
> >>
> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> source "AT-WILL"
> >>
> >> The funny part is the tools I use are the same tools "I" use for allpdf
> >> work and I have had developers/designers choke on their words many a
> >> times over this exact issue.
> >>
> >> I go by the xiom of , "If a client can read it, so can I" (client being
> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
> >> step further and say "If I can read it I can change it"
> >>
> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
> >> have not seen it anywhere in the docs.
> >>
> >
> >
>|||Thanks very much.
But in my case i am not sending file by susbscription, i am displaying
report as link and generating it on demand like an invoice pdf file.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I know it is possible because 3rd parties have come up with additional
> rendering extensions but looking at it another way (and definitely easier)
> you could have a delivery extension (if you are sending this via
> subscriptions). Your delivery extension could save the report as a pdf
> file,
> then run it through whatever utility that locks the pdf and then you send
> it
> on via the email. Look in the help on delivery extension.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
>> Any pointers on how to do that? I mean how to go about writing an
> extension.
>> TIA
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
>> > RS does not support any type of locking of the PDF. You could write
>> > your
>> > own
>> > extension to do this.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
>> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> >> If anyone says yes, well theyre wrong.
>> >>
>> >> The issue here is not Reporting Services but rather the PDF Spec,
>> >>
>> >> Using tools I will NOT mention here , I can edit any PDF , from any
>> >> source "AT-WILL"
>> >>
>> >> The funny part is the tools I use are the same tools "I" use for
>> >> allpdf
>> >> work and I have had developers/designers choke on their words many a
>> >> times over this exact issue.
>> >>
>> >> I go by the xiom of , "If a client can read it, so can I" (client
>> >> being
>> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> >> step further and say "If I can read it I can change it"
>> >>
>> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> >> have not seen it anywhere in the docs.
>> >>
>> >
>> >
>>
>|||If you have your own UI (i.e. not using Report Manager but using your own
ASP.net application) then you could use the same technique by using web
services to first render PDF on your server, run the untility and then send
the resultant protected PDF to the user. If you want to use Report Manager
portal then there is not an easy solution that I can think of.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:Of5HKMP7EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Thanks very much.
> But in my case i am not sending file by susbscription, i am displaying
> report as link and generating it on demand like an invoice pdf file.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> >I know it is possible because 3rd parties have come up with additional
> > rendering extensions but looking at it another way (and definitely
easier)
> > you could have a delivery extension (if you are sending this via
> > subscriptions). Your delivery extension could save the report as a pdf
> > file,
> > then run it through whatever utility that locks the pdf and then you
send
> > it
> > on via the email. Look in the help on delivery extension.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> > news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> >> Any pointers on how to do that? I mean how to go about writing an
> > extension.
> >>
> >> TIA
> >>
> >>
> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> >> > RS does not support any type of locking of the PDF. You could write
> >> > your
> >> > own
> >> > extension to do this.
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> >> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> >> If anyone says yes, well theyre wrong.
> >> >>
> >> >> The issue here is not Reporting Services but rather the PDF Spec,
> >> >>
> >> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> >> source "AT-WILL"
> >> >>
> >> >> The funny part is the tools I use are the same tools "I" use for
> >> >> allpdf
> >> >> work and I have had developers/designers choke on their words many a
> >> >> times over this exact issue.
> >> >>
> >> >> I go by the xiom of , "If a client can read it, so can I" (client
> >> >> being
> >> >> client tool, webbrowser, pdfviewer etc) but you can always take that
a
> >> >> step further and say "If I can read it I can change it"
> >> >>
> >> >> NOW All that said is there a way to "Lock" a PDF Against edit for
the
> >> >> other 99% of people, yes, but I am unsure if RS has it implemented,
I
> >> >> have not seen it anywhere in the docs.
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

export to PDF (reporting services)

Greetings!,

Does anyone here know where to configure the document properties/security settings of PDF files generated by reporting services?

thanks!

What are you wanting to achieve - specific settings?|||

I want to make the PDF not printable, not modifiable, set passwords...etc..

These properties are found under the Document Security tab under the File menu in Acrobat reader (if you open the exported PDF report).

|||The PDF export format from Reporting Services is not configurable for document security. Those features are part of the Adobe software.|||

Thanks Brad.

Any suggestions on other 3rd party components where I can do export to PDF (asp/htm to pdf) programatically?

|||

Hi,

ABCpdf from WebSuperGoo will allow you to do what you want. One word of caution they currently don't have a 64 bit version of their component.

Regards,

Sanjay

|||

In addition to Brian, you have to keep in mind that even the features of PDFing your reports is limited and can′t be compared to the original product as their are relying on some older engine (Guess it was 4.0).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Sanjay,

Thanks. What dou you mean about the 64 bit version? What would be the probable repercussions?

regards

|||

Hi,

Just that if you are planning to deploy an application using that component to a 64 bit server, it won't work. The ABCpdf component has to run in a 32 bit process. You can set IIS to run in 32 bit mode but that is a server wide setting. They are currently developing a 64 bit version but I haven't got a release date.

Regards,

Sanjay

|||

Hi,

Does someone know if there is a.dll or patches (that I can register in my server) that Adobe released in order to toggle the default Document Security properties?

thanks

Export to Excel...real values getting dispalyed as string

Hi All,
I have generated and exported to excel. The report is of cross-tab consiting
of real values. In excel, the values are shown as of string data type.
Can some let me know why is this happening and how to resolve this.
This is creating a big problem..kindly help
Thanks,
LakshmiYou can put explicit data type conversion for your values i.e.:
=CInt(Fields!Total.Value-Fields!Discount.Value)
Alex
Alex
"Lak" wrote:
> Hi All,
>
> I have generated and exported to excel. The report is of cross-tab consiting
> of real values. In excel, the values are shown as of string data type.
> Can some let me know why is this happening and how to resolve this.
> This is creating a big problem..kindly help
>
> Thanks,
> Lakshmi

Export to Excel

Is there some way to name the worksheet that is generated when you export
from Reporting Services via Excel?
--
Abe CherianAs indicated in previous newsgroup threads, this is not supported in RS
2000. It is on the wishlist for inclusion in a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abe Cherian" <AbeCherian@.discussions.microsoft.com> wrote in message
news:699485B4-A8F1-4BC3-A1DE-036978539290@.microsoft.com...
> Is there some way to name the worksheet that is generated when you export
> from Reporting Services via Excel?
> --
> Abe Cherian