I have a report that runs off a Stored Procedure. The SP looks like this,
CREATE PROCEDURE spCreditCardLogAllUsers
@ImportDate Varchar(20)
AS
SELECT UID, C.CardholderID, CardholderName, Department, CardNumber, CardType, PONum, PODate, Vendor, Description, Amount, CCCObjectCode, ImportDate...