Hi
I am searching for a proper way how to get a report from dataverse data to excel, word or pdf with some headers
I can't use word templates because word template will not allow me to make any filtering on data - it will only export something that is associated between tables and i need to filter some data before exporting.
I almost can use excel templates but excel template says select view. And in the view i can add columns only from direct related columns and i can not reach some columns that are related with indirect relations.
And also if i would like to use excel template in dataverse i need to filter all records by something that i want to export( in my case i need to filter all transactions by project name and status by finished) and then only use excel template. I am searching something more robust - users selects hits a button or something and get's desired data.
I had an idea to use custom page canvas app in dataverse and use Print() functionality but it is still not fully supported. I can't call parent.printing and this idea ended up here
I also can't use report wizard as i have same problem that i can't reach some indirect relation columns and can't add headers from indirect related columns?
I know there is a possibility to use SSRS with Fetch xml but this sounds too complicated
Is there some other suggestions maybe power query or some other methods?
