Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Share tech news, updates, or what's on your mind.

Sign up to Post

We have SCCM current branch 1706, with a SQL 2012 server on the back end running SSRS. I would like to allow our Service Desk access to create their own reports in one specific folder only - protecting all the other folders containing the standard SCCM reports.

Is there a way to define a security scope that's SSRS folder aware? I don't think I can do this from the SSRS side. I believe SCCM sets all permissions via policy on those SSRS folders every 15 minutes.
0
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Hi Experts

In SQL I have this:
(Cast( SUM( Case when ActionableResult = 0 THEN 1 ELSE 0 END)  as float) /Count(*)) *100 as PercentCompliant

Open in new window


Which comes out good on the column in SQL
Example:
Pass/All
364/4425 *100 = 8.225988

But in SSRS:
I get 822.60%

I have tried:
=Fields!PercentCompliant.Value
=Sum(Fields!PercentCompliant.Value)
even:
=(sum(Fields!Pass.Value) /sum(Fields!All.Value) * 100)
=(Fields!Pass.Value /sum(Fields!All.Value) * 100)


What am I doing wrong?

Please help and thanks
0
I have column Name is FirstName and It has 30 characters like ' signs agreement with HTC continuing our big bet'. when I am displaying this value with ssrs reports it shows me half characters like 'signs agreement with HTC'. I need to display all values.
0
I need to make SSRS 2012 reports available to users on a mini ipad.
What would be the best way to implement?
0
I have a large report developed in Visual Studio 2015.  I am using SSRS 2016.  I can run the report in VS 2015 This is the exact msg when deploying to SharePointbut when I try to deploy to Sharepoint 2013 I get the following error msg:

Native compiler return value: '[BC30494] Line is too long.'
0
Hey guys-
I have a sql server that runs a few apps but is also our main reporting server.  the apps aren't heavy loads on the sql database.

is there a way to tell which reports are causing all the cpu usage?  do I have to find the query behind the report in activity monitor on ssms or is there another way.

basically, whats a good way to figure out what's killing our server here.

Update... this is an edit.  the spike occurs when I go to the SRSS landing page as a user from internet explorer
0
I am completely new to SSRS and I have been asked to learn it on my own and transfer all weekly reports to SSRS (eventually).  As I built my first report with help of online tutorials I was hit with a warning:  "The report or subreport has a recursive subreport 'SubReport1' that exceeded the maximum recursion limit allowed."  I am not sure what it means so please dumb it down for me.  
Here is what I did - I created a brand new report, defined datasource, datasets based on a SQL query that runs without any problems in SQL. It has 4 columns and rows mostly contain text and numbers and there are no additional operations after the report is run.   When I run the preview, it runs and shows me all the rows but gives me a warming as stated above. The query has 150 some rows so it is not huge but I also know at times this query will return thousands of rows.  
How do I fix this?  I can't seem to find much on google.  
Thank you in advance.
0
I am running SharePoint 2007 with Reporting Services. I am trying to dynamically set the reports data sources.

I am able to view the ReportService2010 at https://servername/sitename/_vti_bin/ReportServer/ReportService2010.asmx

In a C# Console application, I have set a reference to ReportService2010.

The credentials I am using are correct and have all the required permissions.

The path to my .rdl file is "https://servername/sitename/Coupons/MyReport.rdl" - if I put this into my browser the report comes up with no issues.

The path to the data source is "https://servername/sitename/Coupon%20Connections/CouponDataSource.rsds" - if I put this into my browser the report comes up with no issues.

The code in my console application is below.

So not matter what value I give to the variable "string path" - I get the same error - "Server was unable to process request. ---> Client found response content type of '', but expected 'text/xml'.\nThe request failed with an empty response."

It seems that the path I am specifying for the .rdl is not being found. Should the "itemPath" parameter for SetItemDataSources or GetItemDataSources be something other than "https://servername/sitename/Coupons/MyReport.rdl"?

   ReportingService2010 client = new ReportingService2010();
           
            client.Url = Settings.Default.ServerUrl + siteName + "/" + reportServiceUrl;
            client.UseDefaultCredentials = false;
            client.Credentials = new 

Open in new window

0
I am having trouble with an installation of reporting server where I have chosen to have the credentials stored securely in the report.  The user I have entered is a domain admin account, but when I test the connection it takes about 30 secs to return the Green connection created successfully.  This is causing all reports to run incredible slow.  When I change  to windows integrated or run the report via SSDT then all reports run in about 1 sec.  Sql has about 75 gb of ram on a server with 100 gb of total memory.  What could be causing this issue?  Is this account messed up?  Should I try another domain account? Any way to test?
0
I'm using SSRS 2012.  I'm trying to create a report that has 3 separate TABLIX's on a single page and each Tablix has a separate data source.

