Page 1 of 1

Report based on a file selected by user

Posted: Wed Jun 18, 2014 2:47 pm
by 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
Sans titre.png (6.21 KiB) Viewed 1251 times
Thanks for your help!

Re: Report based on a file selected by user

Posted: Fri Jun 20, 2014 11:15 am
by Alex K.
Hello,

Please check the sample report in the attachment.

Thank you.

Re: Report based on a file selected by user

Posted: Mon Jun 23, 2014 10:16 am
by 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.

Re: Report based on a file selected by user

Posted: Mon Jun 23, 2014 11:31 am
by HighAley
Hello.

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

Thank you.