I have Customer and that Customer Can Contain Many Projects, But in the Filter It should take the latest created project(which means based on inception date ) among the selected Projects. How to do this in SSRS SQL query? and also The Date the report was generated should be registered on the document when generated, this allows us to version control.?
Hi partner,
What's the version of CRM are you using, online or on-premise?
If you are using online, so the SSRS query should be based on fetch-xml, you need to add such column.
<order attribute="inception date" descending="true"/>
If you are using on-premsei, so the SSUR query should be SQL statement, so you need to add an "order by inception date desc" to get the latest created project.
If my understanding is not correct, please share more details about your requirement so that we could help you better.
Regards,
Leo
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
