Reporting Services :: SSRS Properties Greyed Out In SSMS On Windows 2008
Oct 17, 2008
Have installed SQL 2008 on Windows 2008 and have come across a strange issue.
When connecting to the Report Server cvia SSMS to enable "My Reports" (for example) the Report Server Properties are greyed out and we cannot alter them. This occurs when logged on both locally & remotely to the Win 2008 server.
Interestingly, we have another (XP Pro) box with SQL 2008 on it. If we connect to the Win 2008 SQL report server from the XP machine's SSMS, then we have full control and can access and change the report server properties on the Win 2008 server.
The relevant domain accounts are in the Admin group on the Win 2008 server and the XP Server so we are confused as to why we cannot edit the Win 2008 report server properties locally.
View 5 Replies
ADVERTISEMENT
Jun 20, 2013
I am modifying a report that sets this variable at the beginning of every dataset:
declare @current_minute int
set @current_minute = DATEPART(N, GETDATE()) % 3
My idea is to set this variable in the Report Properties instead. When I do set this variable it in a Text Box or a Dataset, I get errors such as:
The expression used for the calculated field '=Variables!report_var.Value' includes a variable reference. Variable values cannot be used in calculated field expressions.
The Variable(report_var) expression for the report ‘body’ contains an error: [BC30451] Name 'N' is not declared.
What other strategies can I use to set a variable globally, instead of at the beginning of each dataset?
View 3 Replies
View Related
Oct 2, 2006
I am looking to make the primary key auto increment by 1. I have found by looking around the internet that you need to do this in the Tables -> [Table Name] -> Columns -> [Column Name], Properties window, and I see the "Identity Increment" however all of the properties there are greyed out -- I can't access them. Any ideas on how to make this work?For some background: I'm running SQL Server 2005 with Visual Studio 2005. To create this database, I right-clicked on my project, and went to 'Add SQL Database', I filled in the columns all from within visual studio.
View 1 Replies
View Related
May 19, 2015
We have 1000s of SSRS reports hosted on the SQL 2008 R2. All reports are supposed to have all parameters "hidden". Random reports have been reported to expose the parameter when developers accidently deploy to test servers. Is there a way to identify the reports and the parameter property (Hidden, Visible, Internal) from the Report server Database?
I checked executionlog2 but can not find the parameter property.
View 7 Replies
View Related
Nov 24, 2015
I'm using a bullet chart in a SSRS report and I want to set the Maximum value in the Linear Scale properties to highest value of the following 4 fields. Is there any way to do this?? This will make all charts line up properly.
NC_LAST_YEAR
NC_LINKED
NC_CURRENT
NC_PLAN
View 5 Replies
View Related
Jul 23, 2010
We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2. It works nicely. Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production). After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable." I can't connect via http, or SSMS.
We have tried:
* Running SSRS config tool (several times)
* Running with/without the IIS Server Role
* Dropping & recreating the SSRS keys
* Recreating the ReportServer database, etc
* Checking all of the accounts, permissions, etc
* Running SQL Repair
* Going through the registry to fix any references to the machine's old name
* Uninstalling, reinstalling SSRS
* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.
None of this has worked. SSRS [R2] is still 503 on our test box.
the SSRS [NT] service seems to run, without error. The Event Viewer doesn't seem to be recording any errors. The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine. The other SQL Logs say something about not being able to contact the service. However, as I said, the [NT] service seems to be working fine.
View 4 Replies
View Related
Feb 4, 2008
Quick question; is SQL Reporting Services 2005 fully compatible with Windows Server 2008 / IIS 7 that RTM'd today?
View 1 Replies
View Related
May 11, 2015
I have a matrix in one of my SSRS report data is like below
Row as Branch
Column as Tasks (Progress, Completed , cancelled, In Complete)
Branch Progress Completed cancelled In Complete Total %(Complete/Total)
Aus 1 2 3 4 9 22.2%
NZ 1 2 3 5 11 18.88%
US 0 0 3 3 6 0.00%
How can do in the SSRS matrix %(Completed/Total) percentage calculation ?
View 4 Replies
View Related
Jun 10, 2009
Is there anyway in SSRS 2008 to sort the Legend on a chart? Right now I am unsure as to how it is currently sorting. I see a property to Reverse the order, but I don't see anything to alphabetize it.
View 8 Replies
View Related
Feb 13, 2012
I have 2 datasets, dataseta is a list of tickets and their relevant owner and databsetb is a list of owners and a days worked first against them.I have a table with a detail grouping on ticketid and a normal grouping on owner which works well... all straight forward to this point. In this table on the owner grouping level I also have a lookup to datasetb which pulls back the days worked per owner which works fine as well. But what I now need to do is total the days worked over all owners, which sounds simple but doesn't work. This is the expression on the days worked for each owner -
=lookup (Fields!owner. Value, Fields!owner.Value, Fields!Days_worked.Value,"datasetb")
If I add a sum around this then it uses the figure above but multiplies it by the amount of tickets in the detail grouping.
View 6 Replies
View Related
Dec 18, 2012
Below is my navigation URL link ..I want the drill through to open in new tab rather than new window..I believe i need to change the newwin.
="javascript:void(window.open('"+ Globals!ReportServerUrl + "?" + Globals!ReportFolder + "%2fReportName&rs:Command=Render" +"&YQM='+escape('"+Parameters!YQM.Value.ToString() +"') +'&Status='+escape('"+Parameters!Status.Value.ToString()
+"') + '', 'newwin', 'screenX=0,left=0,screenY=0,top=0,status=1,menubar=1,resizable=1,scrollbars=1,toolbar=1,location=1'))"
View 12 Replies
View Related
Apr 29, 2015
I have a RS 2008 R2 SP3 Service in SharePoint Integrated Mode.
Since 5 days my Subscriptions were not sent anymore. I did no changes to these machines. There were some data driven subscriptions in pending state. I delete these entries via SharePoint.
When I look at Report server Execution Logs, there is no error, that i can associate to subscriptions. New Subscription are created and deleted in the Log, but they will never been processed.
I have done a Reboot to the RS Box but, that was not the solution.
View 4 Replies
View Related
Apr 23, 2010
I've got an SSRS 2008 report with 4 nested groups on rows. Report requirements are that each new group at each level have a subtotal. I've gotten this to work just fine. After the users saw the report, they had a new request - if the SubTotal has only 1 row to Subtotal, do not display the Subtotal. If there are 2 or more rows, display the Subtotal line.I know I can go to the Grouping Properties, and on the Visibility properties select the "Show or hide based on the expression" - I am struggling with the experssion. How can I check to see if there are more than one row at this group level? The query is SQL with 2 sub selects, and 7 tables in various join clauses.
View 15 Replies
View Related
Jul 20, 2010
I need to have a report that will have formulas in excel. I understand that the limited support for exporting excel formulas has been dropped in SSRS 2008. Is there any way to work around this and still output formulas?obvioulsy the way to do it in previous versions of SSRS are not working (using report items). I tried to add my formulas in my dataset (I can know which excel cells I need in the formulas) but they end up being displayed as text. I then have to get in the excel file and enter and exit each cell so that it "becomes" a formula.
View 11 Replies
View Related
Aug 3, 2009
How to enable ADFS for SSRS 2008?
View 4 Replies
View Related
Sep 25, 2015
Is it possible to hide the entire toggle line and the symbol but still shows the children? I must keep the children in this container.
Before:
After:
View 5 Replies
View Related
Nov 16, 2015
I'm using SQL Server 2008 SP3 with Reporting Services 2008 SP3.
By opening my web application in IE9 and running report, i can print and show then print preview by clicking the "Print preview" button in printing dialog.
By opening my web application in IE11 and running report, i can print the report but if I click on the print preview on the print dialog nothing appears... Why?
View 3 Replies
View Related
Jun 17, 2015
What is the best approach for turning the report below into a PivotTable report in SSRS 2008 R2?The PivotTable has the following characsteristics:
Filters: None
Columns: Mat_Month
Rows: Level1, Level2
Values: MaturingBalances
We have an SSAS Cube with the same data (in a dimensional schema).The report (currently sourced via SQL from our data warehouse):The Pivot Table - currently in Excel but needs to be ported to SSRS
View 3 Replies
View Related
Apr 21, 2008
Hi,
I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:
Report Server Virtual dir: ReportServer Default Web Site
Report Manager Virtual dir: Reports Defualt Web Site
Windows Service Identity: ReportServer with a service acct login
Web Service Identity:
Report Server: ReportServer,
Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.
When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:
"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".
I have read up on IIS7 and it says that:
"This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."
So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?
Thanks!
Isabelle
View 3 Replies
View Related
Jan 29, 2008
Hye all, running WHS 2008, I try to install SQL Server 2005 with reporting services, but on install, in "components to install" wizard, the reporting services box is hided. I can't check this box :/ Do you know whats wrong ? if anyone knows the problem, thanks in advance.
View 1 Replies
View Related
Aug 12, 2015
I have an acctest server (XX-ATS-ASSHP102) running SSRS, SQL DB Engine & SSAS. I'm trying to configure NATIVE SQL Reporting Services to use a data source with Windows Integrated mode towards a SSAS cube on the same server. When I use the servername (or 127.0.0.1) it works perfectly. But when I use the DNS name bidb.acctest.internal it fails with the error "The connection either timed out or was lost.". The profiler on SSAS says "anonymous login" so the Kerberos login is broken at some point.The weird thing is that this works perfectly in production environment, but I've missed something in the ACCTEST environment.The SPN for the serviceaccount running SSAS has correctect SPN:s:
MSOLAPSvc.3/bidb.acctest.internal
MSOLAPSvc.3/bidb.acctest.internal:MSSQLSERVER
MSOLAPSvc.3/XX-ATS-ASSHP102
MSOLAPSvc.3/XX-ATS-ASSHP102.XX.XXXXXXXXXXX.net
MSOLAPSvc.3/XX-ATS-ASSHP102.XX.XXXXXXXXXXX.net:MSSQLSERVER
MSOLAPSvc.3/XX-ATS-ASSHP102:MSSQLSERVER
The SSRS account has delegation with "any service". No account has the "sensitive" flag.DNS names are A-records, except the hostname for the SSRS site which is a c-name, but it's identical in production.The "impersonate client after login" and "replace token" permissions are correct in the policy.The rsreportserver.config says:
<Authentication>
<AuthenticationTypes>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
both in production and in acctest env..
View 2 Replies
View Related
Nov 8, 2009
I have database fields that contain RTF text. If I use the default Textbox in SSRS 2008 Report Designer, I get all the RTF formating characters, which makes for a VERY ugly report.Is there another control I can place on my report that will take the RTF formated text and display it properly? I can do this in Crystal Reports, but I'm converting to SSRS 2008 so I need to be able to handle RTF formated text.
View 4 Replies
View Related
Dec 21, 2011
I have a dataset in my report that pulls 10 fields. One of the tablixes on report should display only 8 of the 10 fields and this is causing the duplicate records to show up on the tablix.I tried hide duplicates option for the entire details row and have set the scope to "Details". It did not work. I am getting the data from a stored procedure and cannot do much on that.
View 7 Replies
View Related
Mar 2, 2012
VS 2008. I have the following set up. Group1, Group2, Group3 header, Group 3 detail rows..When I set the row visibility (hide based on Group2) on the Detail row, it still shows up when the report is originally rendered.
It should be: Group1 expanded, Group2 collapsed, Group3 header hidden and detail rows hidden
It is showing: Group1 expanded, Group2 collapsed, Group3 header hidden, Group3 detail row visible.
I never had this trouble in 2005. Is there something different about row visibility in 2008?
View 3 Replies
View Related
Jun 30, 2009
we need the list suppliers in a text box,if it were a parameter, we can do it by =join(parameters!Supplier_ID.Value,",")but if the Supplier Id is a field , join (Fields!Supplier_ID.Value,",") doesnt work!how to achieve this.
View 9 Replies
View Related
Sep 12, 2011
Presently I have a main report and subreport, with the subreport having values for a carbon copy contact, which when it is displayed it shows these values:
Peter Piper #Error #Error peterpiper@mycompany.com #Error
Donald Duck #Error #Error donaldduck@mycompany.com #Error
etc.
When I run the subreport directly, it correctly returns all the values:
Peter Piper 123-345-6789 Calgary peterpiper@mycompany.com T
Donald Duck 987-654-3210 Calgary donaldduck@mycompany.com F
Here are the details on SQL Server 2008:
Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64) Feb 25 2011 13:56:11 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
why the #Error is showing up the the main report?
View 3 Replies
View Related
Feb 22, 2011
I've had a SSL wildcard certificate successfully in use, unless it had to be replaced because of its age. Now I've imported a new certificate, but unfortunately I'm unable to set it up in the SSRS Configuration Manager Console (Web Service URL / Report Manager URL), because "We were unable to create the certificate binding".
Here is the Error Message:
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070520
---> System.Runtime.InteropServices.COMException (0x80070520): A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
--- End of inner exception stack trace ---
I've also deleted the existing bond in the netsh console with "netsh>http delete sslcert ipport=0.0.0.0:443", but this still doesn't fix the issue.
View 3 Replies
View Related
Dec 23, 2011
i need to create a 32 tile Heatmap in SSRS 2008 R2,I am not too concerned with adjusting colours by values, I just need to get the 32 tiles in place in the report initially, then extend it with more functionality later on.
View 4 Replies
View Related
Jan 31, 2011
Currently i am working on SSRS 2008 R2.The issue is that it is wrapping long words and not growing. I set the property can grow to True.
How to prevent the word wrapping?
For example, the column will have the word "information" in it. Instead of the column showing:
information
it shows:
informatio
n
The "n" gets wrapped to the next line. Is there a way to prevent this from happening.
How to prevent the word wrapping?
View 4 Replies
View Related
Nov 3, 2008
I have created a new report & add a table to it. When I select "Tablix Properties" and check on Columns Headers -> "Repeat Cheader columns on each page" the header columns do not repeat on each page. I also tried "Repeat header rows on each page". "Add page break before" seems to work ok. I am using VS 2008 9.0.30729.1 SP..I also tried deploying but it still does not work on the deployed version.
View 69 Replies
View Related
Feb 21, 2011
I've been running into this issue quite a few times, and have been unable to solve it through reading various posts/forums. Here is the issue
Software Details:
Datawarehouse Database - SQL Server 2008 R2
Reporting Services Version - SSRS 2008 R2
Development Environment - Visual Studio 2008
Problem Details:
I have been writing reports based of a Relational Datamart with dimensions and facts. The report in question uses dimensions for parameters and facts for content. Multi valued parameters are enabled in the report query by using the 'IN(@Paramenter)' statement within the report query. It has a total of 6 multi-value parameters. I assign the same available values from dimension datasets for each parameter to it's default parameter. Theoretically all the values in the option lists should be selected after first render. This is not always the case.
Example:
SELECT *
FROM dbo.MyTable
WHERE
TableColumn0 IN (@Parameter0)
AND
TableColumn1 IN(@Parameter1)
AND ....N (continue syntax to 6 multi valued parameters)
Some of the multi-value drop down lists are defaulting to have every value selected, and some are not. The problem is I need to know why some parameters are not selecting all by default when specified.
View 23 Replies
View Related
Jun 17, 2015
I am trying to test the concept of passing multi value parameters from one report using the Action Property of a textbox to open another report is a new Window with the Multi Value parameter values already passed. The test involves the following:
Report 1:
1. Multi Value Parameter @ReportParameter1 has three Values: Value1, Value2, Value3
2. Has a text box with the Action Property set to Go to URL with the following Expression:
="javascript:void(window.open('http://reportserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fReport2&rs:Command=Render&ReportParameter1="
+ JOIN(Parameters!ReportParameter1.Value,"&ReportParameter1=") + "'))"
Report 2:
1. Has Two Parameters @ReportParameter1 and @ReportParameter2
2. @ReportParameter1 has Available Values as follows: Value1, Value2, Value3
Does not have any default Values.
When I click on the textbox on Report1, it does navigate to Report2 but none of the Values are being set.
View 3 Replies
View Related
Sep 1, 2011
We have recently upgraded to SP1 of SSRS 2008. As a result, when we export a blank report to CSV, we now get a line of commas below the headings. Or found a way to not include the commas?
New SSRS Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D,
Old SSRS Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D,
View 4 Replies
View Related
