crystal parameter

I'm running a crystal report through my app. I have a date variable set in the application "TranPeriodEnd" . I need to place this date in the top of the report. Heres the code I'm using but Crystal gives me a dialog box asking for the parameter... In the report I created DateParam, using: field explorer --> parameter fields...am I doing something wrong here?

VB Code:

Dim crReport As New header()
        Dim crParameterFieldDefinitons As ParameterFieldDefinitions
        Dim crParameterFieldDefinition As ParameterFieldDefinition
        Dim crParameterValues As New ParameterValues()
        Dim crParameterDiscreteValue As New ParameterDiscreteValue()
        crParameterDiscreteValue.Value = CDate(tranPeriodEnd)
        crParameterFieldDefinitons = crReport.DataDefinition.ParameterFields
        crParameterFieldDefinition = crParameterFieldDefinitons.Item("Dateparam")
        crParameterValues = crParameterFieldDefinition.CurrentValues
        crParameterValues.Add(crParameterDiscreteValue)
        crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

Your code works for me, however you can add the value to the reportviewer fairly easy.

VB Code:

Dim crReport As New header
CRV.ReportSource = crReport ' CRV is the reportviewer
Dim crParameterDiscreteValue As New ParameterDiscreteValue
crParameterDiscreteValue.Value = CDate(tranperiodend)
CRV.ParameterFieldInfo("Dateparam").CurrentValues.Add(crParameterDiscreteValue)

I am almost sure you are setting the report source in the code not in the designer but it worths checking it again.

Anyway, If i were you I would have used a Formula Field instead of Parameter Field. Each time you do a refresh or something you should again pass the parameter, and thats just a pain in the neck.

yes I am setting the report source in the code.

VB Code:

CrystalReportViewer1.ReportSource = rpt

whats the difference between setting it in the code or the designer? Would that cause Crystal to prompt me for a parameter?


how do you set it in the designer?

If you set it in the designer, then the viewer uses that which is different from the instance you create at the code and set parameter value for it.

hey luna, when you say you got it to work...did Crystal prompt you for a value? did you use your own variable?

I mean the CR didnt prompt for parameter and my value was there.

did you create a parameter field in Crystal?

Ya, i did. aren't you kind of refreshing your report after adding that value?