joaobatista.casaecasa Posted October 9, 2019 Share Posted October 9, 2019 I have 6 stores and at least 5 sellers each. My database does not have an attribute to indicate the seller`s store, so when I create an report with the revenues, I have to select all the sellers of the store to get the correct value. I want to create a list for each store with the seller's id, and then a list with the lists that contains the seller's id, with the objective of making the report's creation easier and intuitive to the user. How can I do this? I have already created the lists with the seller's id for the stores, but I don't know how to create the list with the created lists. Link to comment Share on other sites More sharing options...
danoldenkampgmail.com Posted October 9, 2019 Share Posted October 9, 2019 Let me see if I understand.Your sales data is like:StoreID SellerID order info fieldsYou want to display a filter for a StoreName or SellerName for the user to filter the data?Are you asking how to create a "list"StoreID StoreName001 StoreA002 StoreBSo you can feed the ID to the query?Sorry if I am not understanding.You would just create a parameter with an input type of List of Values.Under local resources define the list. Name is visible and Value can be fed back to the query by dragging over the parameter. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now