This error was raised when I tried to use a cascading dynamic parameter "Prompting failed with the following error message: 'List of Values failure: fail to get values. Cause of error: Failed to retreive data from the database"
There are 3 views used as the datasource for the report.
- Accounts
- Bank Signers
- Signers
I created a cascading dynamic parameter which contains 4 values:
- Legal Entity
- Bank Name
- Bank Acct
- Signer Name
All of the values come from the Accounts view with the exception of the Signer Name. If I leave Signer Name out of the parameter everything works fine, however when it is included the list of values failure error is raised. Does this mean that I can only select fields from one of the views for the cascading dynamic parameter.
Edited by TAH2 - 19 Jan 2012 at 8:08am
IP Logged
