
Announcements
Hello All,
I am so seriously frustrated as I have been developing the application for some time now and am now at a fork in the road where I either call it quits and move on to a different platform or somehow get this to work.
Can someone (anyone!) tell me how to create an equivalent of a Microsoft Access crosstab query in a Model Driven App view?
I have your standard normalized database tables - Products, Accounts, Date and even created one that is called Time Periods which is just YYYY-QQ.
What I am trying to accomplish?
I need to create a view that shows products on the left column with 'YYYY-QQ' on the column headers, with sales qty as the details.
What I have tried:
I was able to use XRMTools (SQL to XML) and create the view in XML, but received a message that read something along the lines 'further processing is needed...' . The result set was correct, but I didn't know what to do next. Can I upload the XML view, if so how? (and even if I did would it work?)
Why the frustration?:
Microsoft Access has this functionality so I am hoping it is maybe just me and that the functionality is there (albeit less than intuitive than I would have thought).
If anyone with knowledge on how this can be accomplished and or an alternative,please let me know.
Thanks!
As a person who used to build MS Access apps I know your pain. Using Dataverse as it currently stands by itself doesn't have that functionality. There are 2 different ways I have gotten around this.
1 - Using Power BI. It has a very good Crosstab feature. You can add your Power BI report as a Dashboard in your Model Driven App.
2. Create a Custom Page and using ComboBoxes, Collections and Galleries you can build functionality that can provide a list of what you need.
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist