How to write expression in ssrs reports in Visual Studio to count total no of emails with direction "inbound"
How to write expression in ssrs reports in Visual Studio to count total no of emails with direction "inbound"
Ok. Now it is more or less clear. In this case you will have to combine sum and if. Something like here - stackoverflow.com/.../ssrs-conditional-summing
In your case, you will have to use directioncode in condition, 1 and 0 as results of if.
Good luck.
Hi Andrew
Thanks for your response
i am looking for total count emails in email activity with direction inbound
e.g : =Count(Fields!subject.Value,Fields!directioncode.Value = "inbound"), here subject is required field, i am using it for total count of emails.
Hello,
Everything depends on how you query the data, do you plan to use grouping e.t.c. Can you please give more explanation of your scenario?
André Arnaud de Cal...
292,494
Super User 2025 Season 1
Martin Dráb
231,309
Most Valuable Professional
nmaenpaa
101,156