问SSRS:参数不过滤MySQL查询

EN

 SELECT HD_QUEUE.NAME as qname, HD_TICKET.ID, HD_TICKET.CREATED, HD_TICKET.TIME_CLOSED, CUSTOMER.FULL_NAME as custfullname, 
     HD_STATUS.NAME as statname, HD_TICKET.TITLE, left(ASSIGNEE.FULL_NAME, 40) as assignee, 
     HD_PRIORITY.NAME as pname, HD_CATEGORY.NAME as catname
    FROM  HD_TICKET 
     INNER JOIN HD_QUEUE
    ON HD_TICKET.HD_QUEUE_ID = HD_QUEUE.ID
    INNER JOIN USER CUSTOMER
    ON HD_TICKET.SUBMITTER_ID=CUSTOMER.ID
    INNER JOIN USER ASSIGNEE
    ON HD_TICKET.OWNER_ID=ASSIGNEE.ID 
     INNER JOIN HD_STATUS 
     ON (HD_TICKET.HD_STATUS_ID=HD_STATUS.ID) 
     AND (HD_TICKET.HD_QUEUE_ID=HD_STATUS.HD_QUEUE_ID)
    INNER JOIN HD_PRIORITY
    ON HD_TICKET.HD_PRIORITY_ID = HD_PRIORITY.ID
      and HD_TICKET.HD_QUEUE_ID = HD_PRIORITY.HD_QUEUE_ID
      INNER JOIN HD_CATEGORY
    ON HD_TICKET.HD_CATEGORY_ID = HD_CATEGORY.ID
    and HD_TICKET.HD_QUEUE_ID = HD_CATEGORY.HD_QUEUE_ID
    left join ASSET on ASSET.ID = HD_TICKET.ASSET_ID
    left join ASSET_DATA_6 on ASSET.ASSET_DATA_ID = ASSET_DATA_6.ID
    WHERE (HD_STATUS.NAME = 'Closed'
    AND HD_TICKET.TIME_CLOSED < @date_param);