How do I convert a file created in microsoft reporting services sql server 2005 which I saved as a rld file to a sql query? [email protected]

I didn't think there was SQL in a RDL. I thought you setup a data source in your project, and the RDL knew what datasource/dataset to use. At least that's how we're doing it.

There are 10 types of people in the world. Those that understand binary, and those that don't.

I am very new at this. I made a report in the business development studio and saved it as a rdl file. I am just assumming that the same report could be written in sql. The xml file looks like it could contain the sql commands. Since no one responded quickly I just figured it was a silly question. Thanks for responding. I am just gonna learn sql. Travis

Well, I'm pretty new to this whole Reporting Services & VB.Net/Visual Studio thing so my answers aren't as authoritative as I'd like... But they're working in my situation... I think the RDL can contain SQL, but none of the RDLs I've edited have contained any. They all point to stored procedures, which are queries, and the RDL just tells the machine how to format the output.

There are 10 types of people in the world. Those that understand binary, and those that don't.