Management reporter linked to Excel

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello community,

I have two questions for you:

- Can i generate a report linked to many Excel files not just one in MR?

- Can i generate a report linked to Excel in MR but with choosing for exemple a half period in the Excel file, for exemple taking data just from 01/01/2018 to 15/01/2018 even if the Excel file is about the whole month?

Many thanks,

Imane.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Management reporter linked to Excel

Yes Ludwig i understand, but in this case how can i combine 4000 and 2300 in April, and 4500 in March?

Thank you,
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Management reporter linked to Excel

Hello Imane,

For Q1:

By using the so called separate link approach you should be able to link multiple excel documents to the MR

Here is an example that shows how such a link can be established: dynamicsaxfico.files.wordpress.com/.../en_19-160.png

For Q2:

The excel data are not linked to a period or a posting date. You can therefore basically import whatever you like as long as this makes sense for your specific report.

Best regards,

Ludwig