J
JC - home
This is driving me mad!!
I have a report viewer on a form that is bound to a sql stored
procedure that has one parameter.
I just can't seem to find a way of passing a parameter to the report
viewer, though can make it prompt for the value when refreshing the
report viewer.
-------
CrystalReportViewer1.ReportSource = Application.StartupPath &
"\view_narrative.rpt"
is about as far as I've got - I've looked at the parameterfieldinfo
collection but don't seem to be getting anywhere.
--------
I've no problems with creating a similar report for direct export to
pdf as below:
Dim crparametervalues As ParameterValues
Dim crparameterdiscretevalue As ParameterDiscreteValue
Dim crparameterfielddefinitions As ParameterFieldDefinitions
Dim crparameterfielddefinition As ParameterFieldDefinition
crparameterfielddefinitions =
myreport.DataDefinition.ParameterFields
crparameterfielddefinition =
crparameterfielddefinitions.Item(0)
crparametervalues = crparameterfielddefinition.CurrentValues
crparameterdiscretevalue = New ParameterDiscreteValue
crparameterdiscretevalue.Value = CType(txtRef.Text, Int32)
crparametervalues.Add(crparameterdiscretevalue)
crparameterfielddefinition.ApplyCurrentValues(crparametervalues)
Dim myexportoptions As ExportOptions
Dim myexportfile As String
myexportfile = my_full_output_file_string & "-REP-CSE.PDF"
mydiskfiledestinationoptions.DiskFileName = myexportfile
myexportoptions = myreport.ExportOptions
With myexportoptions
..DestinationOptions = mydiskfiledestinationoptions
..ExportDestinationType = .ExportDestinationType.DiskFile
..ExportFormatType = ExportFormatType.PortableDocFormat
End With
myreport.Export() ' as PDF
-------
Anyone have any ideas on this? I'm sure I'm missing something
fundamental somewhere.
JC
I have a report viewer on a form that is bound to a sql stored
procedure that has one parameter.
I just can't seem to find a way of passing a parameter to the report
viewer, though can make it prompt for the value when refreshing the
report viewer.
-------
CrystalReportViewer1.ReportSource = Application.StartupPath &
"\view_narrative.rpt"
is about as far as I've got - I've looked at the parameterfieldinfo
collection but don't seem to be getting anywhere.
--------
I've no problems with creating a similar report for direct export to
pdf as below:
Dim crparametervalues As ParameterValues
Dim crparameterdiscretevalue As ParameterDiscreteValue
Dim crparameterfielddefinitions As ParameterFieldDefinitions
Dim crparameterfielddefinition As ParameterFieldDefinition
crparameterfielddefinitions =
myreport.DataDefinition.ParameterFields
crparameterfielddefinition =
crparameterfielddefinitions.Item(0)
crparametervalues = crparameterfielddefinition.CurrentValues
crparameterdiscretevalue = New ParameterDiscreteValue
crparameterdiscretevalue.Value = CType(txtRef.Text, Int32)
crparametervalues.Add(crparameterdiscretevalue)
crparameterfielddefinition.ApplyCurrentValues(crparametervalues)
Dim myexportoptions As ExportOptions
Dim myexportfile As String
myexportfile = my_full_output_file_string & "-REP-CSE.PDF"
mydiskfiledestinationoptions.DiskFileName = myexportfile
myexportoptions = myreport.ExportOptions
With myexportoptions
..DestinationOptions = mydiskfiledestinationoptions
..ExportDestinationType = .ExportDestinationType.DiskFile
..ExportFormatType = ExportFormatType.PortableDocFormat
End With
myreport.Export() ' as PDF
-------
Anyone have any ideas on this? I'm sure I'm missing something
fundamental somewhere.
JC