Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-02-26 : 01:47:45
|
| HiI have a dataset that populates the drop-down list of a report parameter. This dataset has two columns, one column in a customer code and the second column is a date for the customer's last order.What I am trying to get to work is to use the customer code as a value for one parameter and the customer latest order date as the value for another parameter. I then use both these parameters in the two main datasets when the user clicks the View Report button.The first parameter gets set correctly, but the second parameter (for the date) does not. If my list of customer codes in the parameter drop-down list (based on preceeding parameters that filter the list) is more than one item, the customer date is ALWAYS the first row's value...even if I choose the second or tenth item from the list.Not sure if I am making sense, but has anyone been able to get something like this to work?Basically, I'd like it if the selection from the drop-down list would set the value of two different parameters.Thanks - will |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-26 : 08:55:26
|
| sorry you're not making much sense. can you post some sample data to illustrate your problem------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-02-26 : 15:58:53
|
| No worries, my sense-making abilities have rapidly diminished since the beginning of 2010.And, I figured out a way around my dilemma. |
|
|
|
|
|
|
Two parameters from one dataset?