SSRS

8K

Solutions

26

Articles & Videos

5K

Contributors

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

data in SSRS shows like this as below-
Can someone please help me how to get the totals as for BB-1,BB-2 ,Ac-1 ,Ac-2 below -

Country          Type                    Names        Aug 2015    Sep 2015            ..................................... Jan 2017
US                    A                           BB-1             1000            10                                                                 100
                                                       BB-2             10                100                                                               50

US                    B                           AC-1              10               20                                                                 0
                                                      AC-2               5                  0                                                                  100

IN                    A                            BB-1             100             100                                                               20
                                                      BB-2             100              5                                                                   10

IN                    B                            AC-1              100            10                                                                50
                                                      AC-2               50              20                                      …
0
Turn Insights Into Action
Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

We are running SQL Server 2012 Standard and have configured several SSRS report subscriptions to save to a file share daily.  This typically works great but when it fails we have no way of finding this out other than checking the folder to see if the report has been generated.  

We would like to configure SSRS or the associated SQL job to email us when the report generation fails for any reason.  Is this possible?  Basically we want to get away from having to manually check for problems.
0
I have been working wtih SSRS and I like how you can create reports in the portal and even have subscriptions set up for reports to be ran automatically and emailed. Now I have a C# MVC web application I am building and I can display and run those SSRS reports. But I was trying to figure out how through my web application I could tie in maintaining and creating subscriptions to these SSRS reports so my users do not have to login and run the reports manually. I have searched the web but I have not found very good references. Any suggestions?
0
Is there a way to put comments into SSRS reports?  It would be helpful when returning to a query later to remind myself or inform others of the design of the query.
0
I am trying to create an expression that will give me the number of workdays in each month.  My table has a row for each month.  So, i am looking for a way to get the first day and last day of any given month.  Once i have that i have a function that will tell me how many workdays are between two dates.  Below is what i am using for the current month and it is working.  I just need to get this for past months.

=iif(month(today())=Fields!Month.Value, (DateDiff(DateInterval.day,DateAdd("d",-(Day(today)-1), Today),today())+1)
- (DateDiff(DateInterval.WeekOfYear,DateAdd("d",-(Day(today)-1), Today),today())*2)
- IIF(Weekday(DateAdd("d",-(Day(today)-1), Today),1) = 1,1,0)
- IIF(Weekday(DateAdd("d",-(Day(today)-1), Today),1) = 7,1,0)
- IIF(Weekday(today(),1) = 1,1,0)
- IIF(Weekday(today(),1) = 7,1,0),999)
0
I'm trying to have all dollar signs line up left aligned  (in my $amt text box)  while the values are right aligned without using 2 fields.

Here is an example:

$             6,123.00
$                     1.00
$                   12.22
$                       .35


Is there a way to do this ?
0
Hi Guys,
i have a report where i have 4 different row groups , which are child groups of each other in a Matrix report. i want to display the grouping based on parameter inputs . but when i set the visibility based on a expression in row group properties all the rows disappear in the report.
and If i try to write a expression in visibility setting of Rowgroup column properties it hides the column but then leaves a white space. I really need help to fix this issue any suggestion will be really helpful.
0
Recently I split our all staff security group into 2 different groups.  I use those security groups to grant access to SSRS reports on the web.  I added all of the same rights to the new security group and everyone in that new group can run every report but one.  It happens to be a linked report - the person will run one report first to get summary information and then they click a fund to go to a detailed report of the income and expense for that fund.  When anyone in the new security group clicks that hyperlink they get "The permissions granted to user XXX are insufficient for performing this operation".  I have checked all the security settings within the website folders and have gone back to SQL and made sure both security groups have exactly the same rights.  I don't have a clue what is wrong.   Can anyone give me some guidance?  

BTW, I moved one person back into the original security group and she could once again run the hyperlinked report.  Something must be different, but I can't find it.
0
I am trying to create a new data source in SSRS to connect to a csv file.  Below is my connection string and i am getting a "Could not find installable ISAM" error message.  I am using  OLE DB as the Data source type.

Connection String
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\SERVER\FOLDER\SUBFOLDER;Extended Properties=”text;HDR=No;FMT=Delimited”
0
I have deployed my code and its working fine on all Environment accept Test Environment and only for two pages i am getting this error (error has occurred during report processing. (rsProcessingAborted)) can you please tell me why this is happening only for 2 pages. If there is issue in the code then it should give errors for all the pages and on all Environment. But its just throwing an error for 2 pages for other its working fine. I have attached Error Log. Can you please help me.
ErrorLog.txt
0
Increase Agility with Enabled Toolchains
Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

WHY???? Once again Microsoft and their disgusting lack of personal service to customers rears its head.  Ridiculous
0
I have an SSRS report that when I view in a Report Viewer on the site 2 blank spaces are reflected.  When I export to PDF the blank spaces are not reflected.  I have looked at the source code and don't see what could be causing the spaces.  Any suggestions?

