Hi everyone,
I have a parent report with a list for District Manager quotas and a list for Account Manager quotas.Ã, I have a drill-through to the same report (Sales Detail) on [DMQTDSales] and [AMQTDSales].
I select a sales amount for a DM and drill-through to the Sales Detail Report and then close it and go back to the Quota Report.Ã, Then when I select an AM quota amount and drill-through to the Sales Detail, it shows both the DM and the AM in the ParamDisplayValue in the header.Ã, It also tries to select records based on both the DM value passed and the AM value passed, which could be mutually exclusive and will not return any results.
Is there a way to refresh the parameters that the parent report is passing when I click the drill-through?
Any suggestions?
Thanks.
As far as what I understood from this is
illustrating an example..
In the Parent report I have say order no , product name and retailer name on which
i have drillthroughs for order no and product name .
I have 1 child report with 2 parameters one for order no and 1 for product name
and also a text item which has the paramdisplay value.
So when u run parent report and click on order no ,u drill thru to the child report with param display value as
the order no selected , but when u again click on product name it shows u orderno value previously selected ???
I am also taking 2 lists in this case but i am not facing the problem you are facing , its showing me the parameter i have selected which is = parameter i have selected ....
Also i have selected the option to display in new window in the drill through
Thanks for your responses, zenith. I implemented the solution that Draoued suggested. Removing write access to all user classes and running the report without write access. It prevents parameter values from being stored and subsequently reused.
Thanks again.
Here's the link posted by Draoud...
http://www.tek-tips.com/viewthread.cfm?qid=1188329