Joined: 19 May 2011
Online Status: Offline
Posts: 337
Posted: 03 Dec 2012 at 3:40am
Hmmm, not sure your goal with this, you could surely save the parameter to a shared variable within a function. Not sure why you would want to apply (pass) a parameter to another parameter, it defeats the purpose of it actually being a parameter of the report.
Joined: 03 Dec 2012
Location: United States
Online Status: Offline
Posts: 1
Posted: 03 Dec 2012 at 7:55am
Hi,
I have the same type of question. I want to have the first parameter be the letters in the alphabet, then when a letter is chosen have the list of agency names befinning with that letter be returned for selection by the user.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 03 Dec 2012 at 8:13am
To do that, you'll need to set up a "Cascading Dynamic Prompt". If you're working from tables, create a SQL Expression that returns the first letter of the agency name. If you're using a command, add an item to your select statement that returns the first letter. Then create a cascading prompt that uses the initial and then uses the full agency name.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
