11 Replies Latest reply on Mar 12, 2015 1:00 PM by Bill Lyons

    Custom SQL Error

    Elizabeth Coleman


      Any help is appreciated.  I'm getting an Database error when trying to create custom SQL:

       

      Database error 0x80040E10: No value given for one or more required parameters.
        ; The query: SELECT TOP 1 *
      FROM (
        SELECT
          [ActualRevenue$].[Invoice Date] AS [Test Date],
          [ActualRevenue$].[Proj Mgr] AS [Proj Mgr],
          [ActualRevenue$].[Sales Order] AS [Sales Order],
          [ActualRevenue$].[Equip $] AS [Equip $],
          [ActualRevenue$].[VAS $] AS [VAS $],
          [ActualRevenue$].[Other $] AS [Other $],
          [ActualRevenue$].[Work Center] AS [Work Center],
          [ActualRevenue$].[Customer] AS [Customer],
          [ActualRevenue$].[Order Creation Date] AS [Order Creation Date],
          [ActualRevenue$].[Fiscal Month] AS [Fiscal Month],
       
       
          "A" as [Type]
       
          FROM [ActualRevenue$]
       
           UNION
       
        SELECT
          [ForecastCurrentMonth$].[Planned Start of Month] AS [Test Date],
          [ForecastCurrentMonth$].[Proj Mgr] AS [Proj Mgr],
          [ForecastCurrentMonth$].[Sales Order] AS [Sales Order],
          [ForecastCurrentMonth$].[Equip $] AS [Equip $],
          [ForecastCurrentMonth$].[VAS $] AS [VAS $],
          [ForecastCurrentMonth$].[Other $] AS [Other $],
          [ForecastCurrentMonth$].[Work Center] AS [Work Center],
          [ForecastCurrentMonth$].[Customer] AS [Customer],
          [ForecastCurrentMonth$].[Order Creation Date] AS [Order Creation Date],
          [ForecastCurrentMonth$].[Fiscal Month] AS [Fiscal Month],
         
       
          "F" as [Type]
         FROM [ForecastCurrentMonth$]
      ) [Custom SQL Query]

      Database error 0x80040E10: No value given for one or more required parameters.
        ; The query: SELECT TOP 1 *
      FROM (
        SELECT
          [ActualRevenue$].[Invoice Date] AS [Test Date],
          [ActualRevenue$].[Proj Mgr] AS [Proj Mgr],
          [ActualRevenue$].[Sales Order] AS [Sales Order],
          [ActualRevenue$].[Equip $] AS [Equip $],
          [ActualRevenue$].[VAS $] AS [VAS $],
          [ActualRevenue$].[Other $] AS [Other $],
          [ActualRevenue$].[Work Center] AS [Work Center],
          [ActualRevenue$].[Customer] AS [Customer],
          [ActualRevenue$].[Order Creation Date] AS [Order Creation Date],
          [ActualRevenue$].[Fiscal Month] AS [Fiscal Month],
       
       
          "A" as [Type]
       
          FROM [ActualRevenue$]
       
           UNION
       
        SELECT
          [ForecastCurrentMonth$].[Planned Start of Month] AS [Test Date],
          [ForecastCurrentMonth$].[Proj Mgr] AS [Proj Mgr],
          [ForecastCurrentMonth$].[Sales Order] AS [Sales Order],
          [ForecastCurrentMonth$].[Equip $] AS [Equip $],
          [ForecastCurrentMonth$].[VAS $] AS [VAS $],
          [ForecastCurrentMonth$].[Other $] AS [Other $],
          [ForecastCurrentMonth$].[Work Center] AS [Work Center],
          [ForecastCurrentMonth$].[Customer] AS [Customer],
          [ForecastCurrentMonth$].[Order Creation Date] AS [Order Creation Date],
          [ForecastCurrentMonth$].[Fiscal Month] AS [Fiscal Month],
         
       
          "F" as [Type]
         FROM [ForecastCurrentMonth$]
      ) [Custom SQL Query]