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!