FAQ Database Discussion Community


How to customize the header of the CSV file that exported by a SSRS report

csv,reporting-services
I have created an SSRS report and exported that to a CSV file. The header of that CSV file displays an odd name "Donations_Chart1_CategoryGroup_label". I want to customize the name. If any one have an idea about that please let me know the solution....

Why PDF exported from Report Viewer opens in different zoom size in Adobe Reader

c#,pdf,reporting-services,reportviewer
I have 16 Reports in my current application. when I export the reports through Export drop down menu to PDF file, it saves to my local disk. But when I open the PDF through Adobe Acrobat Reader it opens it with a different zoom size for each report. Why I...

Why is certificate permission not getting applied to signed stored procedure

sql-server,stored-procedures,reporting-services,sql-server-2012
I have a rather long stored procedure that I am using to generate a dataset for an SSRS report. While I can run the report in Visual Studio using SSDT and deploy it (SQL SErver 2012), running it via report manager isn't working. It's having a problem with the dataset...

Toggle groups based on a parameter

sql,sql-server,visual-studio-2012,reporting-services,toggle
I have a reporting requirement in which I have 3 groupings Group_1 parents -> Group_4 lowest child I have a groupingID param which is an int that I'm using to show the same report either as region/div or emp/supervisor. Group_1 =totals and Group_4 = Employee and NULL for region/division. Updated...

SSDT to open existing reports on existing report server

sql-server-2008,reporting-services
I don't know how to open existing reports on existing report server using SSDT. I update my computer to SQL Server 2014 and SSDT. Previously when I used SQL Server 2008, I used Report Builder to open existing reports by connecting existing Report Server. How could I do like that...

SSRS rdlc files and SQL Server 2014 - software requirements

sql-server,reporting-services,rdlc
I can't seem to find anywhere the software requirements that need to be met in order to develop .rdlc files (Reporting->Reports Application template in Visual Studio). Is the Standard version of SQL Server 2014 sufficient or do I need to ask my employer for a Visual Studio 2013 licence as...

SSRS - Display latest value in column group

reporting-services,ssrs-2008,ssrs-2008-r2
tables - I can't post images yet, so I posted a link to the examples. I have two tables - one for sales and one for inventory. The dates in these tables are week ending dates - so the sales are totals for 1 week and the inventory is the...

report builder IIF() function with multiple TRUE value

reporting-services,ssrs-tablix,reportbuilder,iif
I'm encountering an issue while develloping some report on RB. I have a tablix that where the columns are the hours of the day, and the rows are different products. I also have a parameter with 3 values (AM, PM, NIGHT). The point here is that if the parameter is...

How to format label in ASP.net chart control

c#,asp.net,asp.net-mvc,c#-4.0,reporting-services
I have created a column chart in asp.net. I am showing the date on x-axis. At the moment the date is shown as dd/mm/yyyy. All I need is to show the date as dd-mm-yy and ideally Weekday, dd-mm-yy e.g. Monday, 12-05-15. <asp:Chart ID="Chart1" runat="server" Height="400px" Width="900px" BorderWidth = "1"> <Series>...

SSRS Report Timing out in Production Server (except after refreshing 3 times)

reporting-services,ssrs-2008
The report works fine in the DEV and QA server but when placed in Production the following error comes up: An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'Registration_of_Entity'. Timeout expired. The timeout period elapsed prior to completion of the...

SSRS int parameter passes to sub report as text

reporting-services
I'm using SSRS 2012 and I'm trying to pass an integer value (ItemKey) from my first report to a parameter (prmItemKey) in a second report that opens in a new window. The second report opens up as expected, but instead of receiving the passed value it receives the name of...

Drill through reports in SSRS

sql,reporting-services,charts,report,ssrs-2008-r2
I am making a report that takes in date parameters to filter result and shows the result in a pie-chart. I want to create a drill-through (could be drill down or any other type) where if a user clicks on a part of a pie chart which is divided by...

SSRS 2012: How do I return the most recent rows only?

