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

Need to find a to have summary and detail pointers in a bullet graph in sql server report builder 2008.  My data comes in for a dynamic number of model types and need to have them as a pointer within a summary of all models pointer. I have done it statically but not where model count can change depending on what our plant is building.
BufferOverviewV2.pdf
0
Exploring SQL Server 2016: Fundamentals
LVL 12
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

2 separate reports from 1 stored procedure...

I have a Detail version of a query with roughly 8 columns and a 'D' qualifier Column to show its detailed
and a summary version of a query with roughly 4 columns and a 'S' qualifier Column to show its Summarized

What I am hoping is to use 1 single Stored Procedure to maybe call a #TempTable for either the Input of a 'S' or 'D'...is this even realistic?

I am not against creating multiple Stored Procedures that pass results to each other...

Kind of new at this
0
Visual Studio 2015, SSRS

I am having a problem working on RDL files locally.  I was sent some RDL file to review.   When I use  "Add Existing"  to add the reports to a report project, I can see the report design when I right-click and select "View Designer"

However, when I select "View Code", I only see XML.  What am I doing wrong?

Thanks
0
Experts,

I have an SSRS server setup and we are currently scheduling nightly delivery (via EMAIL) of reports to clients.

The issue is that I would like to "dynamically" change the "FROM EMAIL" address for the out-going emails that contain the reports to a "Special EMAIL Address" for certain CLIENTS.
So for example, if I schedule a nightly report delivery via email for Customer "A", then I want EMAIL ADDRESS "A" to be included within the body of the email as the FROM email.

If I schedule a nightly report delivery via email for Customer "B", then I would like EMAIL ADDRESS "B" to be included within the body of the email as the FROM EMAIL.

Can someone help with HOW TO DO THIS?

Let me know if you have any questions.

Thanks
M
0
Hi, Just dropping this question again with some more detail to see if i can get a work around.

I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues. we have over 25 reports that need to been converted but they all have a running total as a grand total, typically evaluating on group, outside of the group. In some cases these running values are used in other calculations. It is a nightmare.

As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

I have read through many links but i can't see how they will work, but i might just have a skill gap, none of them cover where the running total evaluating on group are used as a total only.

I have attached an example of one of the reports that has a running total, it is only one of the possible layouts and ways the previous reports used the running totals. but does highlight the issue i am hitting. If possible i would rather do this within the ssrs report but i am at a loss on how to get it to work.

We are on SQL 2014 but are about to migrate to 2016

Any ideas on a way to get this to work?

Example-of-Running-total-in-Report.JPG
0
I'm a system administrator for Report Manager.  I can see the users my folders, but cannot see the reports in the folder.  I need to be able to see all the reports created in report builder in the user's my folder.
0
I need to create a report based on a sharepoint online list. When our sharepoint server was in house, this was not a problem but I cannot get the connection string to work for sharepoint online. I do not know power BI and frankly don't have time to learn it. If I can get SSRS to connect and I can get my report done in 1/2 hour. Anyone know the connection string to make this work?
0
I am trying to write a ssrs report based on a sharepoint online list. I have tried about 100 different variations of the connection string with no luck. Can anyone point me in the right direction?
0
Hi Experts,

I am using SSRS and I want to create a subtotal on based on the first 7 character of the AccountID field.

So the example attached, I would have a subtotal for the account 101-002-xx,  101-007-xx and 102-002-xx.

Screenshot_1.png
0
How can we deploy the ssrs report to Share point?
0
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

We create VMs with the latest build of our code on. One VM has a weird ASYNC_NETWORK_IO error when running a SQL SELECT statement. It isn't on any other VM.

I have tried googling for the error - clearly something failed to start or get set when this VM was created.

Just for peace of mind it would be really useful to know what might be the cause of this and if there is some setting I can adjust to fix it.

The symptom is that a SQL SELECT statement just seems to time out with this ASYNC_NETWORK_IO error, but the strange thing is that it must have somehow returned some results because it then blocks an INSERT statement that has used the results of the SELECT statement.

Everything necessary for the application is on the VM - the ASP.NET application and the SQL Server database so there is no actual network access outside of the VM.

There is no antivirus running on the VM either which is one possibly cause I came across.

The server is Windows Server 2016 and the SQL Server is 2016 also.

I've attached a picture of what is happening.

Just to repeat this doesn't occur on any other VMs with the same software on.

I have tried restarting IIS and restarting the VM.

The VM is Hyper-V.

ASYNC_NETWORK_IO error
0
Hi,

I have found the following code to render an SSRS via a SSIS script. This script works as it is intended, e.g. saves the rendered report to disk.

But I would like to send the rendered report as an email attachment, without saving it to disk. Please could someone help? I have tried to render it to a memory stream but I can't quite get it to work.

Thanks, Greg

 Protected Sub SaveFile(ByVal url As String, ByVal localpath As String)
        Dim loRequest As System.Net.HttpWebRequest
        Dim loResponse As System.Net.HttpWebResponse
        Dim loResponseStream As System.IO.Stream
        Dim loFileStream As New System.IO.FileStream(localpath, System.IO.FileMode.Create, System.IO.FileAccess.Write)
        Dim laBytes(256) As Byte
        Dim liCount As Integer = 1
        Try
            loRequest = CType(System.Net.WebRequest.Create(url), System.Net.HttpWebRequest)
            loRequest.Credentials = System.Net.CredentialCache.DefaultCredentials
            loRequest.Timeout = 600000
            loRequest.Method = "GET"
            loResponse = CType(loRequest.GetResponse, System.Net.HttpWebResponse)
            loResponseStream = loResponse.GetResponseStream
            Do While liCount > 0
                liCount = loResponseStream.Read(laBytes, 0, 256)
                loFileStream.Write(laBytes, 0, liCount)
            Loop
            loFileStream.Flush()
            loFileStream.Close()
        Catch ex As Exception
        End Try
    End Sub
    

