Forum Discussion
Create report from from two tables
Ice1341 Seems like there is no relationshipt built between the two tables.
And looking at the samlple data, Cust Code from Sales Budget should be joined with JF Code in Sales Invoice data which should resolve the issue.
Create a calendar Table and join dates from both table
Yes, build relationships of both the tables from Calendar table and in your chart you can just used the date fied from Calendar table.
Yes, I created a relationship based on the customer code, but I want to view data by month. If I use the date in the sales budget table - gross sales appear correctly by month, but sales orders repeats every month. How can I combine dates from each table to use in the report? See screenshot, Gross Sales Correct, but actual sales repeat every month when it should just appear for Jan Sales.
Create a calendar Table and join dates from both table
I can only create a relationship with sales budget dates, the sales order table is saying I can't create a direct active relationship...I have to deactivate the relationship between the sales budget and the date table.