found a 3rd party ODBC connection so I can connect Crystal reports to Dynamics 365. Since new the 365 tables are small so I did a quick report of 1 table to view the all data. Worked once but then the key id field was blank. contacted support and both blame the other. However the ODBC company suggest try their connection in Power BI. Surprised all data appears.
My objective was simple report with a sales order header and below the sales order lines. ran report and returned orders with no lines - how I discovered ID key relating to lines to orders is now blank. last. A disappointing response from SAP Microsoft Business Dynamics 365 is not supported Any suggestions?
My objective was simple report with a sales order header and below the sales order lines. ran report and returned orders with no lines - how I discovered ID key relating to lines to orders is now blank. last. A disappointing response from SAP Microsoft Business Dynamics 365 is not supported Any suggestions?