quote:

---

Originally posted by duanecwilson

Thank you for your response, but I definitely have parameters in this report and it is running automatically and I don't have defaults. I did have checked on each one to allow NULLS and allow Blanks and it ran automatically. What I did was change one field to allow blanks but not NULLS and then it prompted me. When I allowed NULLs, the NULL box was checked by default, and maybe that is why it ran automatically. But I didn't couldn't control that checkbox and it did not have a default of NULL checked. I don't know why it checks the box by default. It seems like a contradiction. The report does seem to work properly now that I have removed the allow NULL on that first field.

Duane

---

USE [SoftwareReporting]
GO

/****** Object:  StoredProcedure [dbo].[sp_ReportBasic]    Script Date: 03/24/2010 10:08:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[sp_ReportBasic]
		@AppName VARCHAR(255) = NULL,
		@WkstnName VARCHAR(128) = NULL,
		@EmployeeID VARCHAR(255) = NULL,
		@PAYROLL_CO_num VARCHAR(4) = NULL,
		@PAYROLL_RC_num VARCHAR(7) = NULL,
		@MANAGER_EMPLOYEE_ID VARCHAR(255) = NULL
AS
BEGIN
SELECT	v_CommonApp.AppName
		, v_SMSAppData.[Version]
		, v_SMSAppData.WkstnName
		, SMS_Hardware.EmployeeID
		, ePeople_feed.NAME
		, ePeople_feed.PAYROLL_CO_num
		, ePeople_feed.PAYROLL_RC_num
		, ePeople_feed.EMAIL_ADDRESS
		, ePeople_feed.PHONE_NUMBER
		, ePeople_feed.MANAGER_EMPLOYEE_ID
		, ePeople_feed.MANAGER_NAME
		, ePeople_feed.MANAGER_PHONE
FROM    v_SMSAppData 
LEFT JOIN v_CommonApp ON v_SMSAppData.appID = v_CommonApp.AppID 
LEFT JOIN SMS_Hardware ON v_SMSAppData.WkstnName = SMS_Hardware.wksname 
LEFT JOIN ePeople_feed ON SMS_Hardware.EmployeeID = ePeople_feed.EMPLOYEE_ID
WHERE (@AppName IS NULL OR AppName LIKE '%' + @AppName + '%')
  AND (@WkstnName IS NULL OR WkstnName LIKE '%' + @WkstnName + '%')
  AND (@EmployeeID IS NULL OR EmployeeID = @EmployeeID)
  AND (@PAYROLL_CO_num IS NULL OR PAYROLL_CO_num = @PAYROLL_CO_num)
  AND (@PAYROLL_RC_num IS NULL OR PAYROLL_RC_num = @PAYROLL_RC_num)
  AND (@MANAGER_EMPLOYEE_ID IS NULL OR EmployeeID = @MANAGER_EMPLOYEE_ID)
ORDER BY v_CommonApp.AppName
END

GO

  <ReportParameters>
    <ReportParameter Name="AppName">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>App Name</Prompt>
    </ReportParameter>
    <ReportParameter Name="WkstnName">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>Wkstn Name</Prompt>
    </ReportParameter>
    <ReportParameter Name="EmployeeID">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>Employee ID</Prompt>
    </ReportParameter>
    <ReportParameter Name="PAYROLL_CO_num">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>PAYROLL CO num</Prompt>
    </ReportParameter>
    <ReportParameter Name="PAYROLL_RC_num">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>PAYROLL RC num</Prompt>
    </ReportParameter>
    <ReportParameter Name="MANAGER_EMPLOYEE_ID">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>MANAGER EMPLOYEE ID</Prompt>
    </ReportParameter>
  </ReportParameters>