To create a button object in the sheet.

[#1]

Hello Everybody,

          I'm working on button sheet object. Need some help how to write expression to link with the selected data in a table.

For example : I've a field name called 'SubjectCode'. Many codes are given in the field. A1,A2,A3,A4,A5,B1,B2,B3,B4,B4,B5

I need to create a button object to display only'A1,A2,A3,B1,B2' from Subjest Code.

My analysis :

I've created a button name 'Code' -> Properties-> Bookmark-> Apply bookmark (Given the 'Subject Code' label name)

Then Selections-> Select in Field-> Feild name (Subject Code) & Search String-> if (Match([Subject Code],'A1',A2','A3','B1','B2'),' ')

But it seems to be not working.

Can anyone help me how to do this will be very helpful.

Regards,

Archana.

[Miguel_Angel_Baeyens · Accepted solution]

Hi Archana,

In the actions expressions, the way to select multiple values is this, manually adding all the values you want to select:

(A1|A2|A3)

So one way to get this done in the search string would be

='(' & Concat(Distinct Field, '|') & ')'

Hope that helps

[#3]

I've attached the sample .qvw here.

Please help me out of this issue.

[kumarnatarajan]

Hi,

fiend the attached file. you must give currect field name in select in field

[#5]

PFA document

Regards,

Amay

[#6]

Hi,

Thanks for your help.

But i do need only particular values in the feild. I tired giving

='('& concat(distinct [size code], 'A1|A2|A3|B1|B2')& ')'

But i get the values A2,A3,B1. The first and last values are not selected when i click to the button.