Sending 2 different values to 2 datasets using 1 parameter

• jeichelber

  Old Hand

  Points: 326

  More actions

  September 15, 2014 at 3:08 pm

  #290076

  Hello All,

  I was wondering if this is possible. (Freaking non-normalized old database)

  I am trying to get data from two different tables from one parameter. (I only want the user to have to select the location once)

  Here is what I want to do:

  If dataset is equal to "dsOne" then send it "CHE",

  If dataset is equal to "dsTwo" then send it "Chester"

  Is this possible?

• jeichelber

  Old Hand

  Points: 326

  More actions

  September 16, 2014 at 11:43 am

  #1745856

  I don't know if there is a more efficient way to do this, but I resolved this by making the parameter a multiple.

  I modified both datasets to accept multiples. (ie. 'CHE, CHESTER')

  It worked for this issue.