Source Code
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="CTG.aspx.vb" Inherits="Operations_CTG" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
     <ajaxToolkit:ToolkitScriptManager ID="toolkitScriptManager1" runat="server"></ajaxToolkit:ToolkitScriptManager>
  <h1>Crafted To Go (CTG)</h1>
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" 
         ValidationGroup="Run" />
  <table style="width: 100%;">
        </table>
        <table style="text-align:center;">
        <tr>
        <td><asp:TextBox ID="txbgn" runat="server">Begin Date</asp:TextBox> <ajaxtoolkit:CalendarExtender ID="txbgn_CalendarExtender" runat="server" 
        TargetControlID="txbgn"></ajaxtoolkit:CalendarExtender></td>
        <td><asp:TextBox ID="txend" runat="server" TabIndex="1">End Date</asp:TextBox>
    <ajaxtoolkit:CalendarExtender 

Open in new window

0
Hi Experts,

 How can I display the group header, on the page header of each page. I have attached the screen shot. In the page2.png, My group header is  "Chalk - Clybourn" so my page header is "Chalk - Clybourn". In the second page page3.png my group header is "test - test "  how can I make the page header the same. Actually I want the school name and its address on every page. I already set the "Keepwithgroup" to "After" and "repeatOnNewPage=true". It did not help.

 Thanks in advance.

Page1.png
Page2.png
Page3.png
0
I have deployed two SSRS reports to a web page. I have a date parameter that must be entered before the report displays. If I enter a date and press View Report, the report displays as it should. If I change the date and press View Report, the data does not change. If I press View Report again, the data changes. If I close the report and open it again and type in a different date, it gives me the last report data before I closed it. It acts like it has a copy of the old report render in memory or the parameter. In development in visual studio, it doesn't do this. I have tried editing the settings on the web page going into Manage but nothing I have done works. I have set the parameter to have no default value and it can't be NULL.

Thanks
0
I have 2 tablix's that are identical.  When they both are connected to the same dataset, the export is clean.  When I change the dataset on one of the tablix, the export is ugly.
0
I'm currently experiencing severe event log spam in a new SfB environment, consisting of two sites containing 1x FE/Edge/RP each.

the Reverse Proxy is an A10 Thunder, the Edge and FE are just generic SfB 2015 / Server 2012.

The events are exactly as described In this Technet question

An exception was encountered when sending Conference Error Report.

Conference Error Report + Exception Details.
Error = Machine:{FRONT-END-NAME}BrowserId:a10hm/1.0 Join attempted at (UTC):15/06/2017 10:47:49
Error: request context was lostException = at Microsoft.Rtc.InternalJoinLauncherTelemetryProxy.SendCERReport(JoinLauncherAsyncContext asyncContext)
 
Cause: Failed to report Conference Error Report. Please look through the exception details for more information.

Resolution: Please check if the Data collection agent is running fine & Storage Service is accepting connections.

I can see that this is caused by the A10 (likely heartbeats?), but I can't seem to find any issue that would be causing the error reports to fail.

I've tried:

  • Disabling Storage / Conferencing / Etc. Services.
  • Entirely Removing Monitoring from Topology.
  • Moving users between front-end servers.

however the errors still come in once every 5-10 seconds aprox. without fail.

there's no load balancing in place for the front-end server, and the Monitoring SQL is SQL2014.

this is a standard edition deployment, Any help would be much appreciated.
0
Guys: I have a simple sql table

Acctid | PrdSrvc1|
================
1001   | $200
1002   | $300

In SSRS how can i use the subtract function to get the value of -100  - Thx

P.S. I am using SQL Sever 2016
0
I have an ssrs report that is going out by email distribution / subscription to selected internal individuals - works great for the most part.  Recently I moved the report and subscription from a SQL / SSRS 2008 platform to a 2014 platform.  When the users were getting it within 2008 the report/email would print neatly and almost look like something was doing a 'fit to page'.  Now with 2014 the right three columns are viewable and print fine from within SSRS, but when the users print the email distributed copy the columns are truncated.  its important for the user to print the report from the email as it is a timed copy (inventory at midnight) instead of printing from within SSRS.  so what am I missing?  how come if I do the same rdl on 2008 and 2014 do the emails behave so much differently?   is there some 'fit to page' option that was set in 2008 by default and not in 2014?
0
I'm working on a stored procedure for an SSRS report and need some help converting the data type for the parameter to a list. My problem is in line 5 and 30. It's not converting the data correctly. Some sample data in r.Nombre would be the following:

Right Wall
Left Wall
Back Wall
Right Side Cabinet

@BeginDate DateTime
,@EndDate DateTime
,@StoreID  varchar (1000)
,@ItemStatus varchar (3)
,@Category nvarchar (512)

AS


SELECT			rdd.StoreID
				, rdd.TransactionDate
				, rdd.itmName
				, rdd.itmID
				, rdd.enable
				, rdd.orderquantity
				, rdd.unidadcasepack
				, st.StoreName
				, r.Nombre
		
						
FROM            RedemptionDataDetailByDay AS rdd 
						INNER JOIN Rubro AS r ON rdd.rubro = r.idrubro AND rdd.StoreID = r.StoreID 
						INNER JOIN Providers AS P ON rdd.ProviderID = P.ID AND rdd.StoreID = P.StoreID 
						INNER JOIN FiscalDatesByDay AS fd ON rdd.TransactionDate = fd.TransactionDate 
						INNER JOIN Stores AS st ON rdd.StoreID = st.StoreID
						
