crystal parameter

[EyeTalion]

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?

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)

[Lunatic3]

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

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.

[EyeTalion]

yes I am setting the report source in the 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?

[Lunatic3]

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.

[EyeTalion]

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

[Lunatic3]

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

[EyeTalion]

did you create a parameter field in Crystal?

[Lunatic3]

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