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 |
|
pmak
Starting Member
41 Posts |
 Posted - 2006-03-30 : 12:37:36
|
| Can I build an expression on a textbox in a report using Sql 2000 reporting services with a "Sql Select" statement based on the dataset? There is a parameter user selected on the dropdown and it generates a dataset from the store procedure. This parameter is used on a subquery for this dataset in the store procedure and it will return with the records containing other parameter IDs. However I need to assign a record on a textbox and require to filter out the record with the same parameterID user selected in the dropdown. Thanks.Eg. Parameters!Person.Value=2 selected in the dropdownRecordset: SearchNamePersonID LName FName1 Doe John2 Doe Peter3 Doe JaneI need to assign the the name Doe, Peter on a textbox. |
|
|
snktheone
Starting Member
20 Posts |
Posted - 2006-04-06 : 07:49:16
|
| since the textbox does not fall into any data region you canot access the Fields for the textbox.to do that you need to enclose the textbox in a list controland then select the same data region as your dataset.If you want to populate the textbox with the selected parameter from the drop down you can simply assign =Parameter!EmpId.Value. |
 |
|
|
|
|
|
Expression in a textbox...