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

What is best configuration to have SQL Server 2014 Standard & SSRS component run on a normal Windows OS ( 7 or 10) and send reports by email ?
0
Cloud Class® Course: Microsoft Windows 7 Basic
LVL 12
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

We are migrating an Onpremise D365 installation to CRM Online.  There is a report written in SSRS that needs to be converted to Fetchxml.  

The code is below, can someone point me to a resource to convert SQL to Fetchxml?  I have written Fetchxml from scratch but need assistance with the conversion.

<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"><Body><ReportItems><Rectangle Name="rectangle1"><ReportItems><Rectangle Name="rectangle4"><ReportItems><Textbox Name="txtFilterSummary"><CanGrow>true</CanGrow><KeepTogether>true</KeepTogether><Paragraphs><Paragraph><TextRuns><TextRun><Value>Filter Summary</Value><Style><FontFamily>tahoma</FontFamily><FontSize>12pt</FontSize><FontWeight>Bold</FontWeight><Color>#313336</Color></Style></TextRun></TextRuns><Style /></Paragraph></Paragraphs><Left>0.125in</Left><Height>0.25in</Height><Width>3.53125in</Width><Style><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style></Textbox><Textbox 

Open in new window

0
How to add the textbox values of columns? these textboxes are not the part of the dataset. I have tried several options but something seems to be missing.

tried #1
=sum(ReportItems!Textbox22.Value)
Error: aggregate functions can only be used on report items contained in page headers and footers

tried #2
=RunningValue(ReportItems!Textbox22.Value,Sum,"Dataset1")
same error as above:   aggregate functions can only be used on report items contained in page headers and footers

tried #3
I wrote a vb function like this given in this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/002c459a-2260-437a-a53c-a380bc2299d0/sum-column-gives-error-aggregate-functions-can-be-used-only-on-report-items-contained-in-page?forum=sqlreportingservices

Public Total_lookup_Sum As Integer = 0
Public Function Lookup_Sum(ByVal value As Integer) As Integer
    Total_lookup_Sum = Total_lookup_Sum + value    
    Return Total_lookup_Sum
End Function

and then wrote this expression:
=Code.Lookup_Sum(Reportitems!textbox22.value)

the output shows me the last value of the textbox instead of aggregating all the textbox values.

if I write the expression
=Code.Lookup_Sum(Reportitems!textbox22.value)
=Code.Total_lookup_Sum

the output shows true a boolean value.

I tried cint also but no success.

I can't use =sum(Fields!......Value) because textbox is not the part of the dataset.
I can't hardcode like textbox1.value+textbox2.value.

I have googled a lot of …
0
Hello

I'm having some trouble following this Microsoft document:

https://docs.microsoft.com/en-us/system-center/scom/upgrade-sqlserver-2017-opsmgr-1807?view=sc-om-1807

I have successfully upgraded my SCOM instance to 1807. I have also successfully upgraded the SQL database instance from 2016 to 2017, as that is now supported. However, I am unable to upgrade reporting services successfully. According to the release notes of SCOM 1807, upgrading from SQL 2016 to SQL 2017 is supported, but not for fresh installations. I find it curious then, that this upgrade guide instructs a removal of Operations Manager Reporting Services, and after upgrading SSRS, to install Operations Manager Reporting Services again. So, either I’m not reading this document correctly, or nobody has tried to follow it yet, including its creators.

How does one reinstall Operations Manager Reporting Services when using SQL 2017 Reporting Services? There is no 1807 fresh installation media as far as I am aware, so naturally, the 1801 installation media gives me this error when trying to reinstall:

The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.

