Method Community

 

Report Designer - Show last activity instead of all activities

Last post 05-22-2014 8:14 AM by Method_Russell. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-21-2014 2:30 PM

    Report Designer - Show last activity instead of all activities

    In report designer, using the "CRM_CaseList_withActivities" report. I was wondering if there was a way to filter the activites so that it only shows the last activity instead of all the activities.

    Kurt

    Kurt Turner
  • 05-21-2014 3:48 PM In reply to

    Re: Report Designer - Show last activity instead of all activities

    Nevermind - I figured it out...

    Kurt Turner
  • 05-22-2014 8:14 AM In reply to

    Re: Report Designer - Show last activity instead of all activities

    Hi Kurt,

    Glad you figured it out. I'll reply to your post in case there are other users who want to accomplish this as well. Like many things in Method there are many ways to acheive this, here's what I did.

    To start, I strongly recommend making a copy of the CRM_CaseList_withActivities report, so you can revert to the original if needed. Then, you can create a Formatting Rule which will apply to the Headers GroupHeader2 and Detail. You can use the Variable: DataSource.CurrentRowIndex. This will be used to filter out all rows except the first. Your condition will look like:

    [DataSource.CurrentRowIndex]  != 0

    Note that 0 is used since indexing starts at 0. This condition will set the Visible property to No. After this, apply this rule to the headers mentioned above.

    The final step is to change the sorting so that the newest case is first. Click on the detail header, and modify it to sort RecordID Descending. You can delete one of the RecordIDs since it's not necessary:

    -Russell
Page 1 of 1 (3 items)