web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Service Calendar Report Creation

(0) ShareShare
ReportReport
Posted on by 105

Every week we have someone who goes into the Service module, type Facility/Equipment, view All Facilities/Equipment.

Advanced Find, uses a saved Service Activities view and then exports to Excel.

Basically he is getting a list of the facilities/equipment that have a scheduled start either this week or next week.

I want to create an excel report for him, however when using the Report Wizard I am unsure as to the record types to include in the report.

I've selected the Primary record type as Facilities/Equipment but am unsure as to what to select for Related record type.

And then on the Lay Out Fields screen, which Record type/Column I should choose that will give me the start date.

*This post is locked for comments

I have the same question (0)
  • TheMarkChristie Profile Picture
    10,328 Moderator on at

    Hi Rusty

    I think if you are looking to export to excel using an Advanced find, Saved View & Export is the fastest method, Creating him a Custom View with Filters on date would be the best bet

    Thanks Mark

  • Rusty_Gates Profile Picture
    105 on at

    Thanks, but he is basically running a report manually every week.

    Instead of him doing this I'd rater configure a report to run automatically.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans