Need to pull Total Billable time in a Case Report crm 2011 RRS feed

  • Question

  • assume you would like to create an advanced find view of Case and display the total time invested. As you rightly found, the total time invested is being stored in the Case resolution and not Case. And there is a 1:N relation between case and case resolution. You can only include fields of N:1 related records in views. The reason for excluding 1:N being... since there could be many resolutions associated to the case, which is the one that should be picked?

    You can however design a custom report and write a query to pick the total time from related case resolution and dsiplay it in report.

    How do you prep the report - do you use case as primary and case resolutions as related or activities. If it is case... what are the options to select, even after reading a number of blogs I am not able to pick out the required elements.

    Any advice would be appreciated

    Thursday, April 12, 2018 12:51 PM