{"id":646,"date":"2008-01-04T19:48:09","date_gmt":"2008-01-05T02:48:09","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/crystal-reports-xi\/1511-c-code-listings\/"},"modified":"2008-01-04T19:48:09","modified_gmt":"2008-01-05T02:48:09","slug":"1511-c-code-listings","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/1511-c-code-listings\/","title":{"rendered":"15.11 C# Code Listings"},"content":{"rendered":"

C# Code Listings<\/h1>\n

The C# code listings are equivalent to the VB.NET code listings.<\/p>\n

Listing 15-1. Changing the selection formula with the ReportDocument object.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n MyReport.DataDefinition.RecordSelectionFormula =<\/code>
\n \"{Orders.Order Date} in Date (1996, 02, 19) to Date (1996, 03, 28)\";<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n Listing 15-2. Changing the selection formula with the viewer control.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n crystalReportViewer1.SelectionFormula =<\/code>
\n \"{Orders.Order Date} in Date (1996, 02, 19) to Date (1996, 02, 20)<\/code>
\n Listing 15-3. Mapping the ReportDefinition object model.<\/code_Caption>
\n private void Form1_Load(object sender, System.EventArgs e)<\/code>
\n {<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n MapAreas(MyReport.ReportDefinition.Areas, 0);<\/code>
\n }<\/code>
\n public void MapAreas(CrystalDecisions.CrystalReports.Engine.Areas Areas, int Indent)<\/code>
\n {<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.Area Area in Areas)<\/code>
\n {<\/code>
\n MapArea(Area, Indent);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapSections(CrystalDecisions.CrystalReports.Engine.Sections Sections, int Indent)<\/code>
\n {<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.Section Section in Sections)<\/code>
\n {<\/code>
\n MapSection(Section, Indent);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapReportObjects(CrystalDecisions.CrystalReports.Engine.ReportObjects ReportObjects, int Indent)<\/code>
\n {<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.ReportObject ReportObject in ReportObjects)<\/code>
\n {<\/code>
\n MapReportObject(ReportObject, Indent + 2);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapArea(CrystalDecisions.CrystalReports.Engine.Area Area, int Indent)<\/code>
\n {<\/code>
\n Output(\"Area: \" + Area.Name, Indent);<\/code>
\n Output(\"Kind: \" + Area.Kind.ToString(), Indent+2);<\/code>
\n Output(\"Suppress: \" + Area.AreaFormat.EnableSuppress.ToString(), Indent + 2);<\/code>
\n Output(\"Keep Together: \" + Area.AreaFormat.EnableKeepTogether.ToString(), Indent + 2);<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.Section Section in Area.Sections)<\/code>
\n {<\/code>
\n MapSection(Section, Indent + 2);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapSection(CrystalDecisions.CrystalReports.Engine.Section Section, int Indent)<\/code>
\n {<\/code>
\n \/\/Print the Section properties<\/code>
\n Output(\"Section: \" + Section.Name, Indent);<\/code>
\n Output(\"Suppress: \" + Section.SectionFormat.EnableSuppress.ToString(), Indent);<\/code>
\n Output(\"Keep Together: \" + Section.SectionFormat.EnableKeepTogether.ToString(), Indent);<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.ReportObject ReportObject in Section.ReportObjects)<\/code>
\n {<\/code>
\n MapReportObject(ReportObject, Indent + 2);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapReportObject(CrystalDecisions.CrystalReports.Engine.ReportObject ReportObject, int Indent)<\/code>
\n {<\/code>
\n switch(ReportObject.Kind)<\/code>
\n {<\/code>
\n case CrystalDecisions.Shared.ReportObjectKind.TextObject:<\/code>
\n {<\/code>
\n MapTextObject(((CrystalDecisions.CrystalReports.Engine.TextObject)ReportObject), Indent);<\/code>
\n break;<\/code>
\n }<\/code>
\n case CrystalDecisions.Shared.ReportObjectKind.FieldObject:<\/code>
\n {<\/code>
\n MapFieldObject(((CrystalDecisions.CrystalReports.Engine.FieldObject)ReportObject), Indent);<\/code>
\n break;<\/code>
\n }<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapTextObject(CrystalDecisions.CrystalReports.Engine.TextObject TextObject, int Indent)<\/code>
\n {<\/code>
\n Output(\"Name: \" + TextObject.Name, Indent);<\/code>
\n Output(\"Kind: \" + TextObject.Kind.ToString(), Indent + 2);<\/code>
\n Output(\"Text: \" + TextObject.Text, Indent + 2);<\/code>
\n }<\/code>
\n public void MapFieldObject(CrystalDecisions.CrystalReports.Engine.FieldObject FieldObject, int Indent)<\/code>
\n {<\/code>
\n Output(\"Name: \" + FieldObject.Name, Indent);<\/code>
\n Output(\"Kind: \" + FieldObject.Kind.ToString(), Indent + 2);<\/code>
\n Output(\"DataSource.Name: \" + FieldObject.DataSource.Name, Indent + 2);<\/code>
\n Output(\"DataSource.Formula: \" + FieldObject.DataSource.FormulaName, Indent + 2);<\/code>
\n }<\/code>
\n public void Output(string Line, int Indent)<\/code>
\n {<\/code>
\n lstMapping.Items.Add(new string(' ',Indent) + Line);<\/code>
\n }<\/code>
\n Listing 15-4. Get a reference to the ReportFooter section.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.Section MySection;<\/code>
\n MySection = MyReport.ReportDefinition.Sections[\"ReportFooter\"];<\/code>
\n Listing 15-5. Get a reference to the report object State using the ReportObject data type.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportObject MyObject;<\/code>
\n MyObject = MyReport.ReportDefinition.ReportObjects[\"State\"];<\/code>
\n Listing 15-6. Get a reference to the State object using the object’s specific data type.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.FieldObject MyField;<\/code>
\n MyField = (CrystalDecisions.CrystalReports.Engine.FieldObject)<\/code>
\n MyReport.ReportDefinition.ReportObjects[\"State\"];<\/code>
\n Listing 15-7. Modify properties of the ReportFooter section.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.Section MySection;<\/code>
\n MySection = MyReport.ReportDefinition.Sections[\"ReportFooter\"];<\/code>
\n MySection.SectionFormat.EnableKeepTogether = true;<\/code>
\n MySection.SectionFormat.EnableSuppress = false;<\/code>
\n Listing 15-8. Modify the border of the report object State using the ReportObject data type.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportObject MyObject;<\/code>
\n MyObject = MyReport.ReportDefinition.ReportObjects[\"State\"];<\/code>
\n MyObject.Border.TopLineStyle = CrystalDecisions.Shared.LineStyle.SingleLine;<\/code>
\n MyObject.Border.BottomLineStyle = CrystalDecisions.Shared.LineStyle.DoubleLine;<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n Listing 15-9. Modify the line properties of the object Line using the object’s specific data type.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.LineObject MyLine;<\/code>
\n MyLine = (CrystalDecisions.CrystalReports.Engine.LineObject)<\/code>
\n MyReport.ReportDefinition.ReportObjects[\"Line1\"];<\/code>
\n MyLine.LineStyle = CrystalDecisions.Shared.LineStyle.DashLine;<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n Listing 15-10. Modify the Text property of a TextObject located in ReportHeader.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.TextObject MyText;<\/code>
\n MyText = (CrystalDecisions.CrystalReports.Engine.TextObject)<\/code>
\n MyReport.ReportDefinition.ReportObjects[\"HeaderText\"];<\/code>
\n MyText.Text = \"New Report Header\";<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n Listing 15-11. Mapping the sorting and grouping objects.<\/code_Caption>
\n private void Form1_Load(object sender, System.EventArgs e)<\/code>
\n {<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n MapSortFields(MyReport.DataDefinition.SortFields, 0);<\/code>
\n Output(\"---\",0);<\/code>
\n MapGroups(MyReport.DataDefinition.Groups, 0);<\/code>
\n }<\/code>
\n public void MapSortFields(CrystalDecisions.CrystalReports.Engine.SortFields SortFields, int Indent)<\/code>
\n {<\/code>
\n Output(\"Total SortFields: \" + SortFields.Count, Indent);<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.SortField SortField in SortFields)<\/code>
\n {<\/code>
\n MapSortField(SortField, Indent);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapSortField(CrystalDecisions.CrystalReports.Engine.SortField SortField, int Indent)<\/code>
\n {<\/code>
\n MapFieldDefinition(SortField.Field, Indent);<\/code>
\n Output(\"Direction: \" + SortField.SortDirection.ToString(), Indent + 2);<\/code>
\n Output(\"Type: \" + SortField.SortType.ToString(), Indent + 2);<\/code>
\n }<\/code>
\n public void MapGroups(CrystalDecisions.CrystalReports.Engine.Groups Groups, int Indent)<\/code>
\n {<\/code>
\n Output(\"Total Groups: \" + Groups.Count, Indent);<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.Group Group in Groups)<\/code>
\n {<\/code>
\n MapGroup(Group, Indent + 2);<\/code>
\n }<\/code>
\n }<\/code>
\n public void MapGroup(CrystalDecisions.CrystalReports.Engine.Group Group, int Indent)<\/code>
\n {<\/code>
\n MapFieldDefinition(Group.ConditionField, Indent);<\/code>
\n }<\/code>
\n public void MapFieldDefinition(CrystalDecisions.CrystalReports.Engine.FieldDefinition FieldDefinition, int Indent)<\/code>
\n {<\/code>
\n Output(\"Field Name: \" + FieldDefinition.Name, Indent);<\/code>
\n Output(\"Formula: \" + FieldDefinition.FormulaName, Indent + 2);<\/code>
\n Output(\"Kind: \" + FieldDefinition.Kind.ToString(), Indent + 2);<\/code>
\n Output(\"Value Type: \" + FieldDefinition.ValueType.ToString(), Indent + 2);<\/code>
\n }<\/code>
\n public void Output(string Line, int Indent)<\/code>
\n {<\/code>
\n lstMapping.Items.Add(new string(' ',Indent) + Line);<\/code>
\n }<\/code>
\n Listing 15-12. Changing the sort direction of a field<\/code_Caption>
\n private void btnModifySorting_Click(object sender, System.EventArgs e)<\/code>
\n {<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n \/\/Modify the order of the OrderDate field to Descending<\/code>
\n \/\/Reference the fields by traversing the sort fields collection<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.SortField MySortField in<\/code>
\n MyReport.DataDefinition.SortFields)<\/code>
\n {<\/code>
\n if (MySortField.Field.Name == \"Last Name\")<\/code>
\n {<\/code>
\n \/\/There are two different sort objects with this name<\/code>
\n \/\/Make sure its a record sort.<\/code>
\n if (MySortField.SortType ==<\/code>
\n CrystalDecisions.Shared.SortFieldType.RecordSortField)<\/code>
\n {<\/code>
\n MySortField.SortDirection =<\/code>
\n CrystalDecisions.Shared.SortDirection.DescendingOrder;<\/code>
\n }<\/code>
\n }<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n }<\/code>
\n }<\/code>
\n Listing 15-13. Modifying a group’s field<\/code_Caption>
\n private void btnModifyGrouping_Click(object sender, System.EventArgs e)<\/code>
\n {<\/code>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.DatabaseFieldDefinition MyField;<\/code>
\n \/\/Modify the group to use CustomerName rather than Orderdate<\/code>
\n \/\/Get the field to base the group on<\/code>
\n MyField = MyReport.Database.Tables[\"Employee\"].Fields[\"First Name\"];<\/code>
\n \/\/Reference the group by traversing the Groups collection<\/code>
\n foreach(CrystalDecisions.CrystalReports.Engine.Group MyGroup in MyReport.DataDefinition.Groups)<\/code>
\n {<\/code>
\n if (MyGroup.ConditionField.Name == \"Last Name\")<\/code>
\n {<\/code>
\n MyGroup.ConditionField = MyField;<\/code>
\n }<\/code>
\n }<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n }<\/code>
\n Listing 15-14. Open a subreport using the subreport name.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportDocument MySubReport;<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportObject MyReportObject;<\/code>
\n CrystalDecisions.CrystalReports.Engine.TextObject MyText;<\/code>
\n MySubReport = MyReport.OpenSubreport(\"Sales Subreport\");<\/code>
\n MyText = (CrystalDecisions.CrystalReports.Engine.TextObject)<\/code>
\n MyReport.ReportDefinition.ReportObjects[\"Text3\"];<\/code>
\n MyText.ObjectFormat.EnableSuppress = true;<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code>
\n Listing 15-15. Find subreports using the ReportObjects collection.<\/code_Caption>
\n CrystalReport1 MyReport = new CrystalReport1();<\/code>
\n CrystalDecisions.CrystalReports.Engine.SubreportObject MySubreportObject;<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportDocument MySubreport; foreach(CrystalDecisions.CrystalReports.Engine.ReportObject MyReportObject in MyReport.ReportDefinition.ReportObjects)<\/code>
\n {<\/code>
\n if (MyReportObject.Kind == CrystalDecisions.Shared.ReportObjectKind.SubreportObject){<\/code>
\n MySubreportObject = (CrystalDecisions.CrystalReports.Engine.SubreportObject)MyReportObject;<\/code>
\n MySubreport = MySubreportObject.OpenSubreport(MySubreportObject.SubreportName);<\/code>
\n MySubreport.RecordSelectionFormula = \"\";<\/code>
\n }<\/code>
\n }<\/code>
\n crystalReportViewer1.ReportSource = MyReport;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

C# Code Listings The C# code listings are equivalent to the VB.NET code listings. Listing 15-1. Changing the selection formula with the ReportDocument object. CrystalReport1 MyReport = new CrystalReport1(); MyReport.DataDefinition.RecordSelectionFormula = “{Orders.Order Date} in Date (1996, 02, 19) to Date (1996, 03, 28)”; crystalReportViewer1.ReportSource = MyReport; Listing 15-2. Changing the selection formula with the viewer […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,2],"tags":[],"class_list":["post-646","post","type-post","status-publish","format-standard","hentry","category-chapter-15-runtime-customization","category-crystal-reportsnet-2003","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/646","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=646"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/646\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=646"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}