Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Dynamic Parameters
Migrateduser
Given that I have two parameters for my report
[BRANCH] representing a branch of the bank
[ACCOUNT] representing an account number of the bank
The data set has the [ACCOUNT] as a unique key along with [BRANCH] i.e. each account number belongs to only one branch.
I originally set up the report with a cascading group of parameters starting with [BRANCH] and then [ACCOUNT] so the report would always generate a result from the dynamic nature of the Cascading Parameter group.
Of course I had linked the parameters to the dataset with the 'WHERE Data.Branch = ? and Data.Account = ?'
conditions and linked the parameters to this.
There was a BUT from the users of teh report.
"BUT I also want to select all the accounts for one branch , I want to select all the accounts for the bank and I dont know what branch the account is for but I know the account number".
Given these scenarios yes one could easily solve the problem by creating a copy of the report and use various different parameter sets to achieve the result. However this report is all a drilldown report from another report and as such may be re-run whilst being in drilldown mode.
I moved the [BRANCH] and [ACCOUNT] paramters to normal parameters from cascading group to allow the use of an all default value of '%'. I also altered the WHERE statements to "WHERE data.branch like ?" etc.
This has partially worked except that the dynamic relationship between the parameters is now lost because I only get all the items on the [ACCOUNT] list for the parameter.
I would like to know that when the [BRANCH] parameter changes from '%' default to any of the selections available this then makes the dropdown list for the [ACCOUNT] to have still the default of '%' for all but only those accounts for the branch selected i.e. it acts similar to Cascade Group but allows all records to be selected.
Any ideas or methods of doing this would be greatly appreciated as a solution will be used for a more adventurous report where we have [YEAR] [MONTH] [DAY] [HOUR] as the parameters that need for obvious reasons to follow along the same lines of ALL or selection from the top [YEAR] down to the [HOUR]
Find more posts tagged with
Comments
There are no comments yet