Skip to content

Query: SubQry Rpt Opal Principal Project Summary Criteria

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwPurpleRptOpalPrincipalProjectSummaryCriteria

Columns Selected

  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Entrepreneur Company ID]
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Distribution Model ID]
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Programme Year Status ID
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Delivery Location ID]
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Delivery Location]
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Principal Project ID]
  • [Principal] & \
  • IIf(IsNull([Total Programme Amount]) Or [Total Programme Amount]=0,0,[Allocated
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Total Programme Amount]
  • vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Allocated Amount]

SQL

SELECT vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Entrepreneur Company ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Distribution Model ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Programme Year Status ID, vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Company Delivery Location ID], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Delivery Location], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Principal Project ID], [Principal] & \, IIf(IsNull([Total Programme Amount]) Or [Total Programme Amount]=0,0,[Allocated , vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Total Programme Amount], vwPurpleRptOpalPrincipalProjectSummaryCriteria.[Allocated Amount] FROM [vwPurpleRptOpalPrincipalProjectSummaryCriteria]