Is there a way to stop a dashboard from auto returning results upon initial load?
I want users to enter a filter/tracker value first before anything loads in the grid. I tried created an Override on Form_OnLoad, but the grid still populates automatically.
Another option is to not use the provider model on the grid and, instead, bind it to a dataview. You could then have a button that executes the erp-baq event to populate it.
In the provider model of your grid you would have put a ? Or ?? In front of the Part Number filter field.
I can never remember which is which of by heart but if you put ? Change it to ?? And if you put ?? Change it to ?. As one of them doesn’t make the call if the field is blank / null.
I was about to ask the multitude of other users on here that can’t get their grids to populate to chime in and let us know how they were pulling it off… but… sounded a little TOO sarcastic
The downside of this is if you leave the panel expanded and one filter criteria isn’t enough to make your dataset small enough, you’re going to get a massive return the moment you tab out of the first field unless you single question mark ALL of the criteria which can be annoying if not by design.
I like to control how the grid expands for things like that.