This projects needs toprovide a webservice that will take an XML that is provided over MS-MQ and sends that out as a reply to a webservice request to be used by Crystal Reports using all the fields seperate entities (proper WDSL)
We have data in Microsoft Dynamics NAV that needs to be used in Crystal Reports. For various reasons, this cannot be done using the ODBC connection.
We have a module that generates a XML table and sends it using MS-MQ. We also build a C# webservice that takes the requests, send a request to MAV and consumes the XML (using MS-MQ) then uses it as a reply to the webservice requests.
What does not work is Crystal Reports consumes the entire XML as a string without interpreting as a table. We need to make sure the WDSL or response identiefies the proper XSD. Preferable, this is not defined at code level but based on information supplied from NAV with the actual table.
This project is intended as a "learn" example and will be build upon for later revisions. So good program structure and documentation is important and "Why is this done this way" questions can be expected.
There is a reasonable background in programming available, just not with this combination of tools.