The code to add the database field to the report creates a new field object and uses the objects created in the previous code listings to set its properties. To try and keep the method as simple as possible, the FontClass object and Section object must be created prior to calling this method. That code will be shown in the next section.<\/p>\n
The arguments in this method are pretty self-explanatory. You pass it the table name and field name of the database field you want to put on the report. Next you give it the object coordinates and dimensions. After that are the Section and FontColor objects.<\/p>\n
Listing 20-8. Adding the database field to the report.<\/b> To keep this code as understandable as possible, I left out many of the advanced formatting properties available. For example, you can set the properties EnableCanGrow, EnableSuppress, EnableKeepTogether, etc. These properties are found in the ISCRFieldObject.Format class. If you want to set these properties as well, in the previous listing you can add code similar to the following:<\/p>\n As you can see, the RAS SDK exposes many properties that let you customize the formatting of a report object. To see a complete list of properties, please consult the help file.<\/p>\n","protected":false},"excerpt":{"rendered":" Add Database Field to the Report The code to add the database field to the report creates a new field object and uses the objects created in the previous code listings to set its properties. To try and keep the method as simple as possible, the FontClass object and Section object must be created prior […]<\/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-928","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\/928","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=928"}],"version-history":[{"count":0,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/928\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=928"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n [VB.NET]<\/b>
\n Public Shared Sub AddDatabaseField(ByVal TableName As String, ByVal FieldName As String, ByVal Top As Integer, ByVal Left As Integer, ByVal Height As Integer, ByVal Width As Integer, ByVal Section As CrystalDecisions.ReportAppServer.ReportDefModel.Section, ByVal FontColor As CrystalDecisions.ReportAppServer.ReportDefModel.FontColor, ByVal rcd As CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument)<\/code>
\n 'Find the data source field to place to add to the report<\/code>
\n Dim myField As CrystalDecisions.ReportAppServer.DataDefModel.Field<\/code>
\n myField = GetField(TableName, FieldName, rcd)<\/code>
\n 'Create the report object that will be added to the report<\/code>
\n Dim myFieldObject As CrystalDecisions.ReportAppServer.ReportDefModel.ISCRFieldObject<\/code>
\n myFieldObject = New CrystalDecisions.ReportAppServer.ReportDefModel.FieldObjectClass()<\/code>
\n myFieldObject.Kind = CrystalDecisions.ReportAppServer.ReportDefModel.CrReportObjectKindEnum.crReportObjectKindField<\/code>
\n myFieldObject.FieldValueType = myField.Type<\/code>
\n myFieldObject.DataSource = myField.FormulaForm<\/code>
\n myFieldObject.Left = Left<\/code>
\n myFieldObject.Top = Top<\/code>
\n myFieldObject.Width = Width<\/code>
\n myFieldObject.Height = Height<\/code>
\n myFieldObject.FontColor = FontColor<\/code>
\n 'Add the report object to the correct section<\/code>
\n rcd.ReportDefController.ReportObjectController.Add(myFieldObject, Section, 0)<\/code>
\n End Sub<\/code>
\n [C#]<\/b>
\n public static void AddDatabaseField(string TableName, string FieldName, int Top, int Left, int Height, int Width, CrystalDecisions.ReportAppServer.ReportDefModel.Section Section,<\/code>
\n CrystalDecisions.ReportAppServer.ReportDefModel.FontColor FontColor,<\/code>
\n CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument rcd)<\/code>
\n {<\/code>
\n \/\/Find the data source field to place to add to the report<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.Field myField;<\/code>
\n myField = GetField(TableName, FieldName, rcd);<\/code>
\n \/\/Create the report object that will be added to the report<\/code>
\n CrystalDecisions.ReportAppServer.ReportDefModel.FieldObject myFieldObject;<\/code>
\n myFieldObject = new CrystalDecisions.ReportAppServer.ReportDefModel.FieldObjectClass();<\/code>
\n myFieldObject.Kind = CrystalDecisions.ReportAppServer.ReportDefModel.CrReportObjectKindEnum.crReportObjectKindField;<\/code>
\n myFieldObject.FieldValueType = myField.Type;<\/code>
\n myFieldObject.DataSource = myField.FormulaForm;<\/code>
\n myFieldObject.Left = Left;<\/code>
\n myFieldObject.Top = Top;<\/code>
\n myFieldObject.Width = Width;<\/code>
\n myFieldObject.Height = Height;<\/code>
\n myFieldObject.FontColor = FontColor;<\/code>
\n \/\/Add the report object to the correct section<\/code>
\n rcd.ReportDefController.ReportObjectController.Add(myFieldObject, Section, 0);<\/code>
\n }<\/code><\/p>\nmyFieldObject.Format.EnableCanGrow = True<\/code>
\n myFieldObject.Format.HyperlinkText = \"http:\/\/www.CrystalReportsBook.com\"<\/code>
\n myFieldObject.Format.EnableSuppress = False<\/code><\/p>\n