I have made 100's of SSRS reports but this one has me stumped.  I have 3 tables each with CUSTOMER_ID and STATE_ID.   Besides CUSTOMER_ID and STATE_ID, the tables are unrelated.  In the end I want to select and STATE and then print all the CUSTOMER data for the state - 1 page per CUSTOMER - 3 tables.  

I could join the 3 tables together by the STATE and CUSTOMER ID's but it would be many-to-many relationships.  I don't know how I would then cleanly single out data for each of the three tables.  (I've tried this approach.)

A second way, which I would prefer, and seems it would be the cleanest way would be to have three TABLIX's and three unjoined data sources.  I would like that but how would I print/keep together the same CUSTOMER ID for each page when I select a STATE.  For example, I select TEXAS and want to print all the CUSTOMER data for each of the three TABLIX.  In other words, I would need to print CUSTOMER_ID = '1' for each data set then move to the next CUSTOMER_ID for Texas.

I hope that makes sense.  It doesn't seem like it should be this hard.  Any suggestions on how to approach this would be appreciated.

Thanks.
0
Free Tool: Subnet Calculator
LVL 10
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Whenever the details per header go beyond 1 page...I need to repeat the header with "Cont'd'..I can't figure it out
ESL_Consolidated_Job-Trial-Balance.rdl
0
Hi all,
I'm joining a new web server to an exist farm, everything works well, enabled report sync and SQL Reporting service on the new Server.

The new site on new server has every items exactly like the current one, but when i click on any report, item, it shows "item "http://servername/report1.rdl" not found".

Even when i tried to create a new datasource on any library on the new site, it shows "http://servername/libraryname" not found. But if i create new other document like image on that same library, its ok.

I really appreciate your help! Thank you!!!
0
I am using some columns in Row Group of Table, When I am trying to hide the columns based on some conditions.  The Column Visibility Property is in disabled mode. Is this Possible to apply hide/Show Property on Row Grouping Columns in SSRS?
0
I have a web application that includes ssrs from sql express 2017 and using the web portal to deliver reports.  I have an ssl certificate for the site.  ssrs is using sql server user credentials.  The problem is that when I open the url in a browser I am prompted for credentials to sign in.  Is there any way to use impersonation or some other method to view the reports?  I am also using windows identity for my web application.
0
Need to export report to Excel with no header.
Added to rsreportserver.config the following

<Extension Name="EXCEL (No Header)" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
 <OverrideNames>
    <Name Language="en-AU">Excel (No Header)</Name>
 </OverrideNames>
 <Configuration>
 <DeviceInfo>
<SimplePageHeaders>TRUE</SimplePageHeaders>
 </DeviceInfo>
 </Configuration>
</Extension>

this is what I wanted OR so I hoped..
Yes the report header is not rendered in Excel however when printing the report there is a HEADER...

I know that in EXCEL you can simply delete the page header/footer in the Page set up, But I need to export to EXCEL with no header displayed in Excel nor displayed when printed; without having to do anything in excel except press the print button.

I also tried
<Extension Name="EXCEL (No Header)" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
 <OverrideNames>
    <Name Language="en-AU">Excel (No Header)</Name>
 </OverrideNames>
 <Configuration>
 <DeviceInfo>
    <NoHeader>True</NoHeader>

 </DeviceInfo>
 </Configuration>
</Extension>

But this did nothing at all i.e. the header was displayed

I am using SSRS 2008R2
0
We have a sql cluster using 2008R2. When running on one node of the cluster, our SSRS reports are fine. When running on the other node, the reports are extremely slow. For example, we have a 350 page report that the first node can print to pdf in about 30 seconds. The same report take at least an hour on the second node. As a test, I installed sql server and SSRS on my laptop. I can print the same large report also in under a minute.
So what could be happening on the second server that slows printing down so much? It doesn't matter whether we are printing to paper, pdf, etc. Also, it happens with any of our reports. It is not limited to this one large one. It also happens whether there are images  on the report or not.
0
Hi All

Some time ago I implemented some on demand subscriptions following this guide https://www.mssqltips.com/sqlservertip/3078/report-launcher-to-run-ssrs-report-subscriptions-on-demand/. Recently, I turned off SSRS to run some maintenance, when I turned the services back on, the subscription fired on its own. Foes anyone know why this is?
0
Hello I've read it is possible in SSRSto add HTMl to text boxes to change the font size colour with in a line of text is it possible to do this in a data label on a chart ?

If so how?

Thanks
0
We have SCCM 2012 with SQL Reporting Services providing the back end for reports. We would like to tweak the "IP - Computers in a specific subnet" report to allow the user to enter a wildcard to see computers in a range of subnets. The report's default setup for the IP subnet parameter is to provide a list of subnets via the "Get values from a query" option in the "Available Values" section of the Parameter Properties.

I know if I set the "Available Values" option to "None" the end user can enter whatever they want. However, I would like to continue to provide that list of Available Values from the query but also allow the user to enter their own text that includes wild cards so they can see a specific range of subnets.

This was easy in SCCM 2007, but I'm having trouble navigating Report Builder. I'm sure I'm missing something fairly obvious. I'm hoping an Expert out there can show me the way.

Thanks.
1
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

We recently setup a SQL Server Reporting 2016 on a Windows 2016 server.  We installed a 3rd party SSL cert and configured SSRS to use this cert.

When we open the reports site with IE or Edge everything works fine.  But if we try to open with Chrome or Firefox we get an error "ERR_SPDY_INADEQUATE_TRANSPORT_SECURITY" and the site won't load.

This sounds like SSRS is using an outdated cipher that is not secure so Chrome/Firefox refuses to use that cipher.

Since SSRS 2016 doesn't use IIS anymore, how do we configure what SSL protocols and Ciphers SSRS uses?

Thanks!
0
I have a report that uses three levels of row grouping: Branch, Route, Type.  Each row group has a set of adjacent groups that show various metrics.  The customer wants the report to open with only the Branch group along with their Type groups visible.  When the Route is hidden on open the report looks ok.  However, when I toggle the Route group none of the subsequent Type groups have their labels.  The attached file shows what I mean.

How do I hide the Route  yet have the Type group text show up when toggled?  The correct data shows just not the column with the row names.
SSRS_Report.doc
0
For example as per attachment, i would like a  function that looks at a single occurrence of females first on the management level field and Gender field and gives an additional column a label for example VP Black women, and at the same time look at the occurrence of both male and female and the management level and gender field and give a label/column field of for example VP Black. I would like to use this label or column in SSRS to show a field grouped by females only and a combination of males and females. Your assistance will be highly appreciated.

for example, the query i had in mind would go like this. Excuse i am a complete novice

select [Management level],[gender],[Corporate grade]
case when patindex(%Black%,[Management level]) AND patindex(%Female%,[Gender key]) the 'VP Black women' else 'VP Black'
0
I have an SSRS report. It selects data from a view and the single parameter is used as the where clause. Without trying to explain things explicitly, the report is essentially a quote form. So, I pass in a reference number and it generates the quote. Basic stuff like company name in the report header, company address, then in the body, the quote items list. Assume the quote will always be a single page. As the same quote is being sent to more than one company, the quote header has the company name and address, then the quote items duplicated on each page in the report body. The footer contains the count of companies the qujote is being sent to so they know how many people are in the running for the quote. I've got everything working except the company name and address in the header doesn't change.

I have the exact same report in Crystal and that works because instead of apage header, I put what is essentially the page header into a group header. This allows me to change the name and address as the group changes. How do I do the same in SSRS?
0
I have a TFS   2010 and SP 2010, sql2008r2 report server in SharePoint integrated mode  Whenever I try to create a new project it fails and get the message :

TF218027 This operation is not supported on a report server that is configured to run in SharePoint integrated mode

See screenshot

I don't believe this is a permissions issue, As I have created many projects in the past using the same credentials.

I am aware that you can use Report Services Configuration Manager to change the DB to native mode, but I have many projects set up with the current DB in integrated mode and I dont want to cause issues with them.

We a planning to migrate to the latest versions of sharepoint and TFS but we cant right now.

I am just trying to create a new project the must be a way to do this.


Thankserror message
0
Several months back I loaded a bunch of images into a SQL Server table as image. I then created a SSRS report to display the images. Report worked. The other day I added more images but those images don't display but old ones still do. Red X. I loaded the images through Access as object with linked table to SQL Server. All images are jpg. Odd thing is, in Access if I double click on the new images, they pop up in image viewer so I know they are there. But the old ones don't display but yet they show up on SSRS report. For the old ones in Access I get the following:
"A problem occurred while Microsoft Access was communicating with the OLE sever or ActiveX Control."
I tried converting Image type to varbinary (max) but got the same results.
Any ideas?
Using SQL Server 2008 R2, Access 2010.
0

SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.