How to a create a CRM Marketing List from SSRS report data or how to get the count using Fetch XML?

(0) Share

Report

Posted on by Community Member

Hello Experts,

I have a requirement a creating a CRM Marketing list using a filter criteria of count(Accounts having only one Opportunity within some time period), is there a way to do this without having to create a Roll Up field or writing any tool. Also, is there a way to create a Marketing List from SSRS report data.

Any ideas would be appreciated!

TIA
Sunny

*This post is locked for comments

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: How to a create a CRM Marketing List from SSRS report data or how to get the count using Fetch XML?

Hello Adrian,

Thank you for your response. My problem here is that I need to count the number of Opportunities under an Account which we can not do using FetchXML, I have one SSRS report which can do the same and I want to read all those Accounts from the report and create a Marketing List.

Thanks
Suggested answer

Adrian Begovich 1,019 Super User 2025 Season 1 on at

Like (1)

Report

RE: How to a create a CRM Marketing List from SSRS report data or how to get the count using Fetch XML?

Hi Sunny Kadali,

You can create a marketing list programmatically using the FetchXML query from your SSRS report. An example of this can be found here.