sql-server,reporting-services,sql-server-2012,unique-constraint
Okay, here is my current query: SELECT pk.RxFill.PATIENT_PRICE ,PersonQuotas.QuotaYear ,PersonQuotas.QuotaMonth (and a bunch of other stuff to link them) FROM pk.RxMain INNER JOIN pk.Doctor ON pk.RxMain.PHARMACY_ID = pk.Doctor.PHARMACY_ID AND pk.RxMain.DOCTOR_ID = pk.Doctor.DOCTOR_ID INNER JOIN pk.Formula ON pk.RxMain.PHARMACY_ID = pk.Formula.PHARMACY_ID AND pk.RxMain.FORMULA_ID = pk.Formula.FORMULA_ID INNER JOIN pk.Patient ON pk.RxMain.PHARMACY_ID = pk.Patient.PHARMACY_ID...

SSRS Multi-Value Parameter Not Filtering

reporting-services,ssrs-2012
I have a few Parameters that I am trying to set based off of results that the user selects, but when I select from my Multi-Value Parameter my report errors with Failed to evaluate the FilterValues of the DataSet 'DST_MyThirdDataSet' I have my first DataSet called DST_MyFirstDataSet which is used...

Added items to a database, but SSRS report does not appear to see them

reporting-services,ssrs-2012
This is a very strange and perplexing problem I have never run across. I am working on an SSRS report that feeds off a database. I use an SSIS extraction package to append data to a table in said database. Everything seemed to work fine until the first time I...

How to set default value of Boolean parameter false in SSRS?

reporting-services,ssrs-2008,ssrs-tablix
I have 18 Boolean parameters in my report. I want to make their default value to false through expression when ever user runs the report. I am trying this but its not working =SIDIdNum.Value = "false" Getting Error: parameter SIDIdNum caontain an error [BC30451]...

Tablix in Tablix - Header not repeating

reporting-services,ssrs-2008,ssrs-tablix,ssrs-2012
I have one tablix embedded in another tablix. I cannot get the parent tablix's header to repeat when the detail table spans pages. I have tried numerous methods using the Advanced Mode's KeepWithGroup and RepearOnNewPage properties with no luck. I thought I had done this before but I don't remember...

SSRS stacked bar chart multiple series, utilizing category groups for different date fields

reporting-services,mdx,stackedbarseries,reporting-services-2012
The source data is an SSAS cube which contains information about tickets, particularly priority, date opened, and date closed. Each ticket has a priority and date opened value, though the closed value may be null or another placeholder value (subject to change). A ticket is represented by a record in...

How to make Boolean parameter disable depending on other parameter values?

reporting-services,ssrs-2008,ssrs-2008-r2
I have two text box parameter i made them Null by default. And i have one Boolean parameter. I want to make Boolean parameter disabled if the other two text box parameter are not Null.I tried this expression but don't know syntax is correct or not =iff(Parameters!CvrgEffDt.Value = "" Or...

SSRS Reporting Services, ASP Report Viewer Rendering With Large Gaps/Spaces

asp.net,sql-server,reporting-services,reportviewer
I have an ASP.Net project with a report viewer (v11) pulling remote SSRS reports from a 2008 R2 Reporting Server. The issue is when the reports are rendered in the Report Viewer control, there are large gaps/spaces between the report's charts and tables. The reports render perfectly with no gaps...

SSRS - Fields working in Data Set, but won't appear in report

sql,sql-server,reporting-services,dataset,report
I have a data set that gets its values from a stored procedure, and I'm positive that the stored proc is working correctly since I'm getting results in SQL Server. However, when I call the fields in an expression (for example, =Fields!CustomerName.Value) and preview, it just displays a blank spot...

Report Parameter validation in ssrs report

sql,sql-server,sql-server-2008,reporting-services,parameters
I have created one SSRS report having begin date and end date. If I provide end date< start date it will execute the report as shown in the image But that condition I need to show a pop up "Please Check the start date and end date provided". How to...

SSRS Hide text not text box on toggle

reporting-services,ssrs-2008-r2,ssrs-tablix
I have created a report that has a text field that is pretty substantial, and when brought into the SSRS report give a large text box. So to combat this I have created a preview field like so : and I have set the description column to hide with a...

Don't produce report if there is no data - PDF

reporting-services,report,suppress
I have a report for which there is sometimes no data to output. This report is run along with several other reports and all are then output to PDF. However, this report still produces the header and footer with a blank page even tho there is no data. I can...

