7,316
Hi,
I need to add a filter to my fetchxml query in a ssrs report.
My report needs to filter based on year like 2020, 2019 etc.
I did put a filter with years in it but in the fetchxml query I have a date/time field to which I am trying to tie this selected year.
In sql, I have done something like this:
year(new_datetime)=@year
How do I achieve this in fetchxml? Can somebody please help?
Thanks.
Hi meenoo,
It’s hard to directly intercept year part of the datetime field in fetchxml.
You can use js code to copy year of the datetime field to the new created field, then use the new created field to compare with year parameter in fetchxml.
1.Js code.
Share
Report
All responses (
Answers (
function getYear(executionContext) {
var formContext = executionContext.getFormContext();
var dateFieldValue = formContext.getAttribute("new_testbirth").getValue();
var year = dateFieldValue.getFullYear() "";
formContext.getAttribute("new_year").setValue(year);
}
2.Add the js web recsource to the datetime field onChange event.
3.Test.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156