Custom : Performance Sales Summary Report

Hi,

I am creating a custom version of Performance sales summary report.I just need to add parameters transaction dates ( start and end of trn_dt) along with performance date parameters.To do this I have created a new table (LT--) to store the transaction date along with rundate () etc.I have just copied the existing Infomaker object and saved.

When I am running the report I am geting the error ,Unable to convert datetime to Int which is the same error when I am running the stored procedure from the backend with @rundate = NULL.

I guess this is causing by rundate()/DDL, so I created a temp table instead of a local table and have taken out the parameter historical date.I am still unsuccessful after doing that.

Any suggestions.........