Geeks With Blogs
Ben Adler's Development Posting solutions as I find them

 

I was trying to open a .rdl file but could not due to an error:

Requested value 'Integrated' was not found.

I could open the .rdl in Report Builder 3.0, but I couldn’t upload it to the reporting server because it was the wrong schema. I also couldn’t open the .rdl that was saved in 3.0 in 2.0 for the same reason.

I didn’t want to go through the time of installing Business Intelligence Studio. I discovered I didn’t have to:

1.       Open .rdl in notepad to edit the XML

2.       Replace <rd:SecurityType>Integrated</rd:SecurityType>

with <rd:SecurityType>Windows</rd:SecurityType>

3.       Save and open the .rdl in Report Builder 2.0!

 

 

 

 

 

Posted on Thursday, July 12, 2012 3:27 PM SSRS | Back to top


Comments on this post: Report Builder 2.0 - Requested value 'Integrated' was not found.

# re: Report Builder 2.0 - Requested value 'Integrated' was not found.
Requesting Gravatar...
This helped me so much!!! Thank you!!!
Left by Bob on Jun 11, 2015 2:22 PM

Your comment:
 (will show your gravatar)


Copyright © BenAdler | Powered by: GeeksWithBlogs.net