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

PRompt error

Started by dwsudheer, 03 Sep 2009 05:45:21 AM

Previous topic - Next topic

dwsudheer


Hi,

I have a report with prompts,when i run the report with 6/01/08 to 05/13/2009 (prompts) data is populating to report.but in database data is there.Here other than that two dates data is populating to report.cau you suggest me the prob is thereI  am using below scenario.

[Contribution Accelerator].[PLAN_FAQ_SUM].[YR_NUM]*12+[Contribution Accelerator].[PLAN_FAQ_SUM].[MTH_IN_YR_NUM]
between
year(date(?begindate?))*12+month(date(?begindate?))
and
year(date(?enddate?))*12+ month(date(?enddate?))

Thanks in Advance