CSPro Users Forum

I want to display the row occurrence labels dynamically.
I have 294 items for which data is to be collected. These 294 items are distributed among 23 tables or departments.
Each 7 digit item code has an starting 2 digits for 2 digit table/department code starting from 01 to 23.
I want to display the items and their occurrence labels only for selected tables or departments.
For example if I chose Table "01" in ID dropdown then items having item code with prefix 01 will display.
How to implement the above method.
The table having item codes and their labels is attached for the reference.
Please guide me...

Hi Manish,

You'll basically want to use the valueset object.

You'll need 2 dictionary variables; 1 for the parent/top level codes (1-23), then a second for the subcodes. Based on the person's selection of the first, you'll restrict what they see in the 2nd variable by using setvalueset. See this post for links to other questions about this. In case you aren't aware, you can just copy and paste your Excel tabsheet values into the 2nd variable's valueset. No need to retype.

https://www.csprousers.org/forum/viewto ... 06&p=14082


Sherrell

Thanks a lot..

Manish, I just changed my response to you above (old habits die hard!). I meant to say you'll want to use the valueset OBJECT, not the setvalueset FUNCTION. The latter has been deprecated. Sorry for the confusion.