Report based on a file selected by user

[Jennypi]

Hello,

I would like to know if it would be possible to build a report with a form which would ask the user to pick a file. This file, providing that the format is OK (extension xlsx in my case and appropriate columns), would be used as the datasource.

Today, the excel file has to be in one specific directory and should not move, otherwise the report template cannot find it anymore. Sometimes it's not convenient for me, because I don't always have access to the users' directory, so I cannot test the report and check if the data file is OK.

I would like something like this:

Sans titre.png (6.21 KiB) Viewed 1253 times

Thanks for your help!

[Alex K.]

Hello,

Please check the sample report in the attachment.

Thank you.

[Jennypi]

Thanks a lot, I will try that!

Just one thing, I think that the datasource property "Connect on start" should be set to false, otherwise I'm getting an error "impossible to create a file", before getting the form.

[HighAley]

Hello.

Yes, it's better to set the Connect On Start property of the Data Source to false.

Thank you.