Share
ReportHello,
For reporting we would like to include the most recent note made on an account. Is there a way to get the min/max on a date field?
Thanks,
Beth
*This post is locked for comments
You’re offline. This is a read only version of the page.
250
Hello,
For reporting we would like to include the most recent note made on an account. Is there a way to get the min/max on a date field?
Thanks,
Beth
*This post is locked for comments
OK. I guess I'll have to learn FetchXML and SSRS.
Hi JonesEA_2018,
You could create a FetchXML report in SQL Server Reporting Services (SSRS), and then retrieve the newest note record with your query. The FetchXML query will look similar to this:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" count="1"> <entity name="note"> <attribute name="createdon" /> <order attribute="createdon" descending="false" /> </entity> </fetch>
Thanks for the response, Adrian.
We have a lot of notes getting added to accounts. For a weekly report we would just want to pick up the most recently created noted (the one with the maximum date).
The current options return too much data.
Hi JonesEA_2018,
It is possible to include the most recent note made on an account in a report, but I am unsure what you mean by the min/max on a date field.
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
All responses (
Answers (