Determining Report Parameter inheritence ie Effective Report Parameters

Question

I'm looking for a technique to determine the Effective report parameters for a Report Subscription 
 As a report subscription can inherit parameters from both the RPSReport and DialogReport parameter sets - and can be over written at any of the three levels - is the a build in function or stored proc that returns the effective parameters for an individual Report Subscription ? before I resort to CTE recursive lookups . . . . 
 If I look at the parameters linked to the RPSSubscription directly via DialogParameterSet filter - some of the fixed value parameters defined on the DialogReport and RPSReport parametersets are not include - therefore I assume they will be determined at run time ? What mechanism is used ? 
 with thanks

Markus Weiss-Ehlers · Accepted Answer

Assuming that your process is running at the table RPSSubscription (hence Entity is an RPSSubcription) and assuming that your RPSSubscription entity has an assigned DialogParameterSet via DialogParameterSet.ObjectKeyUsedBy then you can access the value of a parameter with the following code. The code will fetch the value according to the parameter hierarchy as documented in the manuals. 
 Dim pSet as IDialogParameterSet = VI.DB.DialogParameterSet.LoadFor(Session, Entity)
Value = pset.Item("ParameterName").Value 
 If you have more than one parameter you need to access in your code, you might want to create the DialogParameterSet in the pre-script to minimize round-trips..

Endpoint Privilege Management

Determining Report Parameter inheritence ie Effective Report Parameters

Top Replies