I have excel File with multi sheets and i need to convert it to the RDL just the style without Data-Query
Hi @AmmarMahmoud-1083 ,
In Reporting Services, it’s not supported to change .XML（or .xlsx） file to .rdl file to generate a report. Since the XML format of report doesn't contain data source and dataset information, it contains field values used by tablix items. In your scenario, you can use the XML file as data source to create a report manually. Please refer to links below:
XML Connection Type (SSRS).
SQL Server Reporting Services XML Data Source and DataSet.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Joyzhao-MSFT
first of all thank you for your explanation
My goal is to convert only the sheet style which is in the excel will be the same in the rdl file.
I think a possible way is to use an Excel file as a data source in SSRS and then create a report in VS. see more: https://www.xtivia.com/blog/sql-server-how-to-setup-a-data-source-in-ssrs-to-ms-access-ms-excel-and-csv-files/
It's not possible to convert any Office or XML file to a RDL report and I am not aware of any third-party tool that could do it.
7 people are following this question.
