Hi
Is it possible to generate some report from data and print it? I mean report is not visuals but pure data.
Lets say filter some data by date then by some status if that data so it generate report and print it?
Solved! Go to Solution.
Hi @jja ,
There are a number of options here in model apps.
1. Excel Templates - You can utilize Excel Templates in Model Apps, available in List Views to extract records from a view. This will allow you to format in multiple ways, create additional tabs for pivot tables etc. and print. https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
2. Word Templates - Another template that is "per record" with related records being able to be utilized as well. You could use this to look at an Account record for example and create a report for that account that prints account fields, related opportunity data, related contacts, etc. https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
3. Report Wizard - You can add the standard report wizard where you can build simple reports, with filter criteria and save them to run at any time. This will also allow you to upload SSRS based reports (although they need to be based on FetchXML) as well. https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-reporting-to-app
Above are the main options, of course you can also connect with Power BI to generate reports or even utilize a great 3rd party tool called DocumentsCorePack (https://www.mscrm-addons.com/Products/DocumentsCorePack-for-Microsoft-Dynamics-365/LandingPage)
Hi @jja ,
There are a number of options here in model apps.
1. Excel Templates - You can utilize Excel Templates in Model Apps, available in List Views to extract records from a view. This will allow you to format in multiple ways, create additional tabs for pivot tables etc. and print. https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
2. Word Templates - Another template that is "per record" with related records being able to be utilized as well. You could use this to look at an Account record for example and create a report for that account that prints account fields, related opportunity data, related contacts, etc. https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
3. Report Wizard - You can add the standard report wizard where you can build simple reports, with filter criteria and save them to run at any time. This will also allow you to upload SSRS based reports (although they need to be based on FetchXML) as well. https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-reporting-to-app
Above are the main options, of course you can also connect with Power BI to generate reports or even utilize a great 3rd party tool called DocumentsCorePack (https://www.mscrm-addons.com/Products/DocumentsCorePack-for-Microsoft-Dynamics-365/LandingPage)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
16 | |
10 | |
6 | |
4 | |
3 |
User | Count |
---|---|
29 | |
17 | |
13 | |
9 | |
8 |