我们如何将参数传递给水晶报告asp.net中的程序 [英] how we pass parameters to procedure in crystal report asp.net

问题描述

我们如何使用asp.net

解决方案

我是如何将参数传递给水晶报告中的过程

假设CR在Aspx.vb / aspx.cs页面中配置

，您可以按以下方式加载参数：

私人 Sub LoadCRParameters（）

RptViewerMailoutJudgesInvitation.ParameterFieldInfo.Clear（）

Dim _paraFeilds < font color ="＃0000ff"size = 2> As CrystalDecisions.Shared.ParameterFields = New < font size = 2> CrystalDecisions.Shared.ParameterFields

Dim _paraCompetitionID As CrystalDecisions.Shared.ParameterField = New CrystalDecisions.Shared.ParameterField

Dim _paraEventID As CrystalDecisions.Shared.ParameterField = 新 CrystalDecisions.Shared.ParameterField

Dim _paraCompetitionValue As CrystalDecisions.Shared.ParameterDiscreteValue = 新 CrystalDecisions.Shared.ParameterDiscreteValue

Dim _paraEventValue As C. rystalDecisions.Shared.ParameterDiscreteValue = 新 CrystalDecisions.Shared.ParameterDiscreteValue

_paraCompetitionID.Name = " @CompID"

_paraCompetitionID.CurrentValues.Clear（）

_paraCompetitionValue.Value = Profile.SelComp

_paraCompetitionID.CurrentValues.Add（_paraCompetitionValue）

_paraFeilds.Add（_paraCompetitionID）

_paraEventID .Name = " @ EventID"

_paraEventID.CurrentValues.Clear （）

_paraEventValue.Value = Profile.SelEvent

_paraEventID.CurrentValues.Add（_paraEventValue）

_paraFeilds.Add（_paraEventID）

RptViewerMailoutJudgesInvitation.ParameterFieldInfo = _paraFeild

结束 Sub

此处，"RptViewerMailoutJudgesInvitation"是控件的名称，它是CrystalReportViewer

和"@CompID";或"@ EventID"是我在CR中创建的参数名称。

这些可以是任何东西，并非强制要求 解决方案

Hi Wasi,

 

Assuming that the CR is configured in the Aspx.vb / aspx.cs page

you can load parameters in the following manner:

 

Private Sub LoadCRParameters()

RptViewerMailoutJudgesInvitation.ParameterFieldInfo.Clear()

 

Dim _paraFeilds As CrystalDecisions.Shared.ParameterFields = New CrystalDecisions.Shared.ParameterFields

Dim _paraCompetitionID As CrystalDecisions.Shared.ParameterField = New CrystalDecisions.Shared.ParameterField

Dim _paraEventID As CrystalDecisions.Shared.ParameterField = New CrystalDecisions.Shared.ParameterField

Dim _paraCompetitionValue As CrystalDecisions.Shared.ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue

Dim _paraEventValue As CrystalDecisions.Shared.ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue

 

_paraCompetitionID.Name = "@CompID"

_paraCompetitionID.CurrentValues.Clear()

_paraCompetitionValue.Value = Profile.SelComp

_paraCompetitionID.CurrentValues.Add(_paraCompetitionValue)

_paraFeilds.Add(_paraCompetitionID)

 

_paraEventID.Name = "@EventID"

_paraEventID.CurrentValues.Clear()

_paraEventValue.Value = Profile.SelEvent

_paraEventID.CurrentValues.Add(_paraEventValue)

_paraFeilds.Add(_paraEventID)

 

RptViewerMailoutJudgesInvitation.ParameterFieldInfo = _paraFeild

End Sub

 

Here, "RptViewerMailoutJudgesInvitation" is the name of the control which is a CrystalReportViewer

and "@CompID" or "@EventID" are parameter Names which i had created in CR.

These can be anything, and not mandatory to have the '@' Symbol

 

Hope this helps

这篇关于我们如何将参数传递给水晶报告asp.net中的程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！