2 Replies Latest reply: Sep 6, 2013 2:10 AM by d8392227-3f02-451d-8311-a7d756de4819 RSS

    Adding Calendar in BAM Reports

    d8392227-3f02-451d-8311-a7d756de4819

      Hi All,

       

                I have a scenario where I have to select FromDate and ToDate dynamically and generate the reports only for the date selected.

      I tried things like Within current Minute, Within time Period 1 minute Ago and so on. but it doesn't meet my requirements.

       

      I should be able to select any date, any year and any month and be able to view the reports for that period.

       

      Adding a Calendar in the report prompts could be the the right option.

       

      Can anyone help me on how to add Calendar to the surface prompts in Oracle BAM Reports

       

      Regards,

      Nataraj R.

        • 1. Re: Adding Calendar in BAM Reports
          S.Ananth

          You can achieve this by adding a Filter with custom parameters/prompts on the report.

          - Edit the report. Create new parameters/prompts, for example: FromDateParam and ToDateParam (as datetime types) with 'Prompt the user to specify a value' option selected and User input type as 'Type in'. You can specify a default value for the parameters.

          - Under Filter tab, add filter expressions - in this scenario here, for example, it will be FromDate >= [Parameter:FromDateParam] and ToDate <= [Parameter:ToDateParam].

          When the report is opened to view, the system will prompt for the FromDate and ToDate to be entered/input by the user (calendar widget will be available to select the dates).

          Hope this addresses your requirement!

          • 2. Re: Adding Calendar in BAM Reports
            d8392227-3f02-451d-8311-a7d756de4819

            Thanks a lot for the response. I have done that.