COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: dwsudheer on 03 Sep 2009 05:45:21 AM

Title: PRompt error
Post by: dwsudheer on 03 Sep 2009 05:45:21 AM

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