Multiple selection on dashboard

Kinetic ERP
1

Hello everyone,

I am creating a New Tracker View in my dashboard.
But I need a query where I have to select multiple buyers.
How should I set up multiple selection?
Thanks in advance!

image
image1098Ă—722 154 KB

1 Like
2

You can do this with a BAQ Report, but I am not sure how to do it in a Dashboard. Add a new filter to the BAQ Report (not the BAQ itself). Your output ends up being a report, but it might give you what you need.

1 Like
3

I would say this might be a candidate for customisation on the main controller and add in the multiple filters there…

Someone poke me in the eye if I have just gone for the over complicated approach.

1 Like
4

Thank you all for your comments.
I need this on the dashboard. Because I need “Copy to Excel”. When I create a BAQ Report and download it into Excel, the Excel format is not created into a form that can be directly pasted. This is because I want an Excel form that can be pasted into the manual Excel document that our company operates without any additional work.
If you create a BAQ Report, when downloading Excel, it is downloaded in the format below (unnecessary columns and rows), so you cannot paste it directly.

image
image1302Ă—153 16.4 KB

5

If you are using a dynamic BAQ report and modify the RDL to ensure all the columns are in the right order, no overlapping etc. Then it should turn into an excel file fairly simply. The key is getting the RDL correct.

6

Create a updatable BAQ and put that on the dashboard.
The buyer table has a field that could repurpose as a filter

image
image972Ă—276 56.9 KB

If you put a 1 in the conversion Emp ID

Then in your other query - filter the results for CnvEmpID = 1

If you want, you could also add a logic field into the buyer table if you wanted.