Query based Textbox

goodguy1974

Hello Everyone,

How do you display a dataset query result in a textbox

Thanks for the easy answer...

adolf garlic


drag and drop the textbox

set the 'datasetname' on the textbox to whatever your dataset is called

then in the expression editor you can access the result

boink

actually thinking about it, you probably don't need to do the 'datasetname' bit


just right click on the text box and edit expression

then in the panes at the bottom (left hand side) you can see all the cols in your dataset

goodguy1974

Thank you for the quick reply...I will try this and see if it works...

I have a Parameter that uses a ClientID as the selected value and I tried to have a textbox display the User Parameter Choice but it only diplayed the ID and I want the corresponding text (Client Name Value). But I can not find the correct expression.

I will post a follow-up to this and mark you as answered or not...

Thanks!

goodguy1974

Not working...I can not select a Dataset for the textbox

Any other ideas

Andy Potter

=Parameters!ClientID.Label

goodguy1974

Got the following error:

The Value expression used in textbox ¡®Client¡¯ returned a data type that is not valid.

Andy Potter

Is it a multi-value parameter

goodguy1974

yes

Andy Potter

Try this: =Join(Parameters!ClientID.Label, ", ")

goodguy1974

Great!

That was the ticket!

Thank You!