Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2014-12-04 : 16:12:32
|
| We recently installed a new SQL 2012 server, and I've got SSRS running on it.I'm using SSDT in VS 2012, and I know that it creates 2012 SSIS and SSAS packages, however it apears to be cerating 2008 SSRS reports.Also, when I go to setup a Report project and set the TargetServerVerion, I use "Detect Version..." and it comes back with "SQL Server 2008 R2 or later". I'm not sure if it should be saying SQL 2012 there or not. I'm trying to set the PageName property to be able to explicitly name tabs in Excel, and that is a new propery in 2012.In the designer I have the PageName property, but when I preview the report I get a Warning saying: "Warning 1 The PageName property specified on the data region, rectangle, or group 'GROUPNAME' was removed from the report. SQL Server 2008 Reporting Services does not support the PageName property."What's going on her, and how do I get this to be 2012?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-04 : 16:18:15
|
| What's the compatibility level of the database? |
 |
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2014-12-04 : 16:40:52
|
| I assume you mean the ReportServer database. It is 2012. So is the database teh report is running against for that matter.When I create a new report and look in the code it says:<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-04 : 18:05:29
|
quote:
Originally posted by malachi151
I assume you mean the ReportServer database.
No, I meant compatability level of the database (90, 100, 110, etc) |
|
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2014-12-05 : 11:26:43
|
| Yeah, that's what I meant. Both the ReportServer database and the database the report is pulling data from are both Compatability level 110.--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-05 : 12:25:40
|
| Please check the SSRS version. Instructions are in the link I posted.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2014-12-05 : 18:06:53
|
| Ah. Well the machine that the service is running on ais a fresh VM that has never had anything else installed on it. It is just a fresh Windows 2008 Server with SQl Server 2012 installed on it. It's never had SQL 2008 on it, so I would think the registry must be clean. Yes, the service running on the machien is definately SQL 2012, I've pulled up the UI on the machine and also we are running web UI for it, which is clearly 2012.From http://ServerName/ReportServer"Microsoft SQL Server Reporting Services Version 11.0.5058.0 "--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
|
|
|
|
|
|
Reports are 2008 but should be 2012