884
Hi All,
Filter by Amount From:-
These variables will filter the data of the related records. This allows a user to select a range "From" and "To" and both values can be null or mutually exclusive.
1.From:Can be NULL or can contact a dollar value. This variable is mutually exclusive and does not need a value in the “To”
2.To:A user can only enter a value here if they have entered a value in the “From” variable
Thanks
*This post is locked for comments
No. How to allow blank values for multitple parameters in ssrs parameter.
above Image So something like this(How to sql Query to fetchxml Queary.
Hi,
are you asking about an SSRS report or about a grid? If it's an SSRS report, are those two going to be the parameters of that report?
If you have a fetch query, why can't you pass those parameters to the query?
blogs.msdn.microsoft.com/.../fetch-xml-based-reports-bits-pieces
As for making them mutually exclusive.. not sure it's possible.
After the change events of the fields, or on the click of a button, call a javascript function to check for the values from your two text controls, and then filter the results.
In order to filter the results you will need to get the name of the grid, create a fetchXml string that contains the query that you need to set, and apply the setParameter function with the fetchXml string:
var grid = document.getElementById("accountcontractsgrid");
or
var grid = window.parent.document.getElementById("accountcontractsgrid"); // CRM 2015SP1+
var fetchXml = "YOUR_FETCH_XML_STATEMENT";
grid.control.SetParameter("fetchXml", fetchXml);
grid.control.Refresh();
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (