If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Solved] Parameters not refreshing

Started by bdybldr, 13 Apr 2006 01:26:23 PM

Previous topic - Next topic

bdybldr

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.

zenith

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

zenith

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

bdybldr

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.

bdybldr