Open in new window

0
Hi,

We have MS SSRS 2016 configured on Windows Server 2012 R2. Quite frequently we have to end the "ReportingServicesService.exe" process via the task manager and then restart the service because the reports just show the loading circle when rendering. The SSRS portal itself is OK and the end users can browse through folders and see all of the reports but when they select ANY report it just hangs at rendering.

If we try to stop the "SQL Server Reporting Services" service via the SQL Server Configuration Manager it does not stop. We have to end the process via the task manager and then restart the service. Normal service then resumes for a few days.

I have had a look through the logs in "C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles" but I cannot find anything useful, but then I do not really know what I am looking for.

Has anyone come across this issue before?

Thanks, Greg
0
I want sum of Count column, can you please share expression for this or how to do this? the number of rows of date and count column is not fixed, it will vary every day.Untitled.png
0
I got the screenshot from my SSRS builder for MS SQL Server.
Inside of the textbox. Can I run sql statement like the following?
all I need is to get the value from =Fields!newleadfirstname.Value and try to run another select statement.

= select lead.firstname from leads where lead.firstname=Fields!newleadfirstname.Valuexxx
0
I create SSRS report with 2 series. One is the number of tests, another is the number of tests that passed on the first try. I want to show it as stacked bar report. When I create the report with 2 series, both numbers are in the same bar, but they are one above the other, while I want the bar colored according to the percentage. For example, if in given month there were 100 tests, of which 90 passed on the 1st try, I want the bar filled with the 2nd color at 90% - instead of the current 100 and 90 on top of each other. Is it possible?
screenshot
0
I've got a SSRS report which currently filters a dataset on "[ProgramID] = @ProgramID" and the report parameter is set to only allow a single selection.  This is currently done in the dataset which looks something like:

SELECT * FROM myTable WHERE ProgramID = @ProgramID

My client wants to change this to allow the user to select multiple Programs from the Program dropdown.

How do I modify the SQL query in my data set to accommodate this multi-select parameter?  I've tried a number of things and cannot seem to get it to work by modifying the SQL or by removing the criteria from the query and adding a filter to the tablix which uses the dataset.  I've searched and tried a number of "solutions" from here in EE and other web-sites and just cannot get this right.

Thanks
0
SSRS Subscription and Daylight Saving Time

What is the best way to handle  Daylight Saving Time in SSRS subscription


Can that be updated in DB ?

thanks
0
Hi,

I have something somewhat similar to the Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS) with the Expression-based Connection Strings. This is with SSRS 2014.

But when I go to publish it's asking for datasources on the Report Server -> Report Manager. How would/could I do the Expression-based Connection Strings with that?

Any information on that would be greatly appreciated.

Thanks
0
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Good day experts,

Here are my issues with an SSRS I've got to get working:

1. I'm trying to build a report that should have details in columns ( left to right or horizontally ) rather than rows.
    For this, I was able to create a Matrix, delete the Row groups and then create the details in the columns groups, as you can see in the attachment. It seems to work however I'm mentioning it because it might be the issue with the page break.

Example of my grouping inside a matrix tablix.
2. Then I'm trying to apply page break to this column group.
    For this, I created an expression on the column group that is: =Ceiling(RowNumber(nothing)/10) in order to have ten details per page. I then apply page break option to this group however it doesn't apply the page break. The grouping on the expression is correct though. (see attachment)

Enter of page break not working
Could you please help me understand what I'm missing or what new approach I should have to solve this issue.

Regards,
0
Hi,
We have a DB driven application where all the business logic written in Microsoft SQL.
We need to create a bunch of dynamic PDFs (Fillable PDFs) as a result of the calculations. We are now creating the PDF using .Net API and PHP.
Is there any easy way to create the PDF using SQL Reporting Services or any other ways?
Once the PDF is generated, we will use Angular ng pdf viewer to show the preview in browser.
Please help?

Thanks in advance :)
0
I had this question after viewing Displaying group data from a table in a textbox outside the table in SSRS 2008.

I followed the steps, and I'm at the point where I have a text box named Textbox52 in the header and it has the value I want, but when when I try to use Textbox52 to display the Value using the expression ReportItems!Textbox52.value  somewhere else in the report (I have several rectangles in the report), I get the error "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope. Letters in the names of report items.
0
I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues.

In a number of reports, A running total evaluating on change group is used as a grand total outside of the group. As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

Any ideas on a way to get this to work?
0
Hello All:

I need help in figuring out how to print a subreport on the last page of it's main report with one parameter passed between them in SSRS.

I need to print a purchase order and every time it prints a follow up terms sheet prints after the main PO prints with the purchase order number printed on both the main and sub report.

I need assistance on the best approach for this.

Any ideas on the best approach for this would be very helpful.

Thank You

Rm103
0
I have a list report that basically looks like

ReportProblem1.jpg      
What I would like is

ReportProblem2.jpg
If there are 2 jobs on a given date, they would be stacked otherwise all jobs are on the row.  Sorry for the crudeness.  I wasn't sure how to ask this questions.
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.