Finally, we get to see how everything works by demonstating the code which creates all the necessary objects and calls the AddDatabaseField() method to put the object on the report. This code uses the Form_Load() event so that report is built immediately when the form opens. Of course, you can copy and paste this code into the appropriate method for your application.<\/p>\n
Listing 20-9. Demonstrating adding a database field to the report.<\/b> Demonstrate Adding a Database Field to the Report Finally, we get to see how everything works by demonstating the code which creates all the necessary objects and calls the AddDatabaseField() method to put the object on the report. This code uses the Form_Load() event so that report is built immediately when the form opens. Of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47,40],"tags":[],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-chapter-20-dynamic-report-modification","category-crystal-reportsnet-2008","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/929","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=929"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/929\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n [VB.NET]<\/b>
\n Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<\/code>
\n 'Declare both the reporting objects<\/code>
\n Dim myReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument = Nothing<\/code>
\n Dim rcd As CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument = Nothing<\/code>
\n OpenReportClientDocument(\"C:\\CrystalReport1.rpt\", myReportDocument, rcd)<\/code>
\n 'Create the fontcolor object<\/code>
\n Dim FontColor As CrystalDecisions.ReportAppServer.ReportDefModel.FontColor<\/code>
\n FontColor = NewFontColor(10, \"Times New Roman\", True, False)<\/code>
\n 'Get a reference to the section where the object will be placed<\/code>
\n Dim mySection As CrystalDecisions.ReportAppServer.ReportDefModel.Section<\/code>
\n mySection = GetSection(\"DetailArea1\", 0, rcd)<\/code>
\n 'Add the object to the report<\/code>
\n AddDatabaseField(\"Orders\", \"Ship Via\", 0, 1000, 221, 1000, mySection, FontColor, rcd)<\/code>
\n CrystalReportViewer1.ReportSource = myReportDocument<\/code>
\n End Sub<\/code>
\n [C#]<\/b>
\n private void Form1_Load(object sender, EventArgs e)<\/code>
\n {<\/code>
\n \/\/ Declare both of the reporting objects<\/code>
\n CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument = null;<\/code>
\n CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument rcd = null;<\/code>
\n \/\/Load the report into memory<\/code>
\n OpenReportClientDocument(@\"C:\\CrystalReport1.rpt\", ref myReportDocument, ref rcd);<\/code>
\n \/\/Create the fontcolor object<\/code>
\n CrystalDecisions.ReportAppServer.ReportDefModel.FontColor FontColor;<\/code>
\n FontColor = NewFontColor(10, \"Times New Roman\", true, false);<\/code>
\n \/\/Get a reference to the section where the report object will be placed<\/code>
\n CrystalDecisions.ReportAppServer.ReportDefModel.Section mySection;<\/code>
\n mySection = GetSection(\"DetailArea1\", 0, rcd);<\/code>
\n \/\/Create the report object and place it on the report<\/code>
\n AddDatabaseField(\"Orders\", \"Ship Via\", 0, 1000, 221, 1000, mySection, FontColor, rcd);<\/code>
\n \/\/Preview the report in the viewer<\/code>
\n crystalReportViewer1.ReportSource = myReportDocument;<\/code>
\n }<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"