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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

pavanmanideep 1,329 on at

Like (0)

Report

RE: SSRS Expression count on related dataset

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.
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: SSRS Expression count on related dataset

Hello,

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans