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-29 : 14:37:05
|
| 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. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How to build an expression on a textbox?