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.DataDef inition.Pa rameterFie lds.Item(" VR_FROM_DA TE")
ParameterValues = New CrystalDecisions.Shared.Pa rameterVal ues()
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa rameterDis creteValue ()
ParameterDiscreteValue.Val ue = CType(hasGetParam("strFrom Date"), String)
ParameterValues.Add(Parame terDiscret eValue)
ParameterFieldDefinition.A pplyCurren tValues(Pa rameterVal ues)
' to date
ParameterFieldDefinition = rptSurveyorReports.DataDef inition.Pa rameterFie lds.Item(" VR_TO_DATE ")
ParameterValues = New CrystalDecisions.Shared.Pa rameterVal ues()
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa rameterDis creteValue ()
ParameterDiscreteValue.Val ue = CType(hasGetParam("strToDa te"), String)
ParameterValues.Add(Parame terDiscret eValue)
ParameterFieldDefinition.A pplyCurren tValues(Pa rameterVal ues)
and then I am calling a stored procedure and filling the dataset like
dadptDataAdap = New OracleDataAdapter(dcOraCom )
dadptDataAdap.Fill(dstData Set, "SURPERFORMANCE")
and I am assigning the report to the report viewer like
rptSurveyorReports.SetData Source(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
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.DataDef
ParameterValues = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue.Val
ParameterValues.Add(Parame
ParameterFieldDefinition.A
' to date
ParameterFieldDefinition = rptSurveyorReports.DataDef
ParameterValues = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue.Val
ParameterValues.Add(Parame
ParameterFieldDefinition.A
and then I am calling a stored procedure and filling the dataset like
dadptDataAdap = New OracleDataAdapter(dcOraCom
dadptDataAdap.Fill(dstData
and I am assigning the report to the report viewer like
rptSurveyorReports.SetData
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
Are you using Crystal Enterprise on the server that your application is on?
ASKER
Hi,
I am using Crystal Reports Developer Edition 10 on my local server#
Thanks,
Madan
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
frodoman
ASKER
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
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.DataDef inition.Pa rameterFie lds.Item(" VR_FROM_DA TE")
ParameterValues = New CrystalDecisions.Shared.Pa rameterVal ues()
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa rameterDis creteValue ()
ParameterDiscreteValue.Val ue = CType(hasGetParam("strFrom Date"), String)
ParameterValues.Add(Parame terDiscret eValue)
'ParameterFieldDefinition. ApplyCurre ntValues(P arameterVa lues)
' to date
ParameterFieldDefinition = rptSurveyorReports.DataDef inition.Pa rameterFie lds.Item(" VR_TO_DATE ")
'ParameterValues = New CrystalDecisions.Shared.Pa rameterVal ues()
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa rameterDis creteValue ()
ParameterDiscreteValue.Val ue = CType(hasGetParam("strToDa te"), String)
ParameterValues.Add(Parame terDiscret eValue)
ParameterFieldDefinition.A pplyCurren tValues(Pa rameterVal ues)
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
ParameterFieldDefinition = rptSurveyorReports.DataDef
ParameterValues = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue.Val
ParameterValues.Add(Parame
'ParameterFieldDefinition.
' to date
ParameterFieldDefinition = rptSurveyorReports.DataDef
'ParameterValues = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue = New CrystalDecisions.Shared.Pa
ParameterDiscreteValue.Val
ParameterValues.Add(Parame
ParameterFieldDefinition.A
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
ASKER
Hi,
Unfortunately even then it is not working. Is there any option like say "take the parameter from dotnet itself"
Thanks in advance,
Madan
Unfortunately even then it is not working. Is there any option like say "take the parameter from dotnet itself"
Thanks in advance,
Madan
ASKER
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
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
ASKER
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
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
If you enter the parameters when prompted, does the report run?
mlmcc
mlmcc
ASKER
Hi,
If I enter the parameters it is running the reports. No probs with that.
Regards,
Madan M
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
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No objections here.