1. Home
  2. Forum
  3. Report Platform
  4. Excel file as parameter
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Excel file as parameter

Hi.

I'd like to build a report where the user can supply a path to an Excel file which contains a column with the id's of a product to be displayed. How can I do that?

Thanks.

1 Reply
YD Yuvaraj Devarajan Syncfusion Team May 28, 2018 12:01 PM UTC

Hi Paulo, 

Thanks for contacting Syncfusion support. 

Based on our understanding you need to dynamically get excel file path from user and use the excel file to filter data’s to be displayed on the report, it can be achieved with below procedure. 

  1. Create ReportParameter to get input from the user and use the parameter as connection string.
  2. Create extension datasource with ODBC type, to get data from given excel file path.  Add dataset to fetch column details from the database based on the data column retrieved from the excel file.
  3. The data set result can be used to render the report.

Can you please confirm the above one match with your requirement, so that we can provide further details on this? If we have misunderstood your requirement, then share detailed information about your scenario to provide solution at the earliest. 

Regards, 
Yuvaraj D. 


Loader.
Up arrow icon