There you go, you got three options. Now all you got to do is weigh in which one and how you want to use it. If you are going with a dashboard, all 3 are viable options. However, I would go with the business rule approach - this one gives you more control. You can decide which columns you want to show and return only those in the DataAdapter.
Second and most preferred way will be to use the method query to pull it in an adapter and use it. However, you will now pull all the details (wanted and unwanted) and then suppress them on the dashboard end. This does have a performance impact (I've tested this by bringing more columns than I need and suppressing them on a grid view). That is the best option if you are ok with the performance impact (it probably won't be that big of a deal depending on your requirement). If not, go with the rule.
Now, even though I did talk about the table, I would love to erase that option. Can it be done? Absolutely, should it be done that way? No way!!! 🤣🤣
