The C# code listings are equivalent to the VB.NET code listings.<\/p>\n
C# Code Listings The C# code listings are equivalent to the VB.NET code listings. Listing 16-1. Mapping the parameters in the ReportDocument class. CrystalReport1 MyReport = new CrystalReport1(); MapParameterFieldDefinitions(MyReport.DataDefinition.ParameterFields, 0); \u2026 public void MapParameterFieldDefinitions( CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions ParameterFieldDefinitions, int Indent) { foreach(CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition ParameterFieldDefinition in ParameterFieldDefinitions) { MapParameterFieldDefinition(ParameterFieldDefinition, Indent); } } public void MapParameterFieldDefinition( CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition ParameterFieldDefinition, int Indent) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,2],"tags":[],"class_list":["post-658","post","type-post","status-publish","format-standard","hentry","category-chapter-16-modifying-parameters-and-formulas","category-crystal-reportsnet-2003","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=658"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/658\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=658"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n MapParameterFieldDefinitions(MyReport.DataDefinition.ParameterFields, 0);<\/code>
\n \u2026<\/code>
\n public void MapParameterFieldDefinitions(<\/code>
\n CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions<\/code>
\n ParameterFieldDefinitions, int Indent)<\/code>
\n {<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition<\/code>
\n ParameterFieldDefinition in ParameterFieldDefinitions)<\/code>
\n {<\/code>
\n MapParameterFieldDefinition(ParameterFieldDefinition, Indent);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapParameterFieldDefinition(<\/code>
\n CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition<\/code>
\n ParameterFieldDefinition, int Indent)<\/code>
\n {<\/code>
\n Output(\"Name: \" + ParameterFieldDefinition.ParameterFieldName, Indent);<\/code>
\n Output(\"PromptText: \" + ParameterFieldDefinition.PromptText, Indent + 2);<\/code>
\n Output(\"ValueType: \" +<\/code>
\n ParameterFieldDefinition.ParameterValueKind.ToString(), Indent + 2);<\/code>
\n Output(\"Kind: \" +<\/code>
\n ParameterFieldDefinition.DiscreteOrRangeKind.ToString(), Indent + 2);<\/code>
\n if (ParameterFieldDefinition.CurrentValues.Count>0)<\/code>
\n {<\/code>
\n Output(\"Current Values: \", Indent + 2);<\/code>
\n MapParameterValues(ParameterFieldDefinition.CurrentValues, Indent + 4);<\/code>
\n }<\/code>
\n if (ParameterFieldDefinition.DefaultValues.Count>0)<\/code>
\n {<\/code>
\n Output(\"Default Values\", Indent + 2);<\/code>
\n MapParameterValues(ParameterFieldDefinition.DefaultValues, Indent + 4);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapParameterValues(CrystalDecisions.Shared.ParameterValues ParameterValues, int Indent)<\/code>
\n {<\/code>
\n foreach(CrystalDecisions.Shared.ParameterValue ParameterValue in<\/code>
\n ParameterValues)<\/code>
\n {<\/code>
\n if (ParameterValue is CrystalDecisions.Shared.ParameterRangeValue)<\/code>
\n {<\/code>
\n MapParameterRangeValue((CrystalDecisions.Shared.ParameterRangeValue)<\/code>
\n ParameterValue, Indent);<\/code>
\n }<\/code>
\n else<\/code>
\n {<\/code>
\n MapParameterDiscreteValue(<\/code>
\n (CrystalDecisions.Shared.ParameterDiscreteValue)ParameterValue,<\/code>
\n Indent);<\/code>
\n }<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapParameterDiscreteValue(<\/code>
\n CrystalDecisions.Shared.ParameterDiscreteValue ParameterValue, int Indent)<\/code>
\n {<\/code>
\n Output(\"Value: \" + ParameterValue.Value.ToString(), Indent);<\/code>
\n }<\/code>
\n public void MapParameterRangeValue(<\/code>
\n CrystalDecisions.Shared.ParameterRangeValue ParameterValue, int Indent)<\/code>
\n {<\/code>
\n Output(\"Value: \" + ParameterValue.StartValue.ToString() + \" to \" + ParameterValue.EndValue.ToString(), Indent);<\/code>
\n }<\/code>
\n
\n CrystalDecisions.Shared.ParameterDiscreteValue ParameterDiscreteValue;<\/code>
\n CrystalDecisions.Shared.ParameterValues ParameterValues;<\/code>
\n \/\/Use the ReportDocument object to create two default parameters<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition ParameterFieldDefinition;<\/code>
\n \/\/Step 1: Get a reference to the property field to modify<\/code>
\n ParameterFieldDefinition = MyReport.DataDefinition.ParameterFields[\"Location\"];<\/code>
\n \/\/Step 2: Instantiate a ParameterValues collection object<\/code>
\n ParameterValues = new CrystalDecisions.Shared.ParameterValues();<\/code>
\n \/\/Step 3: Instantiate a ParameterValue object<\/code>
\n \/\/This example uses a discrete value<\/code>
\n ParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();<\/code>
\n \/\/Step 4: Assign a value to the object<\/code>
\n ParameterDiscreteValue.Value = \"Louisville, KY\";<\/code>
\n \/\/Step 5: Add it to the ParameterValues collection using the Add() method<\/code>
\n ParameterValues.Add(ParameterDiscreteValue);<\/code>
\n \/\/Step 6: Repeat steps 3-5 for additional parameters<\/code>
\n ParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue();<\/code>
\n ParameterDiscreteValue.Value = \"San Diego, CA\";<\/code>
\n ParameterValues.Add(ParameterDiscreteValue);<\/code>
\n \/\/Step 7: Assign the ParameterValues collection to the parameter field<\/code>
\n \/\/Do this for either the CurrentValues or DefaultValues collection<\/code>
\n ParameterFieldDefinition.ApplyDefaultValues(ParameterValues);<\/code>
\n \/\/Step 8: Print or Preview the report<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n
\n CrystalDecisions.Shared.ParameterFields ParameterFields;<\/code>
\n CrystalDecisions.Shared.IParameterField ParameterField;<\/code>
\n CrystalDecisions.Shared.ParameterRangeValue ParameterRangeValue;<\/code>
\n \/\/Step 1: Assign the report object to the viewer<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n \/\/Step 2: Reference the ParameterFields collection<\/code>
\n ParameterFields = crystalReportViewer1.ParameterFieldInfo;<\/code>
\n \/\/Step 3: Reference the ParameterField<\/code>
\n ParameterField = ParameterFields[\"DateRange\"];<\/code>
\n \/\/Step 4: Create a ParameterValue object<\/code>
\n \/\/This example uses a range value object.<\/code>
\n \/\/You could also use a discrete value object.<\/code>
\n ParameterRangeValue = new CrystalDecisions.Shared.ParameterRangeValue();<\/code>
\n \/\/Step 5: Assign a value to the object<\/code>
\n ParameterRangeValue.StartValue = \"1\/4\/1997\";<\/code>
\n ParameterRangeValue.EndValue = \"1\/20\/1997\";<\/code>
\n \/\/Step 6: Add the ParameterValue object to either the<\/code>
\n \/\/CurrentValues or DefaultValues collection<\/code>
\n ParameterField.CurrentValues.Add(ParameterRangeValue);<\/code>
\n
\n public void SetParameterDiscreteWithReport(<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportDocument MyReport,<\/code>
\n string ParameterName, object ParameterValue, string SubreportName)<\/code>
\n {<\/code>
\n CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition<\/code>
\n ParameterFieldDefinition;<\/code>
\n CrystalDecisions.Shared.ParameterDiscreteValue ParameterDiscreteValue;<\/code>
\n CrystalDecisions.Shared.ParameterValues ParameterValues;<\/code>
\n ParameterFieldDefinition =<\/code>
\n MyReport.DataDefinition.ParameterFields[ParameterName, SubreportName];<\/code>
\n ParameterValues = new CrystalDecisions.Shared.ParameterValues();<\/code>
\n ParameterDiscreteValue =<\/code>
\n new CrystalDecisions.Shared.ParameterDiscreteValue();<\/code>
\n ParameterDiscreteValue.Value = ParameterValue;<\/code>
\n ParameterValues.Add(ParameterDiscreteValue);<\/code>
\n ParameterFieldDefinition.ApplyCurrentValues(ParameterValues);<\/code>
\n }<\/code>
\n
\n public void SetParameterRangeWithReport(<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportDocument MyReport,<\/code>
\n string ParameterName, object StartValue, object EndValue, CrystalDecisions.Shared.RangeBoundType LowerBoundType, CrystalDecisions.Shared.RangeBoundType UpperBoundType, string SubreportName)<\/code>
\n {<\/code>
\n CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition<\/code>
\n ParameterFieldDefinition;<\/code>
\n CrystalDecisions.Shared.ParameterRangeValue ParameterRangeValue;<\/code>
\n CrystalDecisions.Shared.ParameterValues ParameterValues;<\/code>
\n ParameterFieldDefinition = MyReport.DataDefinition.ParameterFields<\/code>
\n [ParameterName, SubreportName];<\/code>
\n ParameterValues = new CrystalDecisions.Shared.ParameterValues();<\/code>
\n ParameterRangeValue = new CrystalDecisions.Shared.ParameterRangeValue();<\/code>
\n ParameterRangeValue.StartValue = StartValue;<\/code>
\n ParameterRangeValue.EndValue = EndValue;<\/code>
\n ParameterRangeValue.LowerBoundType = LowerBoundType;<\/code>
\n ParameterRangeValue.UpperBoundType = UpperBoundType;<\/code>
\n ParameterValues.Add(ParameterRangeValue);<\/code>
\n ParameterFieldDefinition.ApplyCurrentValues(ParameterValues);<\/code>
\n }<\/code>
\n
\n public void SetParameterDiscreteWithViewer(<\/code>
\n CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1,<\/code>
\n string ParameterName, object ParameterValue, string SubreportName)<\/code>
\n {<\/code>
\n CrystalDecisions.Shared.IParameterField ParameterField;<\/code>
\n CrystalDecisions.Shared.ParameterDiscreteValue ParameterDiscreteValue;<\/code>
\n ParameterField = crystalReportViewer1.ParameterFieldInfo[ParameterName,<\/code>
\n SubreportName];<\/code>
\n ParameterDiscreteValue =<\/code>
\n New CrystalDecisions.Shared.ParameterDiscreteValue();<\/code>
\n ParameterDiscreteValue.Value = ParameterValue;<\/code>
\n ParameterField.CurrentValues.Add(ParameterDiscreteValue);<\/code>
\n }<\/code>
\n
\n public void SetParameterRangeWithViewer(<\/code>
\n CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1,<\/code>
\n string ParameterName, object StartValue, object EndValue, CrystalDecisions.Shared.RangeBoundType LowerBoundType, CrystalDecisions.Shared.RangeBoundType UpperBoundType, string SubreportName)<\/code>
\n {<\/code>
\n CrystalDecisions.Shared.IParameterField ParameterField;<\/code>
\n CrystalDecisions.Shared.ParameterRangeValue ParameterRangeValue;<\/code>
\n ParameterField = crystalReportViewer1.ParameterFieldInfo<\/code>
\n [ParameterName, SubreportName];<\/code>
\n ParameterRangeValue = new CrystalDecisions.Shared.ParameterRangeValue();<\/code>
\n ParameterRangeValue.StartValue = StartValue;<\/code>
\n ParameterRangeValue.EndValue = EndValue;<\/code>
\n ParameterRangeValue.LowerBoundType = LowerBoundType;<\/code>
\n ParameterRangeValue.UpperBoundType = UpperBoundType;<\/code>
\n ParameterField.CurrentValues.Add(ParameterRangeValue);<\/code>
\n }<\/code>
\n
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n SetParameterDiscreteWithReport(MyReport, \"MyBirthday\", new DateTime(1968,5,23), \"\");<\/code>
\n SetParameterRangeWithReport(MyReport, \"DateRange\",new DateTime(1997,2,1), new DateTime(1997,3,1), CrystalDecisions.Shared.RangeBoundType.BoundInclusive, CrystalDecisions.Shared.RangeBoundType.BoundExclusive, \"\");<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n SetParameterDiscreteWithViewer(crystalReportViewer1, \"CustomerId\",<\/code>
\n \"DotNet Tech\", \"\");<\/code>
\n SetParameterRangeWithViewer(crystalReportViewer1, \"DateRange\",<\/code>
\n new DateTime(1997, 1, 1),new DateTime(1997, 2, 1), CrystalDecisions.Shared.RangeBoundType.BoundInclusive, CrystalDecisions.Shared.RangeBoundType.BoundExclusive, \"\");<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"