Reporting Services :: Create A Report With Declared Value

I use BIDS 2008 R2 and  I have a SQL script that works fine and gives me the desired output in SQL Management studio.

declare @dt datetime
select @dt = '2015-09-10 08:23:28.000'
select
    ref_id
    ,desn
    ,tran_date
    ,payment_due
    ,ref1
    ,gross_val
     from acptran (nolock) where seq_id in (select seq_id from acptcash (nolock) where date_time = @dt)
order by ref_id,ref1

However i need to create a report so that someone else can enter the date time as a parameter in a report to get the required results. Normally i would drop my SQL script into BIDS and it would create the dataset but as this has a declared value it gives an error "The Declare SQL construct or statement is not supported."