WHERE					rdd.StoreID IN (SELECT CAST(value as int) from dbo.ParmsToList(@StoreID,','))
						AND (rdd.TransactionDate BETWEEN @BeginDate AND @EndDate) 
						AND rdd.enable IN (SELECT CAST(value as int) from dbo.ParmsToList(@ItemStatus,','))
						AND r.Nombre IN (SELECT CAST(value as nvarchar (512)) from dbo.ParmsToList(@Category,','))
						
ORDER BY		rdd.StoreID, rdd.itmCode, rdd.TransactionDate

Open in new window

0
Get Actionable Data from Your Monitoring Solution
Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Hi all,
I have matrix in an SSRS report (2012) with the following fields....

Capture.JPG
I am trying to figure out how to sort on the Count column.  It is sorting desc on the Person_Name column.  the SQL string is ordering by COUNT DESC.

Thanks for anyone's help,
John.
0
I have the following query that I am using to build a report in SSRS. I have two issues. The first is my PriorGrandTotal for the prior year is not calculating properly. I get all 0.00. In addition I now have a need to calculate the prior year totals by month. As I am doing with the current year. I was initially helped with this query hence why I'm having a difficult time wrapping my head around it.

 WITH   ORD
          AS ( SELECT   ORD.* ,
                        IIF(ORD.ship_date > '19000101', ORD.ship_date, ORD.start_date) AS EffectiveDate ,
                        MONTH(IIF(ORD.ship_date > '19000101', ORD.ship_date, ORD.start_date)) AS EffectiveMonth
               FROM     [KLL All Order Detail With Style Data - Broken Down PPK Dtl]
                        AS ORD
               WHERE    IIF(ORD.ship_date > '19000101', ORD.ship_date, ORD.start_date) BETWEEN @BeginCancelDate
                                                              AND
                                                              @EndCancelDate
                        AND ORD.line_status IN ( 'I', 'O', 'P' )
                        AND ORD.division = 'KLL'
             )
    SELECT  ORD.customer ,
            CST.cust_name ,
            C.group_code4 AS SCALE ,
			C.group_code6 AS BRAND ,
            ORD.lbl_code ,
            Sea.seas_name ,
            SUM(IIF(EffectiveMonth = 1, ORD.Size_Qty * ORD.price - 1.0
                * IIF(ISNULL(DSC.disc_perc, 0) <> 0, ( ORD.Size_Qty
             

Open in new window

0
I have this script below which will call this report in a new tab. But since the values in the parameter has ampersand symbol, those values doesn't get picked up and the system throws an error given below. Please request your help.

="javascript:void(window.open('http://grddwmrtwhq01/ReportServer/Pages/ReportViewer.aspx?%2fDev%2fIndia%2fIndiaEngineering%2fClinical+Centers+Critical+CRs+Teamwise&rs:Command=Render&ReportParameter1=" & Replace(Join(Parameters!Dept.value,"^"),"%26amp;","&")+"&Qtr="+JOIN(Parameters!Qtr.Value,"&Qtr=") + "','_blank'))"

error message
============
The path of the item '/Dev Teamwise, Outreach Eng' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Get Online Help

--------------------------------------------------------------------------------
0
Dear Experts,

I recently migrated a SSRS 2014 system from one server to another. The migration went fine and all the reports work in the new server.

However we're facing an issue with a lot of the individual reports, as some of the images don't show because they're referenced to locations in the old server. These images are dynamic, like some logos showing depending of the customer ID selected for the report.

My question is, how can I change the image path for these logos in the reports? the images were not uploaded to the SSRS server so they're not available via URL. Instead they were referenced as "D:\Images\" or "\\Old-Server\Images\"

As I said, several of these reports are dynamic and can't have the images embedded in them.

I'd appreciate your assistance.

Regards,

Amram
0
Good Evening All - I am still learning SSRS and wanted to know how I can setup an page so the users can see all the reports they can request?  In the past I would create a form in Access with check boxes for my different reports and have some text boxes, combo boxes, and list boxes for variables to pass along to my report,  I would like to have something like that in SSRS.  Can i do this?  Or do I just create a web page that has all of my reports and a link to the report and then the users just file out the variables at the top of the page.  I would like to customize it more than this.  I do not like that I cannot format or show the control like I would like the to appear.  Seems like a step back.

TIA,
Rodger
0
Good Evening All.  Is there a way to create a form or something that I use to can pass my variable to the report or do I have to use the variable section at the top of the report.  I like that it is simple but I do not have a lot of control over it, or at least I do not know I can have control over it.  I have been creating forms in Access to pass the variables and could use VBA to make sure I got the data I needed for the report.  Now I do not see how I can do that and some of the controls do not act like I would like them to.  Drop down vs a ListBox for example.  

Are there any good site I can go to learn this. I have watched a lot on YouTube.

TIA,
Rodger
0

SSRS

8K

Solutions

26

Articles & Videos

5K

Contributors

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.