If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report not returning any data

Started by barrysaab, 09 Oct 2011 12:18:15 PM

Previous topic - Next topic

barrysaab

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.
Boy! Cognos getting on to me!!!

blom0344

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?