Hello
I am trying to combine two tables the SalesLine table with another CustTable and not sure what would be the best option to choose when creating this report.
I am trying to get sales line data and match it to the customer table.
Basically trying to create list of customers with sales from certain branches with data from both tables.
I have created a couple queries but cannot seem to get them to work correctly.
The select query opens and runs but no data is generated.
When i create the view it works fine but the view i am unable to push that onto a Menu Item. ( How can i get a view to generate on a menu item?, possible create method and run that way?)
Additionally i am trying to do some simple math and want to create a new field on this Query/Report that would take one field and subtract it from a certain amount. I can write a method to do that but how do i create that field on the report?
Any help would be greatly appreciated.
*This post is locked for comments
I have the same question (0)
