Share via

SSRS - Report Model - convert XML to SQL?

Edward Turner 1 Reputation point
2020-08-27T08:12:12.637+00:00

Hi.

I have a series of SSRS reports written against a report model. In report builder the dataset shows the XML which has been generated. Question is, can i convert the XML to SQL? Reason for asking is that I want to delete my report model and just report against the database directly via SQL.

Thanks in advance.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,850 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,581 Reputation points
    2020-08-28T05:30:52.51+00:00

    Hi

    In short, you want to convert XML to SQL.

    I did some research, here is some links for your reference.

    openxml-transact-sql
    convert-xml-file-to-table-in-sql-2005.html

    Here are two online webpage to convert XML to SQL.

    xml-to-sql-converter.php
    convert-xml-to-sql-queries

    Hope it can be useful to you.

    If you have any question, please feel free to let me know.

    If your problem has been solved, please mark "accepted answer" on my reply, thank you for your understanding.

    Regards,

    Zoe