web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) SSRS Return Data from ...

Microsoft Dynamics CRM (Archived)

SSRS Return Data from One Dataset where it does not exist in another

(0) Share

Report

Report

Posted on by Pallavi Manocha

420

Hi everyone,

This maybe a basic query but I am having hard time to figure this out being a new bee to SSRS! can any one help me with possible way to do this ?

I am using CRM online (d365) hence using fetch xml based reporting. I want to fetch all Owners (Owner Lookup on Quotation )who have not created a Quotation ever for a particular product type(master)(look up on Quotation)

Say total users in system -->30

Using fetch I was able to get the User who say ever Quoted to Product type say"A"--> say got 10 users,Now i want to negate this and get details of the other 20 users.

Fetch Xml doesn't support subqueries or not in. Can any one guide how to achieve the same ?

Best,

Pallavi

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Preeti Sharma 2,678 on at

Like (0)

Report

RE: SSRS Return Data from One Dataset where it does not exist in another

Hi,

Instead of using not in you can use in operator to match all other conditions.

Following link may help you :

www.cobalt.net/.../building-not-in-queries-using-dynamics-crm-advanced-find

Hope this helps:)

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

Community Member 2

#1

#3

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans