I want user prompts for BAM reports so that user will enter From date and To date before displaying the report.
I have tried Prompts but in filter,there is no option of Prompts and Parameters for the Date field and When I create Date type prompt in Change report properties but I dont understand how to use it in the filter.
Please help me out its urgent.
Thanks in advance
Based on filters and surface prompts, you can do the your requirements. but if your not stick with BAM studio.you can use ADF applications to create such reports using BAM data Controls its very easy to manage the dashboards and its shows very rich looking UI too.the below link explains the same
http://docs.oracle.com/cd/E23943_01/dev.1111/e10224/bam_data_control.htm surface prompts
You can do the your requirement based on filters and surface prompts in reports.
this link will explains the concepts http://sqltech.cl/doc/oas11gR1/integration.1111/e10230/bam_data_mod.htm
for latest documentations http://docs.oracle.com/cd/E28271_01/user.1111/e10230/prompts_parameters.htm
and take a look-into this too for dates settings http://docs.oracle.com/cd/E21764_01/integration.1111/e10230/app_datetime.htm#BABHBIDE
Hope this will helpful
Thanks but I didnt get how to prompt for Date.
There are various option like within time period,within time interval etc but all are they are defined in filters but I want to add the time interval by user..
Please help me out.
Oh I understand your requirement.see here in Active Viewer you can't modify the reports, all you can do is only you can see the reports but you can provide Prompts the user specify value. only you can create surface prompt in Active studio and the,,those reports you can able to see in active viewer.while crating design filters only you need to mention the type of *"Prompt the user to specify a value"* option.
to achieve your requirement here is nice step by step example http://www.oracle.com/technetwork/jp/content/tutorial-8-bam-designingreportfilte-130508.pdf
note: Don't forget feed back on my answers!
You have to have two surface prompts. One to capture the lower date parameter, and the one that is the higer date. You then need to have two filders setup on your Report view:
One that filters all rows that the greater than or equal to the lower limit date
...and the other that fielders the rows that are less than or equal to the higher limit.
You basically start from the filter tab in the edit mode of your List views and go about creating the surface prompts