Export to pdf with parameters

i know how to exprot to pdf and i know how to use parameters but i dont know how to do both together.

Could some please help me. I have a parameter in the report called sbtcode and it is a string value. how can i pass it to the report?

Private Sub Command1_Click()
Dim appl As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
rep.ExportOptions.DiskFileName = "c:\pdf_report.pdf"

rep.ExportOptions.DestinationType = crEDTDiskFile
rep.ExportOptions.FormatType = crEFTPortableDocFormat
rep.Export FalseThis code is from CR 8.5 and VB 6.

Private Sub Command1_Click()
Dim appl As New CRAXDRT.Application
Dim rep As CRAXDRT.Report

'This removes the prompt for the Parameter
rep.EnableParameterPrompting = False

'This sets the parameter to strValue
rep.ParameterFields(1).AddCurrentValue (strValue)

rep.ExportOptions.DiskFileName = "c:\pdf_report.pdf"

rep.ExportOptions.DestinationType = crEDTDiskFile
rep.ExportOptions.FormatType = crEFTPortableDocFormat
rep.Export False

Export to PDF problem.

I have a report that is to be exported to PDF when it is run. However, this report can have about 180 pages if certain combinations of parameters are supplied (Yes I know, but the spec from the client wants it to show so much data). Now, when the report is this big and they try to export it to PDF, ReportServer will either just hang or crash with an error without even creating the PDF. The report consists of about 4 subreports, one of which calls subreports of its own, which then calls its own subreports (it goes on with this for about 5 levels worth of data). I think this could be a limitation of SSRS, but does anyone maybe know of a way around it? The other developers seem to think it would be a solution to re-design the report from scratch without all the sub-reports, but this would take at least a week and the client needs it back ASAP.

Thanks in advance.

Hi,

Im also having a problem in RS2005 exporting to pdf. im exporting my chart to pdf format but the file size is too big.. about 10mb.

Im using windows 2003 server 64 bit.

regards

Anton

Export to PDF problem.

I have a report that is to be exported to PDF when it is run. However, this report can have about 180 pages if certain combinations of parameters are supplied (Yes I know, but the spec from the client wants it to show so much data). Now, when the report is this big and they try to export it to PDF, ReportServer will either just hang or crash with an error without even creating the PDF. The report consists of about 4 subreports, one of which calls subreports of its own, which then calls its own subreports (it goes on with this for about 5 levels worth of data). I think this could be a limitation of SSRS, but does anyone maybe know of a way around it? The other developers seem to think it would be a solution to re-design the report from scratch without all the sub-reports, but this would take at least a week and the client needs it back ASAP.

Thanks in advance.

Hi,

Im also having a problem in RS2005 exporting to pdf. im exporting my chart to pdf format but the file size is too big.. about 10mb.

Im using windows 2003 server 64 bit.

regards

Anton

Export to PDF issue

Hi,
I have a strange problem with a report when it is exported. My report has a
textbox on it which dispays the value of one of the parameters selected by
the user. When the report is displayed in the browser everything is
positioned correctly on the screen. However, when I export the report the
textbox has moved left and it is now overwriting the label which is next to
it. This happens when exporting to PDF or TIFF.
Does anyone have any ideas as to why this should happen? I'm using RS 2005.Make sure the allignment and the justification of the text is right and
increase the width of the text box which displays the parameter selected.

Export Report to PDF

Hello,
I have a Report with PageHeader and PageFooter. If i display the published
report in IE there are no problems with my parameters there are two pages
displayed. But if I export these two pages to PDF I have a blank page with
only the header and footer beteen each site with data. Can you help me out of
this? Thank you.
best regards
dhi d,
The pdf being split into two pages is becoz of the "Page size" property
for a report, Make sure your page size doesnot exceed the actual page
size.
Rgds,
Venkat
Repordoll wrote:
> Hello,
> I have a Report with PageHeader and PageFooter. If i display the published
> report in IE there are no problems with my parameters there are two pages
> displayed. But if I export these two pages to PDF I have a blank page with
> only the header and footer beteen each site with data. Can you help me out of
> this? Thank you.
> best regards
> d