My report is developed through Sql query,previously we used sysdate-1 function to show sales and onhand ,but now the enduser wants to choice of date range in the prompt page, i have passed on promptmany function for start date an end date,the prompt pa is working fine but when i select from dates the report returning empty page.Appreciate your help.Thanks.
sysdate-1 would imply you are using Oracle native SQL. #promptmany would be used with Cognos SQL. I wonder whether this may cause your issue?