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 excel

Had anyone made an export to excel that has 33 rows?
33 rows in excel, together with header and all...
I'm asking that because in my case when export to excel has 33 rows, 33.
row is always missing!Do you have SP2 installed? I know it had some Excel export fixes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jo?ko ?ugar" <josko_bla@.netgen_rem0ve_this_and_bla.hr> wrote in message
news:d83nqc$3ll$1@.sunce.iskon.hr...
> Had anyone made an export to excel that has 33 rows?
> 33 rows in excel, together with header and all...
> I'm asking that because in my case when export to excel has 33 rows, 33.
> row is always missing!|||Bruce L-C [MVP] wrote:
> Do you have SP2 installed? I know it had some Excel export fixes.
>
I do now, but the problem is still there.|||Try adding a blank/empty textbox below your table or matrix. I've seen
cases like this where the last row of a report is missing when exported
to Excel...adding a small, empty textbox immediately below your table
or matrix seemed to fix the problem.|||kbr wrote:
> Try adding a blank/empty textbox below your table or matrix. I've seen
> cases like this where the last row of a report is missing when exported
> to Excel...adding a small, empty textbox immediately below your table
> or matrix seemed to fix the problem.
>
Thanks!