Would anyone have a workaround for this at all, or should I just go back to SQL 2016 SSRS?
0
SQL command text property value is invalid multipart name select . It occurs when I have the stored procedure and running the query to obtain data. I cannot view the data so I can see whether my paginated report in SSRS report builder is capturing the data I would like
0
I need to install SQL Server Standard 2014 , the main usage will be to activate the SSRS ( Reporting Services) and have it send automated scheduled emails to client. The main point I need t clarify is : can i install this edition of SQL server and have the SSRS running, on a normal windows OS ( Widnows 7, or Windows 10) .... or must it be a Windows Server OS ?
0
I am needing to deliver some js files to a desktop application that runs in a browser shell.  The reason I am doing it this way is I don't have a web server.  This has been running successfully for months until recently the cdn references to libraries like jquery no longer consistently download each time the app opens.  The app is running on windows 7 and uses IE 11 for the shell.  In replacement of a web server I thought about using SSRS since we have a db server.  I can't get the dba to turn on iis on that server as well but thought about placing the files on ssrs and then pointing the script tag src to http://ssrs-server/ReportServer?/Apps/Libraries/jquery.min.js.  When I test this I see the reference to the file in the temporary internet files folder so it appears to download but the initialization in code of jquery fails as if it were not available.  So maybe I don't fully understand what is being listed in the temporary internet files folder and how the app uses the js file from this location.  Does anyone have any suggestions as to what may be wrong or it there some type of conflict with ssrs in the opening of the file.  I can click directly on the file listed in ssrs in the folder view and it opens like a hyperlink showing the js file content.  Thanks for your input.
0
Installation failed for sql server 2012  sp4 upgrade for one of the cluster node1.. and another node2 is working fine
see the error msg sql server 2014 sp4 upgrade failed cached msi

1. even copied  sql_engine_core_inst  from C:\sqlpatches\sp4\x64\setup\sql_engine_core_inst_msi

to %windir%\installer\
with

cached msi file 7b2f1fe.msi


2.  https://github.com/suyouquan/SQLSetupTools/releases/
FixMissingMSI_V2.2ForNET35.zip

and fixed all..

Still the same error

Not sure, what should i do
0
I have manually edited an rdlc report script to add 3 new columns to the rdlc report. I did this by making sure the data retrieval query contains the columns and by
manually adding a <fields></fields> entry for each new column in the rdlc script. The new columns do not display on the report but rather a blank space shows on the report where the new columns should be. I searched Google and determined that I may need to rebind the data source. However, all the information on rebinding that I found uses a report design tool. How can I rebind the new fields without using a report design tool?
0
SSRS report,  Running Value on the 3rd group down, can’t change this…the sorting is a must.  There’s two RunningValue columns, one by the first group (works) and one by the 3rd group , will work with only two groups.  How to create a running total on a change of a specific group when there’s more than 2 groups.


This is in Microsoft Dynamics CRM using  FetchXML so I cant use SQL or VB/C# code and have a single data set.
0
Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Hello techies :)

With the new 2016 version, the parameters can be rearranged on its own banner, unlike the 2008 version we could only have 2 columns of parameters.
Trying to figure out if there is a way to reduce the vertical / horizontal spacing between parameters on the band.  Also, font size.
If someone can put me on the right direction then will be greatly appreciated.

The link in below is great and all but does not say anything about changing the spacing nor the font sizes.
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/customize-the-parameters-pane-in-a-report-report-builder?view=sql-server-2017

thx


JohnE
0
How do I custom sort the legend of a PIE chart in a SSRS report? I want the elements in the legend to appear in a very specific order that defines business process. Any help is appreciated.
0
How to export date in general format in Excel File in SSRS?
0
Please setup a filter with the following criteria and save it. Name the filter:  Tony’s tasks this month

Assigned to:   Me (Tony)
Updated date:  This month

Grouped by: State
Sorted by Parent, then by custodian

Bonus points for sharing the filter with my manager, Jonny Lee
0
I'm re-writing a few SSRS reports that were on a 2008 SSRS server and deploying those to a 2017 SSRS server.

I have visual studio 2008 on my local pc I write/modify reports and deploy to the 2008 SSRS server. I also have Visual Studio 2017 on my local PC to write/deploy SSRS reports 2017 reports to the 2017 SSRS server.

My 2008 works fine, no issues. My issues are in SSRS 2017. I can write, preview and deploy basic reports to the 2017 server except those using custom assemblies.

I have several 2008 reports using a custom dll. I have that custom dll deployed and running on the destination SSRS 2017 server. I have it configured correctly so they I can deploy a report that uses the dll and I can successfully run the report on the server.

My problem is that I can't preview it on my local machine. I get the following error:

An error occurred during local processing.
Failed to load expression host assembly. Details: Could not load file or assembly 'Zen.Barcode.Core, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b5ae55aa76d2d9de' or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418)

I'm almost positive some config on my local PC is preventing the preview. Has anyone seen this before?
0
How can we improve SSRS performance?

My NAHost is 2016 vm, 4 CPUs, 16GB, 60GB free.  I started w/SQL 2016 Express SP2, then upgraded to SQL Developer SP2.

