You’re offline. This is a read only version of the page.
I have been working for a couple weeks on creating a new Custom Invoice Sub-Report for our business based on the Default Invoice Sub-Report in Dynamics 365. I believe I have followed the correct steps in downloading the default RDL file, setting up the RDL Helper (Dynamics Authoring Tool) for SQL server tools, and building the file in Server tools. Unfortunately, When trying to upload the existing file as a new report, I am getting an error stating that it is Invalid Fetch XML. Below is an image of the error:
I have even downloaded the Error logs to see if I could find out the issue from them, but it still seems way over my head. Here is the Error Log after attempting the upload:
I should note that I am trying to upload the build file that SQL server tools outputs into the Project bin/Debug folder, as i heard that this could remedy some issues. Still, i cannot seem to get past this error.
The only edit I am trying to make from the default Invoice Sub-Report is to the Product column in the details section. As default, it seems to be just showing the product Name or product description, if the name does not exist. I am trying to customize it so that both the name and description fill this box (Concatenated w/ new line separator). Below is the edited expression I am trying to use, as well as the fields I am replacing them in.
I noticed that there seems to be 6 different product columns, all with the same expression. I wasn't sure if this was normal, but decided to just change the expression for all of them since they were all the same before. I have also tried just using the concatenation line in the image above as the full expression (i.e. the expression was: Fields!productidname.Value & "\n" & Fields!productdescription.Value).
I seem to be at a dead end now. I have tried a bunch of different things, specifically in changing that expression, as i thought it could possibly be due to incorrect code, since this is my first time working with FetchXML. Is there something I am missing?
If anyone has any suggestions or ideas, any help would be appreciated! Thanks!
Share
Report
All responses (
Answers (