Link to home
Start Free TrialLog in
Avatar of conveymadan
conveymadan

asked on

The report you requested requires further information.... error...

Hi,

I am using Crystal Reports 10 Developer Edition with Visual Studio .NET 2003.

From my crystal report viewer page(aspx page) I am calling the stored procedure to populate a dataset. From there I am showing a crystal report.

I am passing the parameter like
            rptSurveyorReports = New SurPerSum()
        End If

        ParameterFieldDefinition = rptSurveyorReports.DataDefinition.ParameterFields.Item("VR_FROM_DATE")
        ParameterValues = New CrystalDecisions.Shared.ParameterValues()
        ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
        ParameterDiscreteValue.Value = CType(hasGetParam("strFromDate"), String)
        ParameterValues.Add(ParameterDiscreteValue)
        ParameterFieldDefinition.ApplyCurrentValues(ParameterValues)

        ' to date
        ParameterFieldDefinition = rptSurveyorReports.DataDefinition.ParameterFields.Item("VR_TO_DATE")
        ParameterValues = New CrystalDecisions.Shared.ParameterValues()
        ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
        ParameterDiscreteValue.Value = CType(hasGetParam("strToDate"), String)
        ParameterValues.Add(ParameterDiscreteValue)
        ParameterFieldDefinition.ApplyCurrentValues(ParameterValues)


and then I am calling a stored procedure and filling the dataset like

            dadptDataAdap = New OracleDataAdapter(dcOraCom)

            dadptDataAdap.Fill(dstDataSet, "SURPERFORMANCE")

and I am assigning the report to the report viewer like
        rptSurveyorReports.SetDataSource(dat)
        CRViewer.ReportSource = rptSurveyorReports

When I run the application it is throwing the error like
 The report you requested requires further information.

--------------------------------------------------------------------------------

Crystal Parameter Field(s)

and is asking for all the input parameters of the crystal report.

How to resolve it? Is there any setting in report to say "Take the parameters from dotnet component?"

Regards,
Madan
Avatar of tmace74
tmace74

Are you using Crystal Enterprise on the server that your application is on?
Avatar of conveymadan

ASKER

Hi,

I am using Crystal Reports Developer Edition 10 on my local server#

Thanks,
Madan
This error message usually means you haven't supplied all of the parameter values.  First make sure you're supplying all of them.  Next, check to see if you have any subreports that require parameters because these must also be supplied.  Finally, make sure you are sending the correct data types because a type-mismatch will often be ignored and treated as a missing parameter.

frodoman
Hi,

I am passing all the parameters from my asp.net code I checked it and I am not using the subreports. I checked the datatypes and both are string only.

I am digging into that, and breaking my head why it is again asking for the parameters?

Regards,
Madan
Try this instead - I've commented out two lines of your code.

        ParameterFieldDefinition = rptSurveyorReports.DataDefinition.ParameterFields.Item("VR_FROM_DATE")
        ParameterValues = New CrystalDecisions.Shared.ParameterValues()
        ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
        ParameterDiscreteValue.Value = CType(hasGetParam("strFromDate"), String)
        ParameterValues.Add(ParameterDiscreteValue)
        'ParameterFieldDefinition.ApplyCurrentValues(ParameterValues)

        ' to date
        ParameterFieldDefinition = rptSurveyorReports.DataDefinition.ParameterFields.Item("VR_TO_DATE")
        'ParameterValues = New CrystalDecisions.Shared.ParameterValues()
        ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
        ParameterDiscreteValue.Value = CType(hasGetParam("strToDate"), String)
        ParameterValues.Add(ParameterDiscreteValue)
        ParameterFieldDefinition.ApplyCurrentValues(ParameterValues)

Comment out the first "ApplyCurrentValues" because you don't want to apply anything until you have all of them set - that's part of the problem you are applying one parameter and then applying one parameter again.  What you need to do is to apply two parameters at the same time.

Along those lines don't declare a new instace of "ParameterValues" for the second parameter - you want to add the second parameter to the existing ParameterValues object.  This gives you an object with two parameter values attached to it and then you apply that object.

frodoman
Hi,

Unfortunately even then it is not working. Is there any option like say "take the parameter from dotnet itself"

Thanks in advance,
Madan
Hi,

Actually I migrated the projects from Crystal Reports Developer Edition 9 to Crystal Reports Developer Edition 10. Is that a problem? Because with Crystal Reports Developer Edition 9, with the same reports I didn't face any issues.

Is that a problem? If yes, any remedy for this?

Thanks,
Madan
Hi,

The problem is with the "EnableParameterPrompt" property. The property is not there in the Crystal Reports Developer 9 and it exists in the Crystal Reports Developer 10.
If I set EnableParameterPrompt= False then I am getting the error saying that not all of the required parameters were supplied

and if I set EnableParameterPrompt = True then it is prompting me to enter the parameters again.

Thanks,
Madan
Avatar of Mike McCracken
If you enter the parameters when prompted, does the report run?

mlmcc
Hi,

If I enter the parameters it is running the reports. No probs with that.



Regards,
Madan M
Does the syored procedure have any parameters?

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of conveymadan
conveymadan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No objections here.