Passing Parameters to Dynamics CRM from Visual Studio/Fetch XML

(0) Share

Report

Posted on by Community Member

I would like to pass a parameter to my report specifically the invoiceid of the selected invoice, so that the report can be generated. The problem I am running into is that the report stops when I click "selected invoice" and run the report I get an error Saying "Reporting Error: The expected parameter has not been supplied for the report."

The parameter I am trying to pass is "invoiceid" When I run the report in Visual Studio it works fine, but when I put it in CRM I get the error shown below.

I have 3 different datasets created to do this.

Dataset 1

Dataset 2

Dataset 3

Error Message

Does anyone know a fix to this? Or how I can set a parameter?

Thanks,
ramsaytk

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

MDoddio73 1,910 on at

Like (0)

Report

Curious if you found the answer. I'm in a similar boat myself.

Was this reply helpful? Yes No
Suggested answer

Bas van de Sande 4,383 on at

Like (0)

Report

Hi ramsaytk,

you cannot use variables in fetch xml

What you should do is the following:

You load in your code the fetchxml from a resource in a XElement

in the XElement, you replace the variable in the node with the actual value (see code below)

//Set parameters

// - @BeginDate

// - @VirtualEndDate

standardEntityElement.XPathSelectElements("//condition[@value='@StartDate']").ForEach(element => element.SetAttributeValue("value", beginDate.ToString("o")));

standardEntityElement.XPathSelectElements("//condition[@value='@VirtualEndDate']").ForEach(element => element.SetAttributeValue("value", endDate.ToString("o")));

then you return the data as an XDocument

From there on you can use the xml to get your data

I hope this helps you a bit further

Bas

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

1)create paremeter, it should be start with CRM_Filtered

Name CRM_Filteredinvoicedetail

Prompt CRM_Filteredinvoicedetail

Visibility : Hidden

Defaul Values:Specify values :Value

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="invoicedetail"><all-attributes/></entity></fetch>

2)create dataset

parameters CRM_Filteredinvoicedetail = [@CRM_Filteredinvoicedetail]

<fetch distinct="true" no-lock="true" mapping="logical">

<entity name="invoice" enableprefiltering="1" prefilterparametername="CRM_Filteredinvoicedetail">

<attribute name="customerid"/>

<attribute name="ownerid"/>

...

<attribute name="duedate"/>

</entity></fetch>

it will get all the filtered invoice detail of invoice

Please mark the answer as verified if it was helpful.

Was this reply helpful? Yes No
suresh maurya 630 on at

Like (0)

Report

For testing of FetchXML, you can test here online http://msxrmtools.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for sending a fetching tools

Was this reply helpful? Yes No
Suggested answer

Pranesh M Juwale 1,196 on at

Like (0)

Report

blogs.msdn.microsoft.com/.../dynamics-crm-custom-fetchxml-reporting-with-multiple-datasets-using-pre-filtering

Was this reply helpful? Yes No