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.
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
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..
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