[cognos relational model]
I have a Self drill through report .where i created two parameters in child and defined Optional.
Now if i Run the report for first time it pops up a Prompt page asking to enter values for those 2 parameters, i can click 'OK' with out giving any values and the report runs -->fine.
TASK: Now i need to avoid this page coming up everytime for 1st run.I should not pass any default value as i should see all data in that query subject.
I Tried: I tried to use some macros like [sales region] = #sb(prompt('s_region','String','sales region'))#
So that for first time it takes all sales region and in run time if i click any sales region it will pass 'sales region' data item to the child and filters.
But Not woking...Its not passing any default values...
Can any body help me out Plzzz
Thanks for your time.
The Prompt page will show if you have a prompt page in the child report or you have a filter defined as 'required'. Where did you create that macro? In the child report? and where did you create those 2 prompts? On the prompt page?
If you want the child report to run with all Sales Regions, you don't need to pass any parameter from the Master Report, just creating a drill thru would be fine. Put the parameters on the report page in the child report.
hi
Thanks For the reply and actually i didnt create any prompt pages. And there is no child report.Its a self drill through so child query.
But i solved it. parameter for region was not fed with any values so giving the prompt page at run time asking values to provide.
How i solved is ,i created a value prompt using same region parameter and then hided the value prompt.Then its now taking region parameter as Optional.
Thanks for ur time..