Basically, we implemented another field one level higher than job number, and this field would be assigned to multiple job numbers to keep them organized together. Now for reporting, I need to be able to select one “schedule number” and return all of the jobs that it is assigned to. I still want to pass the report jobs just like it is out of the box I just need to know how to stick it on the control in report menu.
Not at my computer, but I would look to see what that field is bound to, then check how they’re storing the data using Dev Tools.
If I had to guess, I would say it’s probably tilde delimited.
Put tildes between the values where? I’m not really following how Epicor has their data laid out here. Anywhere I see a delimiter (spelled as delimeter) field it’s blank.
They’re just doing a search that already returns a tilde delimited list.
You will have to build it yourself using events, row-updates, dataview-conditions, etc.
Plenty of posts on how to use all of those controls, so I’m not going to lay that out here.