Multiple subreports for each value in a field for a parameter

stored-procedures,reporting-services,ssrs-2008,report,subreport
I have a Report and a Subreport, with the Report having 30 instances of the Subreport organized to fit neatly on the page. The only parameter for the Subreport is Child and the only parameter for the Report is Parent (not the actual values but it might make it easier/more...

SSRS re-sorts data meticulously sorted from the SQL query! Why?

sql-server,sql-server-2008,sorting,reporting-services
I'm writing up a report using SQL Server Reporting Service via Visual Studio 2008. I have a stored procedure on a SQL Server database that returns a list in which I need the entry with value "F" in colulmn [Column] to be always on top, as such: F A B...

SSRS Single row for Grouping

reporting-services
I'm working with SharePoint Lists, I have 2 Lists for this issue i.e. Movies & Theatres. Only one list is used tough, because Theatres reference a movie. (I know this is weird but I'm not actually working with movies and theatres, it's just using an analogy so anyone could understand...

Setting a offset on my SQL Report with Paramters

reporting-services,bids
I'm using SQL reports for label printing and I want to be able to pass a top and left offset to the report to make float adjustments to where the data will appear on the label. I have all the data in a rectangle and I'm trying to using TopOffset...

SQL to split Comma Separated values and compare it with a multi list value in SSRS

sql-server,reporting-services,ssrs-2008-r2,ssrs-2012
I have a field in my table which has multiple reason codes concatenated in 1 column. e.g. 2 records Reason_Codes Record1: 001,002,004,009,010 Record2: 001,003,005,006 In my SSRS report the user will be searching for data using one of the above reason codes. e.g. 001 will retrieve both records. 005 will...

SSRS- repeating Tablix -Total field

reporting-services
I have a RDLC which the tablix is repeating based on a group. But I can't verify how this is been set up. But the total of the group is not correct, instead getting the over all total Say Ex: Dataset is as follows with 2 records 1 10 Sec01...

SQL inner join list split for an SSRS report

sql,tsql,reporting-services,inner-join
I have a field that lists all language descriptions that a product has and the field can contain data like: EN;FR;DE It will always be a two letter language code followed by a semi colon. I then have a stored procedure that looks for all products with a particular language...

SQL Server 2008 R2: Working with XML stored as BLOB (image data type)

sql,sql-server,xml,reporting-services,blob
A database on the MS SQL Server 2008 R2 has a column which is stored as a BLOB (has a "image" data type) . I also know that the BLOB contains XML. Is there any way for reporting services to extract this information? How would I query or use the...

Is there an API or other library available for SQL reporting services XML?

xml,reporting-services,ssrs-2008,ssrs-2008-r2,ssrs-tablix
While I do not have the full context of all that goes on in the generation of reports using SRS, I have recently been tasked with creating customized reports which are used to print labels ( a fairly daunting task, considering the ease that the designer is supposed to offer...

How to delete old subscriptions

sql-server,reporting-services,ssrs-2008
I have subscriptions which are 3 years old. I just want to delete 2 years old unused, Old and Orphan subscriptions.

SSRS Parameter using a stored procedure with a parameter

reporting-services,ssrs-2008
I have a SSRS report that pulls data using a stored procedure. Two of the parameters on this report have default values stored (i.e. Role:Student, ID:Guest) One of the parameters is a dropdown that is filled with a different stored procedure using the two parameters mentioned above. When I set...

Trying to use Switch statement in SSRS

sql,reporting-services,ssrs-2012
=Switch(Fields!CompnyID.Value=5, "company 1" "dsSalesManagement", Fields!CompnyID.Value=6, "company 2" "dsSalesManagement" ) Trying to use switch statement to display two different results in my report. Was maybe looking for syntax correction or is there a way to use an else if statement? Problem is I want this expression to be dependent on value...

Trying to SORT table on Expression

sorting,reporting-services,ssrs-2008,expression
I have two tables in my report. Grouped on fields DatePaidFinancialYear and then SupplierName. I have removed both sorts on the groups themselves. There is also no sort on the tablix. I then have a COUNT IF in one table that does the following - =Count(IIF(Fields!DaysLateCategory.Value = "Over10Days" , 1,...

SSRS ListRenderingExtension Unauthorised Exception

sql-server,reporting-services,reportviewer
I am currently using Report Viewer 11 to connect to a SQL Server 2008 r2 SSRS endpoint in order to run reports within a web page. Previously this was all working when SSRS and the DB were running on the same virtual server. We just moved the DB and SSRS...

adding date columns in SSRS Report

sql,sql-server,sql-server-2008,reporting-services
I have created one SSRS report. In the report I am providing one parameter named startDate. From the startDate I have to display 10 columns like week of dd-mon-yy. First column contains date of Monday in the week which the start date lies. then the upcoming 10 Mondays are used....

SOS! SSRS parameters show different result with SSMS

sql-server,reporting-services
I am making a SSRS report with 4 dropdown list.All of them are added in query. ID01, ID02, StartPeriod, EndPeriod. StartPeriod and EndPeriod are nvarchar, but they are showing the date. Like, 201401,201403. My problem is when I run the SSRS, if I select all of ID01 and all of...

SSIS error connecting to Excel Source

reporting-services,ssis,sql-server-2012-datatools
I have a 64 bit machine. One of my projects I have the properties of the project for Run64BitRunTime = False and I still get the following error when attaching to an Excel xlsx source in order to import into SQL 2012. Error 1 Validation error. Data Flow Task: Package1:...

Reporting Services - DateDiff function

visual-studio-2012,reporting-services
I am trying to find a way to obtain the last day of the previous month in an SSRS report that I am building (it will be in the report header), but I am running into errors that I have been unable to get around. Normally in SQL I would...

Open subreport depending on column value in SSRS

reporting-services,ssrs-2008,ssrs-2012
I have 6 possible subreports and 6 possible values in one column. I want to click on that column and open the subreport associated with that value. I found a couple places recommending this =IIf(Fields!DataType.Value = "XXX","<PATH>", IIf(Fields!DataType.Value = "YYY","<PATH>",NOTHING) With this format, It won't do anything, No clicking option...

SQL IF and ELSE block with temp tables inside

sql-server,if-statement,reporting-services,temp-tables
I got a quite big query with CTEs, temp tables and I'd like to put it into IF and ELSE blocks, for having different conditions for both of them, depend on parameter. In simplified it looks as below: DECLARE @parameter varchar(15) If(OBJECT_ID('tempdb..#table1') Is Not Null) Begin Drop Table #table1 End...

Configuring a standard single server TFS 2013 with SharePoint 2013 and SSRS for reporting

sharepoint,reporting-services,tfs,ssas,reporting
Is following scenario possible? We have got TFS 2013 installed as a standard single server. This server has got the SQL db. We have got SharePoint 2013 installed on another machine. Now we want to integrate TFS 2013 with SharePoint 2013 along with SSRS and SSAS for reports, etc. Please...

Convert integer of MYYYY into Date in ssrs

reporting-services,ssrs-2012
I have a field that is a bunch of integers formatted like so: 92014 102014 I would like to convert the field into a datetime of the first of each month. So the newly formated field would be: 9/01/2014 00:00:00 10/01/2014 00:00:00 (or however datetimes would actually get formatted). Can...

SSRS mdx report: use dimension on columns

reporting-services,mdx,olap,dimension,rdl
This simple mdx query do work in SSMS: SELECT CrossJoin({[Measures].[Qnt]}, {[Sales_step].CHILDREN}) ON COLUMNS, [City] ON ROWS FROM [SALES_PIPE] But it fails to run within Visual Studio for rdl report. An error accures: The query cannot be prepared: The query must have at least one axis. The first axis of the...

Add value of TOP (ALL) to parameter in SSRS report connecting to SSAS cube

reporting-services,ssrs-2008,ssas
I have a simple SSRS report connecting to an SSAS cube that displays all the sales by employee for a day. The report displays correctly and shows me all employees and its sales, in descending order. But the users don't want to see all the sales; they just want to...

Want to display only last 3 digits number in textbox in ssrs report

reporting-services,ssrs-2008,ssrs-2008-r2,ssrs-tablix,ssrs-2012
I am getting output from sql is like 1011153, 1011154, 101155. I want to display only last 3 digits in like 153, 154, 155 respectively. I'am using SSRS reports....

simultaneous requests time out from same browser

asp.net,sql-server,reporting-services
I have weird situation: if I launch very slow report from IE and subsequently from another tab make more requests to the database through asp.net application - they time out as if report locked the entire db. Now if I launch report through firefox - it still is slow, but...

Use web service As Datasource in CRM reporting

web-services,reporting-services,dynamics-crm-2011,ssrs-2012
I working with Reporting Service (SSRS) on CRM 2011 then I want to use Web Service as DataSource. I make simple web service that query data from CRM Database (not Filtered) then I call it's from report preview on VS2012 It's work fine but When I deploy my Report in...

QTD MDX calculated value displaying differently on SSRS than SSAS

sql-server,reporting-services,ssas
I have created an SSAS cube in SQL 2005 and included calculated members for MTD, QTD as well as YTD. With QTD measure I actually want to get the total over all 3 months of the quarter, not just the up-to-date value. Now when I browse the cube itself the...

SSRS how to show report without executing it immediately

sql,reporting-services,rdl
So, the problem is that report on SSRS is executing immediately after opening. I use query based default parameters.. And i saw the solution with adding additional parameter without default value. It doesn't work for me because of the textbox which cannot be hidden (i tried to hide it and...

SSRS Average Time in Minutes and then Format to HH MM

sql,stored-procedures,reporting-services,formatting
I've seen a lot of questions about average time in SSRS but I'm pretty new to this and none of these questions address my specific need so any help would be appreciated. I have a duration field (Fields!Duration1.Value) which is pulling in a duration in minutes (example: 170). In my...

Dynamically Add\Remove columns SSRS 2012

reporting-services,ssrs-2012
I have SSRS report that has around 80+ columns. I have requirement where in dynamically hide\show columns in report based on user selection. I could able to do it by setting expression for "Visiblity" property and having report parameter thro' which columns to display can be choosen. My problem is...

SSRS Not Printing All Records for Dataset, but Counts Them

reporting-services,output,ssms
I have an SSRS report (see image) that looks for open discipline reports. When I run the SSRS Dataset query from SSMS, it outputs 19 records. When I print it through SSRS it only outputs 17 records, but shows a total count of 19. In the image below I've shown...

Sum Grouped Data in SSRS

reporting-services,ssrs-2008,ssrs-2008-r2
I want to SUM grouped data in a report but can't figure out a way to do it. My data looks something like this: I am trying to get value 4 in Grand Total which would show the number of orders on different schedules. Simple count would count all the...

Restart or no Restart after config file change

sql-server,reporting-services,dynamics-crm,crm
I have to make a small change to a SQL server config file (http://www.msbicoe.com/post/2013/05/06/SSRS-2012-Report-Server-cannot-load-the-TERADATASQLPDW-Extension-Error.aspx). Do I need to restart the server in order for the changes to be made or will it be fine without? Determines if I have to wait till an appropriate time to take the server down...

How to repeat Left Most rows for a group in SSRS report

reporting-services,ssrs-2008,ssrs-2008-r2,ssrs-tablix
I have an SSRS Report which is having groups. I need left most rows to be repeated in the tablix for the group. Example: Original Report is like below Country Region Category Total ------------------------------------------ Group Total 1000 Product 1 200 USA NORTH Product 2 300 Product 3 300 Product 4...

SSRS Date column sorting

sql,sql-server,sorting,reporting-services,ssrs-2008-r2
I have a SSRS 2008 R2 tablix which displays like this : _____________________________ | | Date | |_____________________________| | Row1 | | | Row2 | | | Row3 | | |_______________|_____________| The Date displays data in YYYY/mmm format (2015/01 , 2015/02, 2015/03). This column has a grouping on it (column...

Integrate SSRS with AngularJS?

.net,angularjs,reporting-services
I have a project, the frontend is using pure HTML5/AngularJS, webservice is using .NET, and report is SSRS. I have a major problem of displaying SSRS reports on frontend. We tried to embed the report in an iFrame but it pops credentials always, so it is not practical. I want...

Why rsAccessDenied error on SSRS when using Chrome but not in IE

sql-server,reporting-services,permissions,active-directory,ssrs-2008
I am trying to identify reason why SSRS service URL throws an exception when using Chrome while not with IE. I tried running both of them with Administrative account. http://xyz-shantanug/Reports/Pages/Folder.aspx User 'Domain\userName' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC)...

SSIS package data flow tasks report

reporting-services,ssis,etl
We have many SSIS packages that move, import, export around large amount of data. What is the best way to get alerts or notifications if expected amount of data is not processed? or How to get daily report on how different SSIS packages are functioning. Is there a way to...

Sum a value in SSRS Reports based on date range

date,reporting-services,sum,range
I'm trying to sum a field value in an SSRS report based on a date range field in the same dataset, but have had no luck. So far this is what I've come up with. I've scoured the forums with no luck. Any help would be greatly appreciated. = sum(...

Dynamically Set the to Address in SSRS reports Subscription

reporting-services,ssrs-2012
I show a list of items with a field Assigned to, which are email addresses. Right now I have set up a subscription with distinct list of assigned to email addresses and sent the entire items list to all the users. I want to sent only the items assigned to...

SSRS: How to restore a deleted title in a chart

reporting-services,ssrs-2012
I made some charts and deleted the titles. I decided that was the wrong thing to do and want to put them back. Is there any way to do this that doesn't involve redoing the chart?

MVC5 & SSRS ReportViewer - How to Implement?

c#,asp.net,asp.net-mvc,reporting-services
I have spent hours trying to solve this and so far I can find MVC1, MVC2, and MVC3 based solutions but nothing about MVC5 and using SSRS and ReportViewer. Frankly, I don't know WebForms, since I joined the programming world after MVC was a big thing in the shop I...

Level function not working

reporting-services,ssrs-2008-r2
I have a table with a row group hierarchy and I would like to be able to control the indentation amount based on the group level. There are other things I need to be able to do programmatically using this information as well. The Level() function in SSRS seems straightforward....

Error: Query with id 'DAXSecurityUsersAndRoles' does not exist. How to resolve this?

reporting-services,microsoft-dynamics,dynamics-ax-2012,ssrs-2012,dynamics-ax-2012-r3
I am trying to run a report in Dynamics AX "Menu/Sys Admin/Reports/Security/Roles and Users Attached List" which is throwing me below error Query with id 'DAXSecurityUsersAndRoles' does not exist. Anybody faced this before? What to do to fix this?...

Multi select parameter default set by previous multi select parameter

reporting-services,parameters,multi-select
I have a report with several parameters, all in varying degrees depending on the value of its predecessors. I’m trying to convert from single selects to multi-selects. I’ve set the multiselect values for Report Type – see image – and would like to set the default value for the multiselect...

SSRS Color Expression Lesser than X

reporting-services
I have a table that handles stock, I have the data outputting in to a table in SSRS so I can see stock levels. like so: PartNumber, PartDescription, Qty I can use =IIF (Fields!Qty.Value < 40, "red", "teal") on the quantity field to set a threshold within the table but...

PercentOfSum(fld, condfld) SSRS Equivalent

function,reporting-services,crystal-reports,ssrs-2008,ssrs-2008-r2
Crystal Reports has a built-in function PercentOfSum(fld, condfld) (documentation here). How can I achieve the same functionality in SSRS?

Hide parameters from SSRS Report when it Renders inside an iframe

reporting-services,ssrs-2008,ssrs-2008-r2
I have go through this question about the same topic in stack overflow but i did not get any accurate answers from the same that is why i have ask the question again enter link description here I havce created a ssrs report and i have render it in an...

SSRS 2012 Shared SQL DataSource throws error on other workstations

visual-studio-2013,reporting-services,tfs,ssrs-2012
I'm having a bizarre issue with SSRS 2012 reports, specifically with SQL Shared Data Sources. My reproduction steps are as follows: Create a new shared data source called Test, pointing to a SQL server on the network. Test credentials, get a successful test. Create a new report called Test, not...

SSRS - Counting Correct Answers and Calculating Percentages via Comparison Fails

reporting-services
This is my first time using SSRS, so be gentle! I'm working on a report where I want to compare the number of correct answers to the number of all user answers for a group. The group repeats and looks set up okay, so that part isn't a worry. It's...

Format Numbers in Multiple columns of SSRS Report

reporting-services,sql-server-2012,ssrs-2008
Currently I am working on a ssrs report. The table in report is having about 30 columns. For each column I have to modify the number format (to either 2 decimal or no decimal numbers). I can do it by click on every column and modify the number property in...

“add data driven subscription” missing in SSRS sharepoint mode

sharepoint,reporting-services,sharepoint-2013,ssrs-2012
I'm using sharepoint 2013 with SQL server 2012 Enterprise Edition SP2. I am using SSRS in sharepoint integrated mode. When I hover over report options I see the "Manage Subscriptions" option and when I click it I can see the "add subscription" option. However, the "add data driven subscription" is...

SQL Server 2008 R2 - store top result and use in SSRS

tsql,reporting-services,sql-server-2008-r2,temp-tables
I have a SSRS Report that displays the total number of days lapsed since a complaint was received. This SQL Query is the difference between today's date and date of the last received complaint. SELECT DATEDIFF(day, MAX(complaints.ComplaintReceived1Date),CURRENT_TIMESTAMP) as total FROM complaints WITH (nolock) If for example this is set to...

Change visual design on the SQL Report Viewer

sql,reporting-services,ssrs-2012,reporting-services-2012
How do I change the visual design on SQL report viewer? And when I say report viewer I mean the hosting webpage, not the report itself.

Cannot add new shared dataset to report

visual-studio-2013,reporting-services,sql-server-2008-r2,ssrs-2008-r2
I have a summary report with about 20 datasets, linking to 20 detail sub-reports. I have added datasets based on stored procedures for each of the detail reports. Now when I try to add another one I get an error message Could not create a list of fields for the...

Role assignments in SSRS

sql-server,reporting-services,permissions,ssrs-2008,user-permissions
I have created a SSRS report. In the report viewer I saw 2 security sections site settings folder settings. What is the difference between these two? I have to give access to 2 types of users Somebody having permission just only for viewing report. Somebody having permissions to view reports,...

SSRS Get first Item LookUpSet

reporting-services
So I have a dataset which contains a list of dates and foreign keys. Now I need to get the first date for a certain foreign key. I have tried the expression below: =First(LookUpSet(Fields!Title.Value, Fields!Linked_Study.Value, Fields!Subject_Enrollment_Date.Value, "FPI")) But it just returns #Error. Does anyone know why this expression doesn't work...

Top to bottom sorting in multi page column RDL reports

reporting-services,rdlc
I'm trying to get a report to flow a list of sorted values in a multi-column tablix (see example). I can get it to flow left to right like this: Item 1 Item 2 Item 3 Item 4 etc. but need it to flow top-bottom, left-right per page. Any help...

SSRS Row Gropings Inverted (Export to Excel)

sql,excel,reporting-services,grouping,ssrs-grouping
When i run my report my report in SSRS all groupings work correctly however when i export this report to excel the proper rows are grouped but the grouping is inverted (i.e. the last item in the grouping has the '+' sign instead of the parent, top row) thanks for...

SQL Agent Job Not Running all the steps

sql-server,reporting-services,sql-agent-job
I have a SQL Agent job that is supposed to suppress jobs from running in the event that there is a HOLIDAYCD in another table for the given day. It is running and it is executing the first exec, but the rest are not running. Here is the code: IF...

Previous Date SSRS Fix

sql,date,reporting-services,switch-statement
Trying to solve issue with SSRS not showing proper end dates for certain months (i.e. it shows 30th for april fine, then shows 30th for march and then 28th for feb as well as 28th for jan, etc, etc). I have a report that has a "button" that goes back...

Switch statement - comparing zero value

reporting-services
I currently have two text box. One is to display the first value in my column called principal. The second textbox is to display a text, if the value is equal to zero, display "The principal is zero" else display "The Principal value is not zero". X being the principal...

Sorting Row In SSRS

reporting-services,ssrs-2008,ssrs-2008-r2
I am trying to get the "Total" row of a report in SSRS to stay put at the buttom but all to no availed. My Total field is being calculated from a query like so: Select A , B , C FROM D UNION SELECT 'Totals' , SUM(B) , SUM(C)...

WHERE clause on a field that was calculated with a CASE --SQL Server

sql-server,reporting-services
In this query I'm writing for an SSRS rpt, I am changing NULL to read 'Unclassified' using a CASE And then I want to filter by the multi-select parameter (@Channel) that will include "Unclassified". SELECT Top (Convert(int,@CustNum)) A ,B ,C ,CASE WHEN CH.Channel IS NULL THEN 'Unclassified' ELSE CH.Channel END...

SSRS Report Viewer Toolbar Broken

reporting-services,ssrs-2008-r2
I have just noticed that the toolbar in SSRS (with the page numbers, save/print etc) is slightly askew (see image). After doing some testing, this only happens when accessing a report using the server's FQDN (http://reports.domain.com/Reports/). If I use the netbios/short url (http://reports/Reports/) it works fine - can anyone guess...

Sharepoint RDL report referring a new cube in the SSAS DB fails to execute the query to a shared data source

sharepoint,reporting-services,datasource,cube,rdl
A shared data source, already present in our SharePoint server, - works fine for other old reports, which refer old Cube in the same Analysis Services DB. I don't get, why this new SSRS report using new Cube in the same initial catalog on the same server does not work...

Multiple Datasets in one Table OR show distinct Value in Table (SSRS)

mysql,reporting-services,sum,aggregate-functions
I am fairly new to SSRS and currently I'm working on building my first reports. I encounter some problems with a report that in my opinion should be fairly easy, but so far I couln't find the right answer. I have a table similar to this: Material - - Date...

How to insert excel formula to cell in Report Builder 3.0

sql-server,excel,reporting-services,excel-formula,ssrs-2008-r2
There is RDL report template for SQL Server Reporting Services. I need to set value for cell in table in the report template which must be calculated from other values in the report. When the report is exported to Excel file I need to see the Excel formula in that...

Where does the syntax for expressions in SSRS come from?

reporting-services,syntax
The syntax for the expressions in SSRS seem to be very different to the other products that Microsoft produces. For example, I am not aware of any other tool that uses IIF() for an if statement and using 'is nothing' to assess if value is NULL. Is there any history...

Fields missing in result set

sql-server,reporting-services
After executing this procedure, in my result set, I got only 2 fields, I could not trace out the bug. I got only Sl No and TypeofDocument in my resultset My code: IF OBJECT_ID('PrGetDetails') IS NOT NULL DROP PROCEDURE PrGetDetails GO CREATE PROCEDURE PrGetDetails AS BEGIN SET NOCOUNT ON; DECLARE...

SSRS Multi-series Chart

reporting-services,ssrs-2012
I have a requirement as below. I need to show the number of clients in a chart based on their income and age group. X-axis -> <10k <20k <50k <100k <200k+ Y-axis -> Age Group(20-30, 31-40, 41-50, 51+ The chart should show count of clients who falls on income and...

How do you create a boarder in an SSRS Report?

reporting-services,group-by,border,hidden,row-number
I've gotten the hang of creating charts/colors and grouping data but I can't seem to figure out how to outline each grouping in my report. I've got data built for my chart - what I would like to have it appear as -- is like this: I'm not picky on...

Using Cutsom Colors For Charts and Tablix in SSRS

reporting-services,ssrs-2008-r2
So I have been tasked with creating this. I have the charts in the tablix and I have created a custom pallete that is not implemented yet, this is just the sea green pallete, but I need to color the rectangles in the description so they match the charts like...

SSRS - Group By Multiple Values

sql,sql-server,sql-server-2008,reporting-services
I am trying to group by specific values of a field. I have project information data populating, and I would like to group on electoral area field. However, I would like to group the values together in a specific way. For example: If the values are: District of Invermere, City...

SSRS cascading parameters: child parameters' default 'All' value drops to blank after user changes parent parameter

reporting-services,parameters,mdx,rdl,cascading
I have a big bunch of cascading parameters in my rdl report with default value 'All' everywhere. But all children go blank after user changes some parent parameter, and then he has to choose 'All' value from drop-down list for each of child parameters manually. This is pretty annoying staff....