'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a Dynamics 365 Sales Report from Opportunity Notes on Mac
Question details
The user wants to generate a report from opportunity timeline notes in Dynamics 365 Sales, but the reporting functionality is working on Windows and failing on a Mac.
- Product
- Dynamics 365 Sales
- Device & OS
- Mac
- Scenario
- Attempting to create and view a sales report based on notes added to an opportunity timeline.
- Observed behavior
- The report generates successfully on a Windows operating system but fails to work or display correctly on a Mac.
Ensure you have the appropriate user permissions in Dynamics 365 Sales to view opportunity records and export timeline activities.
Export Opportunity Notes to Excel or CSV
Bypass Mac-specific browser glitches by exporting the raw timeline data to an Excel or CSV file for manual filtering and report generation.
Dynamics 365 allows you to easily extract activity data. Once exported, you can use any spreadsheet software to format the notes exactly how you need them.
Sign in to Dynamics 365 Sales and navigate to the relevant opportunity record you want to report on.
Open the 'Timeline' or 'Activities' section of the opportunity to view all associated notes and tasks.
Click the 'Export' command available in the command bar or ellipsis menu, and select 'Export to Excel' or 'Export to CSV'.
Open the downloaded file in a spreadsheet application to filter the columns and format your final opportunity notes report.
Switch to a Supported Browser on Mac
Dynamics 365 web features can sometimes behave unpredictably on Safari, making it necessary to try alternative browsers.
Utilize Power BI for Advanced Reporting
Use Power BI to create cross-platform dashboards that pull data directly from Dynamics 365, eliminating Mac-specific browser reporting issues.
Easily Filter and Format Exported Dynamics 365 Reports with WPS Office
Once you have exported your opportunity notes from Dynamics 365 Sales to a CSV or Excel file, you can use WPS Spreadsheet on your Mac to clean, filter, and beautifully format the data into a professional sales report.
- 1. Install WPS Office: Download and install WPS Office for Mac, then launch the WPS Spreadsheet application.
- 2. Open Your Exported Data: Go to 'Menu' > 'Open' and select the CSV or Excel file you exported from the Dynamics 365 Timeline.
- 3. Filter the Notes: Highlight your data headers, navigate to the 'Data' tab, and click 'Filter' to easily search and isolate specific opportunity notes.
- 4. Format and Save: Adjust column widths, apply cell formatting for readability, and save your finalized sales report.
Frequently Asked Questions
Why does Dynamics 365 reporting work on Windows but fail on my Mac?
This discrepancy is typically due to browser compatibility issues. Apple's Safari browser sometimes struggles with certain scripts or extensions required by the Microsoft ecosystem. Switching to Microsoft Edge or Google Chrome on your Mac often resolves these platform-specific glitches.
Can I automate the export of opportunity notes to Excel?
Yes, you can use Microsoft Power Automate to create a flow that triggers whenever a new note is added to an opportunity in Dynamics 365. This flow can be configured to automatically append the new data to a dedicated Excel Online spreadsheet for real-time reporting.
How do I make CSV files exported from Dynamics 365 easier to read?
CSV files are raw text files and can look cluttered if opened in basic text editors. Always open them using a dedicated spreadsheet program like WPS Spreadsheet or Microsoft Excel. If the data appears crammed into a single column, use the 'Text to Columns' feature under the Data tab to separate it properly using commas as the delimiter.
