web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) SSRS Expression count ...

Microsoft Dynamics CRM (Archived)

SSRS Expression count on related dataset

(0) Share

Report

Report

Posted on by martingr

600

Hi

I have a report (grouped on owner) where I use the following expression to count activities on owners:

=Sum(IIF(Fields!scheduledendValue.Value >= Today, 1, 0))

In the report I also want to count closed opportunities. I have created a seperate dataset for this. The expression I use is the following:

=Count(Lookup(Fields!ownerid.Value,Fields!ownerid.Value,Fields!opportunityid.Value,"Oppty"))

But the numbers are all wrong. Is it even possible to combine this count on the report?

Thanks for help (started with ssrs today:)

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I believe what you need is LookupSet and not just Lookup - docs.microsoft.com/.../report-builder-functions-lookupset-function

Was this reply helpful? Yes No
Suggested answer

pavanmanideep 1,331 on at

Like (0)

Report

Hi Martin,

Please see the below link for the same requirement

https://www.magnetismsolutions.com/blog/nathaneccles/2012/11/04/crm_2011_ssrs_lookup_function_merge_aggregate_datasets

Hope this helps.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans