Link to home
Create AccountLog in
Avatar of Rod Nooner
Rod NoonerFlag for United States of America

asked on

Edit SSRS 2008 R2 Report Model

How do I open an existing report model from SSRS 2008 R2 in BIDS 2008 in order to edit the query. When I download the smdl file from SSRS and open it in BIDS I just get an XML document and not a usable design workspace.
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

a SSRS report is an XML file.
Yup. So, it is a .rdl basically. You can create a new project and right click on the project in BIDS, add an existing item, browse and select the .rdl file. Finally, create the rds as required and its all ready to be edited.
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rod Nooner

ASKER

Thaks ValentinoV :-)
Sometimes it is the simple things that cause the most frustration. I 'wrongly' assumed I could do a simple 'open' on the file but that is where I only got the XML version.