Contains the customized join preferences that enables Interactive Reporting to include or exclude appropriate tables based on the items referenced on the Request and Limit lines.
This example shows how to select the user-defined join path option, and change a defined join path by adding a join path topic:
ActiveDocument.Sections["Query"].DataModel.JoinsOptions.Type= bqDataModelJoinsOptionDefJoin ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath ["MyJoinPath"].AddTopic("Periods")
This example shows how to select the user defined join path option, create a defined join path, and add all join path topics to the defined join path:
ActiveDocument.Sections["Query"].DataModel.JoinsOptions.Type= bqDataModelJoinsOptionDefJoin ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath.Add("MyJoinPath") ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath["MyJoinPath"].AddAllTopics()
AddAllTopics(), AddTopic(DefinedJoinPathsName As String), Remove(), RemoveAllTopics(), RemoveTopic(DefinedJoinPathName As String)