Skip to content

Query: Qry Report Current Pipeline EP Detail by Principal Project

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur Company Principal Projects
  • CompanyStatus
  • Lead Types
  • Products
  • Entrepreneur Company
  • IndustryLookup
  • ProgressCategory
  • ProcessStatus
  • Entrepreneur Company Programme Years
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • [Lead Types].[Lead Source]
  • IIf(IsNull([CompanyStatus].[Sort Order]),[ProcessStatus].[Sort Order],[CompanySt
  • Entrepreneurs.[Entrepreneur ID]
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Brief Description of Business]
  • IIf(IsNull([CompanyStatus].[Status]),[ProgressCategory].[Progress Category],[Com
  • IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr
  • [Delivery Locations].[Delivery Location]
  • Industry
  • Entrepreneurs.[Process Status ID]
  • IIf(IsNull([Principal Project Pillars].[Principal Project ID]),[Recommended Prin

Where Clause

(((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]

Order By

IIf(IsNull([CompanyStatus].[Sort Order]),[ProcessStatus].[Sort Order],[CompanySt, [First Name] & \

SQL

SELECT [Lead Types].[Lead Source], IIf(IsNull([CompanyStatus].[Sort Order]),[ProcessStatus].[Sort Order],[CompanySt, Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Entrepreneur Company ID], [First Name] & \, [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], IIf(IsNull([CompanyStatus].[Status]),[ProgressCategory].[Progress Category],[Com, IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr, [Delivery Locations].[Delivery Location], IndustryLookup.Industry, Entrepreneurs.[Process Status ID], IIf(IsNull([Principal Project Pillars].[Principal Project ID]),[Recommended Prin FROM [Entrepreneurs], [ProcessStatus], [ProgressCategory], [Lead Types], [Products], [Entrepreneur Company], [IndustryLookup], [Delivery Locations], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [Principal Project Pillars], [Products] WHERE (((Entrepreneurs.[Process Status ID])<>41 And (Entrepreneurs.[Process Status ID]