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

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
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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
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
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Hi,

I have an SSRS report that contains images that are attached to a sharepoint list but when you export the SSRS report to PDF the pdf is 31mb (six photos).

I either need the photos optimised in sharepoint or optimised when the report is being produced so that the file size is much much smaller.

I have seen code options but not sure if code in the report, code in the sharepoint list or an event handler is the best.

I have also not deployed an event handler before.

But if you print to pdf from SSRS the file will be only a few bytes.

I cannot use the SSRS print option as I am using a product called SQL-RD to produce the dynamic reports and it calls the SSRS export function.

Regards

Barry
0
Hi,

how can I hide a row if a certain column-field = "Purchase"?

BR
Daniel
0
when saving a report created with ssrs as a pdf file, is there any way to specify the name of the pdf file?
0
My SSRS emails have stopped working, I'm getting "The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user"

Can anyone give me a simple solution?
0
Good day, team

 I am working on a severe latency issue revolving around a function (below/attached) with a cursor that iterates through customers and then gets presented in an SSRS report. The function works OK provided the number of rows the cursor fetches through is relatively small. Unfortunately, one customer has a massive amount of rows and, it takes over an hour and a half to complete. I understand that the cursor may not be the most optimal route to go but, I do not have the necessary skill to replace the cursor with something more efficient. I've tried every cursor option and, of course, this did nothing. Is it possible for the experts to take a look and provide some insight? I'll get you any/all additional information as required.fnt_Get_Customer_Pricing_Summit.txt

SQL Version: Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)   Mar 19 2015 12:32:14   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)


USE [CommerceCenter]
GO
/****** Object:  UserDefinedFunction [dbo].[fnt_Get_Customer_Pricing_Summit]    Script Date: 06/05/2018 20:10:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER FUNCTION [dbo].[fnt_Get_Customer_Pricing_Summit]
( @Customer_ID as int
, @Location_ID as int
, @Item_ID as varchar(50)
, @tran_date as datetime
, @rounding as int
, @include_core_pricing as int
, @Calculate_Web_Locig as bit)

RETURNS decimal(19,4)

AS  

Begin



 …
0
I am trying to create a feature in power bi where whoever has last published this report from Power Bi Desktop his name/userid should appear. Any idea?
0
I'm trying to deploy a report from Visual Studio 2010 to a specific folder on my clients report server.  When I right click on the report and click Deploy, it gives me:
deply notesand this indicates that the report is going to the /Maestro/Adoption Reports/ folder.  But I don't see this folder listed anywhere in the properties of the report, or anywhere else.  How do I go about changing the folder the report gets deployed to?
0
Dynamics 365, SQL 2016, Windows 2016

We are trying to update SSRS reports on the D365 server with the D365 SQL datasource.  The D365 server is accessible by VPN or IFD.  Whatever we try, however, does not allow us to "Test Connection" successfully and, without changing the datasource, the reports are pointing back to the database in CRM 2011.

There is no Visual Studio on the D365 servers, is there a way to change the datasource from the IFD or connect to the report datasource through the VPN?

Thanks
0
Hi Experts,
I am trying to create a recursive SQL query for an SSRS report. I need to be able to roll up some values into the parents. However I am struggling to get the parents since it is backwards to how I would normally create a recursive hierarchy.  I usually have a parentId rather than a childId. I have created many before when there is a ParentId. I haven't had a lot of time to think about this. However when searching for an example on the internet I seem to only get examples where there is a ParentId. Please send me in the right direction with a link to an example how this might be done or tips on how I can do this. If I can generate the ParentId from the bottom up I should be ok.  
Many thanks in advance!
0
Cloud Class® Course: SQL Server Core 2016
LVL 12
Cloud Class® Course: 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.

Hi,

I am using the "iif"-function in SSRS. How is it possible to show nothing, if the logical test is wrong?

I.e.
IIf(Parameters!totaldager.Value=0,Parameters!FVDager.Value,"")

I am getting the right values if the logical test is true, but I am just getting #Error - messages if it is false.

Any suggestions are much appreciated.

Thanks
Daniel
0
Hi,

when setting a parameter I chose "allow multiple values". I took this parameter as the basis for the filter in the report, but did not manage to choose multiple values in the report. Whenever I choose more than 1 value (or "select all"), the report shows only the 1st value of the filter.

In my case (see attachment) the report is showing only the value "500".

Thank's for your help
Daniel
0
Hello,

which is the easiest way to sum expressions in SSRS?
I want to group my rows, but only the fields within the dataset sum up.

Thanks,
Daniel
0
I have created a link to a SQL report and passing a parameter that is hard coded.
The URL is working and the parameter is being passed successfully.
rs:Command=Render&username=NHC

Instead of hard coding the username I want the userID to be picked up automatically.
Then the link will work for any of my users.
0
Hi, when trying to multiply a textbox with a field in SSRS I get the following message:

Textbox96' is not declared. . It may be inaccessible due to its protection level.

Does anybody know the soultion to the problem?

Many thanks in advance.
Daniel
0
I had this question after viewing SSRS:  How to add a group header/footer to an already existing group.

Hi, there is the answer on how to add the group header/footer. Can you explain how to delete it too?
Many thanks
Daniel
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.