Hi,
I am having a bit of an issue with my form. I have built a dashboard for gathering stats from a SQL database. I have created a multiple selection list box and repeating table linked to SQL database. My issue is as follows:
The repeating table displays incident data from the SQL database. So will show multiple lines of data in repeating table from username, to incident number and other info that is stored in the SQL database.
The Multiple Selection List Box displays the "Username" table from the SQL Database. This is so I can select a user or multiple users to display their data in the repeating table.
I am then applying a "Formatting Rule" on the repeating table to filter data:
"SearchPicker" (which is the Multiple Selection List Box and gets Usernames only from SQL database) is not equal to "Username" (Repeating table SQL data) hide this control.
I can get it so that if I select just one Username from the selection box it will display data, but if I select multiple users the data doesn't display and just goes blank.
Any ideas on this will be much appreciated :)
Thanks,
Stu