SSRS 2008R2 Schemas: Visual Studio 2008 and "2008" and "2010"
I have SQL Server 2008 R2 SP2 (including Business Intelligence Development Studio). I have the following two questions:
- I open the Business Intelligence development studio (resulting in Visual Studio 2008). I am creating a new report server project (specifying "2008R2" as the TargetServerVersion). In a project, I create a report with some, say, table control. Then I scan created RDL file, I see the following: http://schemas.microsoft.com/sqlserver/reporting/ 2008 /01 / ReportDefinition
Question: can I somehow create Studio to create "2010" in the RDL file instead of "2008"? Something like the following:
xmlns: rd = "http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns : cl = "http://schemas.microsoft.com/sqlserver/reporting/ 2010 /01 / componentdefinition" xmlns = " http://schemas.microsoft.com/sqlserver/reporting/ 2010 /01 / ReportDefinition
- The second question is as follows. I have an RDL file provided by another developer who has implemented it in Report Builder 3.0 SQL Server 2008 R2. The RDL file uses the "2010" schema:
xmlns: rd = "http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns : cl = "http://schemas.microsoft.com/sqlserver/reporting/ 2010 /01 / componentdefinition" xmlns = " http://schemas.microsoft.com/sqlserver/reporting/ 2010 /01 / ReportDefinition
I added the file to my project (the one I described above in (1)). Everything seems to be working fine - I mean my Visual Studio 2008 doesn't cause any problems with the RDL file (it uses "2010", remember).
Can I be sure that there will be no problems with this RDL included in my project. I mean - won't I run into a problem like this: when I try to make some changes to the report (move the control, add the control, change the control - whatever) - the operation failed because of the schema "2010" in RDL file> Or any other problem?
source to share
namespaces are specified when the report is first generated. So the simplest answer is to edit the template report file which can be found in the directory below (for VS2013)
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
If you are using an earlier version of Visual Studio, the root folder will be different. Just select the desired directory for your version
NOTE. You can also add your own templates to this folder, which will appear in the add new item dialog. Great if you want to prepare headers, footers and default options ...
source to share