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

Visual Studio 2010

I have an SSRS report that looks like:2018-08-30-Contact-Overlap-Repeat-He.jpgThe report is correctly grouping on Program and County and each new occurance is going to a new page.
But I cannot seem to get any of the column headers (the yellow is hidden in the report view)  to repeat on new pages.

I've tried various combinations of Group Properties and "static" properties but cannot seem to get this right.
Any help would be greatly appreciated.
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.

I have an SSRS report that in design view looks like:contact overlapand in report view looks like:with dataWhat I would like to do is reformat this so that the Program Name and County show up on the same line, and the Staff Name value would show up right below (not offset) the Program and County.

I assume I can modify my group to group on both ProgramName and CountyName, but how would I reformat this so that the Staff name falls immediately below the Primary Group heading?
0
How do I  get current logged in user to be used as parameter in a report so I can implement row level security on dataset?
0
ReportServer Subscriptions -- We migrated ReportServer to ReportServerNEW with a simple backup/restore -- on the SAME server.  When we restored ReportServerNEW, we also used the encryption key from the source ReportServer instance, and all reports are accessible now in the new SSRS instance, Report Manager.  

But -- what about the subscriptions?  How do I know they are good?  They may be fine, because I used the steps outlined here for the move:
   https://docs.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-2017

WHERE it says:    "Subscriptions, cached reports, and snapshots are preserved in the moved database. If a snapshot is not picking up refreshed data after the database is moved, clear the snapshot options in Report Manager, click Apply to save your changes, re-create the schedule, and click Apply again to save your changes."

I just don't know how to confirm.  What is the right way to confirm that the subscriptions are all scheduled/enabled/on in the new instance, after migrating the ReportServer database?
0
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
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 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
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
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
Angular Fundamentals
LVL 12
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

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
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
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 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
Hi Expert,

I just in place upgarde SQL Server 2014 to 2017. While upgrading SSRS was uninsatalled. How do i upgrade SSRS to 2017? Do i have to installed newly SSRS for 2017 and then restored the SSRS db backup.

Thanks

Zahid
0
I am importing a report into Excel (generated by SSRS).

Some fields contain:  "0.0000000000000000" which causes Excel to store that value as text.

This scenario happens in hundreds of reports with many fields so changing the source isn't easy.

I was hoping to find a solution (maybe a macro) or technique which would enable to bulk convert that to a numeric 0 value.

I'm not loving some of the techniques (like multiplying by 1).

The cells are not contiguous and some of the worksheets are huge.

Any ideas?

-Mike
0
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

how to see description of a table in ms sql databasde to see which columns there, which is primary key, which is forign key which are indexed columns etc

please advise
0
Hi,

i have parameters with values 1, 2 and 3. I would like to define the in such a way that the possible choices appear the following way:
"East" (if parameter = 1)
"South" (if parameter = 2)
"North" (if parameter = 3)
0
Hi Experts,

I am having trouble getting a report to show just the parent and child on only the last leaf nodes on a uneven structure. How would I group a report so that only the last nodes are grouped by the parent. Sometimes the parent might be at level 3, 4, 5 or 6. Is there a way so that I only group the parent with the leaf nodes?

Any links to other examples would be great!

Thanks!
0
Hi, I've got an ASP.NET project which includes a report (main.rdlc). This report has a sub-report (mySubReport.rldc). Both are set as embedded resources in their properties.
The report runs fine but the subreport does not show up. It comes with the message, on the report itself:


The subreport 'subreport1' could not be found at the specific location /Project_Name Reports/mySubReport. Please verify that the subreport has been published and the name is correct.

Also, when I check the outputwindow I can see the following warning:


Warning: An error occurred while executing the subreport 'Subreport1' (Instance: 0): The report definition for report 'mySubReport' has not been specified (rsErrorExecutingSubreport)



  protected void btnReport_Click(object sender, EventArgs e)
        {
            Warning[] warnings;
            string[] streamIds;
            string mimeType = string.Empty;
            string encoding = string.Empty;
            string extension = string.Empty;

           

            var cnn = new SqlConnection(Global.conString);

            ReportViewer viewer = new ReportViewer();
            viewer.ProcessingMode = ProcessingMode.Local;
  
            viewer.LocalReport.ReportPath = "Reports/Main.rdlc";
            viewer.LocalReport.EnableExternalImages = true;

            
            // viewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(addsubreport);

           
 	     

Open in new window

0
Good morning Team,

  This is directly related to a recently answered question here on EE (https://www.experts-exchange.com/questions/29103154/SQL-2008R2-Cursor-in-Function-Very-Slow.html#a42593407). Both Mark Wills and Scott Pletcher successfully resolved my issue related to a cursor in a scalar function however, the next level is now posing a bit of a challenge, as the scalar was converted to an inline table function and, SSRS report builder is prompting me to enter parameters BEFORE I try to run the report (meaning, before the actual page where a user would actually enter the parameters - it wants them once I change and save the query in the dataset). --- This part is fixed - Now, it's SSRS taking a very long time to render the report!


Previous Select Statement - no prompt to enter parameters -  (line in bold letters is what has been replaced):


select
Manf.vendor_name as Manufacturer
,convert(varchar(10),getdate(),101) as Process_date
,Mast.Item_id
,Mast.Item_Desc
,Mast.sales_pricing_unit
,Mast.sales_pricing_unit_size
/*,Mast.supplier_part_no*/
,supp.supplier_part_no
,case when sales_pricing_unit_size <> purchase_pricing_unit_size then
 mast.List_Price * sales_pricing_unit_size
 else mast.List_Price
 end as export_List_Price
,mast.inv_mast_uid
, dbo.fnt_Get_Customer_Pricing_Herman(@customerID,'100002',Mast.Item_id,getdate(),4,1,0) as CustPrice
, 'N' as Serialized
, @vendorNo as VendorNum
from vHerman_inv_Mast as Mast
inner …
0
I have the same problem as mentioned. Can you please provide me with a solution
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.