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

Can I Have Two Different Cascade Sources For the Same Field?

Started by Sheldon, 13 Jul 2012 02:07:31 PM

Previous topic - Next topic

Sheldon

I have a prompt screen with a number of fields.  One of those fields is School District, a required field.  When the user selects the school district, two fields on the prompt screen are populated with values based on the school district they select because I've set up School District to be a cascading source for two other fields, School Building and Grade.  School Building lists all the school buildings in the school district and Grade lists all the grades such as kindergarten, 1st, 2nd, etc. and these two fields are optional.  What I would like is if the user selects a building in the district, the list of grades will change.  e.g. If they choose the high school, then grades like kindergarten, 1st, etc. disappear and all that is shown would be e.g.  9th, 10th, etc.  Since Grade is already updated when School District is chosen, can I set Grade up somehow to also get updated when the School Building is chosen?

Thanks, Sheldon

blom0344

You could use a reprompt button to fill values for Grade based on the selection on School district and School building, which actually means not using an automatic cascade against the Grade prompt altogether.

Use the unlock feature to drag a text item in the reprompt button to allow for a proper directive:  'Please renew list of grades:'

The Grade prompt query then uses 2 filters, like (example for mandatory choise of 1 value each):

[School district] = ?par_school_district? and [School building] = ?par_school_building?