When I click on a report it takes 10 seconds to start doing something, 15 seconds before the SSRS header comes up, and another 15 seconds before it renders data.

Upgrading to SQL Developer allows for more memory to be consume by SQL server, but no real improvement on SSRS performance.
I don't have a lot of demo data, so it should be faster.

Any thoughts on increasing SSRS performance?
0
How to Authentication parameters [user,password] to SSRS reports  while calling from Angular4 Application  to avoid prompt for username and password at runtime.
0
I have .rdl files which I have added into the reports in the solution explorer and then I have datasets in the report data. On the basis of datasets when I preview I get some options to select and then I am able to get the data fetched from the database (ssrs). I need to generate a table when I select options while previewing. I am getting data from 2 tables. I know there can be various ways to approach this. I might need to write expressions in the reports or some other way. Can anyone help me getting started with how to build dynamic tables in reports?
0
My SSRS 2016 report is not displaying data.  The stored procedure run in management studio returns data.  When I run the report in the Query Designer within SSRS it returns data but nothing is displayed.  What could be causing this
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Have aa SSRS report which has a table near the top with case information.  In SSRS, this table is formatted to be 7.5" wide, and displays like:
SSRS formatBut when my users export this report to Word, that same section of the report is shrunk (horizontally) so that it displays in about 5.25" and looks like:
Word outputWhile the rest of the tables all retain their 7.5" width and the proper appearance.

Although this table is editable in Word, and the client can widen columns to get it to fit appropriately, they would prefer to focus on content, not layout (my job).

Any ideas what is causing this and how to fix it?
0
I'm running Power Bi Reporting Service 2018 Version 1.2.6648.38132

The problem I am running into is when running scheduled subscriptions, only 1 subscription can be run at a time.

When starting the subscription manually through the SQL Agent (while the other one is running), the status of the subscription goes directly to: The report server has encountered a configuration error.

I notice that the SQL Agent is starting the job, but it does not seem to trigger the Reporting Service to run the subscription. (Image attached)

Do you have any suggestions?



See the error message in the attached file.
ssrs---schedules.jpg
SQL-Agent-vs-SSRS-Job.jpg
0
I am working on a MVC project with AngularJs  and trying to download SSRS report as an excel. Am new to AngularJs.
I have tried the following codes and output is download excel with binary code!

Please correct my code, so that will download excel in exact same format as in SSRS report.

report-list.ctrl.js
(function () {
    'use strict';
    var module = angular.module('app')

        //.directive('ngConfirmClick', [
        //    function () {
        //        return {
        //            link: function (scope, element, attr) {
        //                var msg = attr.ngConfirmClick || "Are you sure?";
        //                var clickAction = attr.confirmedClick;
        //                element.bind('click', function (event) {
        //                    if (window.confirm(msg)) {
        //                        scope.$eval(clickAction)
        //                    }
        //                });
        //            }
        //        };
        //    }])

        .controller('ReportListController', ['$scope', '$http', '$q', '$interval', '$location', '$window', '$modal', '$modalStack', 'toastr', 'dataService',
            function ($scope, $http, $q, $interval, $location, $window, $modal, $modalStack, toastr, dataService) {

                $scope.showreportlist = true;
                $scope.reports = [];
                $scope.clientsessionreportData = [];


                $scope.downloadReport = function (res) {

                    

Open in new window

1
Parameter configuration in ssrs.    The dataset is configured with a normal query joining two tables.  At the end of the dataset is where i have a question.  it includes a where and "and" statement

Currently it is configured like this

Where a.rescode = ''
and a.adddttm > @conversion      -  This is a date field

How to i configure the variable to be one of the two choices instead of always Greater than  (user supplied date)


Where a.rescode = ''
and A.adddttm > @conversion

or

Where a.rescode = ''
and a.adddttm < @conversion
0
Dears,

1. can we generate 1 report from different data sources (MS SQL and Oracle)?

2. Should we propose separate HWs for reporting for better performance if many DB's are being fetched?

3. Does SSRS SW require any license ?
0
ASP.NET C#
I'm trying to view ssrs report in reportviewer in webpage
got an error
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
 pointing to this row:

 <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

Open in new window


my aspx code:

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WEB_ONE1.WebForm1" %>


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Height="484px" Width="737px">
        </rsweb:ReportViewer>
    <div>
    
    </div>
    </form>
</body>
</html>

Open in new window


my cs code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using 

Open in new window

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.