reporting - Can I customize a "Date Prompt" in Cognos8? -
i working cognos8 report studio. in report there 2 date prompts: start date
, end date
. users can select 2 different dates or make them both same date. report has valid data last business date of each month. example, if jan 31 sunday, valid data available jan 29 friday (the last business day of month).
can have customized "date prompt" can disable other dates except last business day of each month? users should able select month-end dates , no other dates?
if understand correctly users can select different dates each selection can last business day of month. start:29-jan-2008 , end:30-mar-2008 or same date start:29-jan-2008 , end:29-jan-2008.
why have days @ all? model data include month/year field e.g. - "jan 2008" , present multi-select list box prompt? sure data source not have gl accounting period field or dictionary can use?
if doesn't work you'll have try calculate last day of month may need include business holidays in particular jurisdiction because last weekday of month not neccessarily last business day of month.
Comments
Post a Comment