Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

SSRS reports

(0) ShareShare
ReportReport
Posted on by 55

Count of created cases when statecode is active and count of resolved cases when statecode is resolved.for the last 4weeks.ecah week starting date and ending date column need to dispaly.this scenario is for a perticular team.if the team name is abc then I need to display all the users under that team who have created the cases and closed the cases 

Hi to do this with SQL query ssrs reports?

  • lathareddy Profile Picture
    lathareddy 55 on at
    RE: SSRS reports

    If week start date and week end date between these 2 we have dates right all those dates records createda nd closed count I need based on team.

  • Eiken Profile Picture
    Eiken on at
    RE: SSRS reports

    Hi,

    I don't understand your thoughts very clearly.

    Do you want to calculate the quantity in four time periods?

    And four numbers are included in one table in report.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans