The report’s data source points to all the tables and fields that can be printed. Even if a field isn’t displayed on the report, it will still be in the data source if the report’s query specifies it to be available. The RAS object model has methods within the ReportClientDocument.Database class that make it easy to find the table and field you need. As you can see in the comments within the code listing, you first get a reference to the table using the FindAlias() method and pass it the table name. It returns the index of the table in the Tables collection. The next step calls the Table.DataFields.Find() method and passes it the field name. This returns the index of the field in the DataFields collection. A reference to this field is returned to the calling method.<\/p>\n
Listing 20-5. Get a reference to a field in the data source.<\/b> Selecting a Field from a Data Source The report’s data source points to all the tables and fields that can be printed. Even if a field isn’t displayed on the report, it will still be in the data source if the report’s query specifies it to be available. The RAS object model has methods within […]<\/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-925","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\/925","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=925"}],"version-history":[{"count":1,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/925\/revisions"}],"predecessor-version":[{"id":1830,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/925\/revisions\/1830"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=925"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n [VB.NET]<\/b>
\n Public Shared Function GetField(ByVal TableName As String, ByVal FieldName As String, ByVal rcd As CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument) As CrystalDecisions.ReportAppServer.DataDefModel.Field<\/code>
\n Dim FieldIndex As Integer<\/code>
\n Dim TableIndex As Integer<\/code>
\n 'Find the table's location in the table collection<\/code>
\n Dim myTable As CrystalDecisions.ReportAppServer.DataDefModel.Table<\/code>
\n Dim myField As CrystalDecisions.ReportAppServer.DataDefModel.Field<\/code>
\n TableIndex = rcd.Database.Tables.FindByAlias(TableName)<\/code>
\n Dim temp As CrystalDecisions.ReportAppServer.DataDefModel.ISCRTable<\/code>
\n temp = rcd.Database.Tables(TableIndex)<\/code>
\n 'Get a reference to the table object<\/code>
\n myTable = DirectCast(temp, CrystalDecisions.ReportAppServer.DataDefModel.Table)<\/code>
\n 'Find the field's location in the field collection<\/code>
\n FieldIndex = myTable.DataFields.Find(FieldName, CrystalDecisions.ReportAppServer.DataDefModel.CrFieldDisplayNameTypeEnum.crFieldDisplayNameName, CrystalDecisions.ReportAppServer.DataDefModel.CeLocale.ceLocaleUserDefault)<\/code>
\n 'Get a reference to the field object<\/code>
\n myField = DirectCast(myTable.DataFields(FieldIndex), CrystalDecisions.ReportAppServer.DataDefModel.Field)<\/code>
\n Return myField<\/code>
\n End Function<\/code>
\n [C#]<\/b>
\n public static CrystalDecisions.ReportAppServer.DataDefModel.Field GetField(string TableName, string FieldName,<\/code>
\n CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument rcd)<\/code>
\n {<\/code>
\n int FieldIndex, TableIndex;<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.Table myTable;<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.Field myField;<\/code>
\n \/\/Find the table's location in the table collection<\/code>
\n TableIndex = rcd.Database.Tables.FindByAlias(TableName);<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.ISCRTable temp;<\/code>
\n temp = rcd.Database.Tables[TableIndex];<\/code>
\n \/\/Get a reference to the table object<\/code>
\n myTable = (CrystalDecisions.ReportAppServer.DataDefModel.Table)temp;<\/code>
\n \/\/Find the field's location in the field collection<\/code>
\n FieldIndex = myTable.DataFields.Find(FieldName,<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.CrFieldDisplayNameTypeEnum.crFieldDisplayNameName,<\/code>
\n CrystalDecisions.ReportAppServer.DataDefModel.CeLocale.ceLocaleUserDefault);<\/code>
\n \/\/Get a reference to the field object<\/code>
\n myField = (CrystalDecisions.ReportAppServer.DataDefModel.Field)myTable.DataFields[FieldIndex];<\/code>
\n return myField;<\/code>
\n }<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"