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.........
Hi Revanth,
Good day.
could you please attach your SQL script here?
have fun.
Ben