FAQ Database Discussion Community


How to get overall total in row group

reporting-services,ssrs-2008,ssrs-grouping
I have a row group in SSRS that calculates totals by each group. However, I would like to get the percentage of each group out of the overall total. However, I do not know how to achieve getting the overall total to work within the same expression. Right now I...

How to set Superscript in a TextBox in RDLC

c#,textbox,ssrs-2008,rdlc,superscript
I am trying to Superscript in a TextBox in RDLC and not getting any solution, to avoid this, I am using two text boxes one for main text and other for Superscript, and I am setting small font size to Superscript, may be RDLC have built-in function or formatting for...

Blank Multiple Valued Parameter in SSRS

reporting-services,ssrs-2008
I have several multiple valued parameters in my report. I don't want the user to select these parameters each time. These additional parameters need to be optional because there are other parameters needed in the report. Is there a way to make the Multiple Valued Parameters optional or Blank and...

Query Designer in Visual studio returns column and ssrs text box returns #Error

visual-studio,reporting-services,ssrs-2008,type-conversion,crystal-reports-2008
I have several columns selected in my dataset. Some of which have GROUP_CONCAT like below where the separator is a line break. SELECT column1, GROUP_CONCAT(table.table_column2 SEPARATOR "\n") AS column2 FROM table the result for column2 in the Query Designer of the dataset gives the word Binary surrounded by chevrons and...

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...

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...

Filter main group members based on subgroup content in reporting services

ssrs-2008,reporting
In reporting services 2008 I have a filter grouping problem. I want to remove some of the entries in the main group based on certain combinations of subgroup value. I can make an expression that shows true when a combination is within the group or the inverse, but if I...

SSRS Parameter that selects on days of the week within the date range

sql-server-2008,tsql,reporting-services,parameters,ssrs-2008
I have a report that runs embedded SQL that uses a simple @startDate and @endDate parameter and the variables in a WHERE clause: And DM.FromDateTime Between @startDate AND @endDate What I would like to accomplish is to have an additional parameter that would return only the day of the week...

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 expression - If null value then return 0 instead of blank

reporting-services,ssrs-2008
I've seen a few examples but I just can't figure it out for my case. My expressions sums all values from field Total from the dataset AutoDeliveryCount. I need to reference the dataset since I'm using a few Total fields in my report. If the stored procedure returns null, how...

Getting group to show on every line

reporting-services,ssrs-2008
I have a report with two groups: The report Design looks like this: This produces a report that looks like this: I am wondering how I can have the process (Anodize) show on every line within the division.I cannot get rid of the groups because this is a summary report,...

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...

SSRS conditional formatting (Using AND and OR)

algorithm,reporting-services,ssrs-2008,conditional-formatting,iif
I have a question regarding a complicated conditional formatting that I currently trying to put in place. The code is: =iif(Fields!ACT.Value = "N/V", "No Color", iif(Fields!ACT.Value = "N/K", "No Color", iif(Fields!ACT.Value = "N/A", "No Color", iif(Fields!NUM.Value < Fields!SHORT.Value , "Yellow", iif(Fields!NUM.Value > Fields!INC.Value, "Orange", iif((isnothing(Fields!ACT.Value <> "N/A" and Fields!NUM.Value) or...

SSRS Where can I place sub reports?

reporting-services,ssrs-2008,ssrs-tablix,ssrs-grouping,subreports
This is not the greatest question, but I have goggled and hunted and pecked for several days and have not found the solution. Where within a SSRS report can a sub-report be placed? Are there any locations that it might seam invisible or be hard to find? I have created...

Find Mondays between 2 dates

sql-server,sql-server-2008,ssrs-2008
I need to display dates of all Mondays in the given date range. For example, if my start date is 01/05/2015 and end date is 31/05/2015, I need to show 04/05/2015 11/05/2015 18/05/2015 25/05/2015 How is it possible?...

Adding Multiple Trend Lines - SSRS 2008R2

reporting-services,ssrs-2008,ssrs-2008-r2
I need to add multiple trend lines to this chart. See below. http://imgur.com/cI4fnPr&bO4OkJo This what I have currently. In this sample, there should be a Blue trend line and a Gold trend line. I cannot find any way to do this without removing the x-axis grouping. If I do that,...

SSRS Expression still returns a count for all fields

reporting-services,ssrs-2008,expression
Would anyone be able to help me with my SSRS expression? It seems to be returning a count for all records even though I have certain requirements in my iif function. Here is what I currently have: =Count(Iif((Fields!METHOD.Value = "Something") AND (Fields!CATEGORIZATION.Value = "Incident") AND (Fields!SOURCE.Value = "Phone"), Fields!MONTH.Value =...

What control should I use for getting the following rows in ssrs?

sql-server,ssrs-2008
I am to design a report which will be having given rows, I have tried with Tablex and Matrix, but I am facing issue with grouping. Is there any other control or any custom control or any way of customizing Table which I can use to design the following formatted...

Export SSRS Reports in Word has multi language

ssrs-2008
i have one SSRS Reports that has multi language text in texboxes. Arabic-english. when i Export report in pdf orexcel eveything is ok. but when Export to Word word of text revese (english part). like this: PDF: میزان غلظت PDW در Word: میزان غلظت WDP در ...

Using Expression to Hide Certain Data in SSRS

ssrs-2008,expression
I'm trying to hide/suppress data using an expression for Row Visibility in SSRS. I currently have an expression: =IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,False) That hides certain data I do not want to appear, but I would like to add an additional field to hide as well. I tried adding an additional...

Replace Null value with string in ssrs expression

reporting-services,ssrs-2008,ssrs-grouping
I have a row group of STATUS fields. There is a group that returns null that I would like to change to chat. I have tried: =Iif(IsNothing(Fields!STATUS.Value), "Chat", Fields!STATUS.Value) but the group still returns blank. Would anyone have any ideas on how to help me resolve this?...

SSRS. Customizing tablix. Different number of columns on each row

sql-server,table,reporting-services,ssrs-2008,ssrs-2012
I need to customize my table (I don't know why It's called Tablix). On each row I need to make different number of columns. What I mean. Here is how my table(tablix) looks like now: Here how It should be: On first 2 rows here should be 4 columns, in...

Report is not loading when using parameters

reporting-services,ssrs-2008,report
I have created a ssrs report and uploaded it in reportserver which is working fine. Then I have added 4 parameters to the same report. It works fine in my local machine,But not working when uploaded to report server. Is it because of any permission issues?

SSRS Subscription error “An error occurred during rendering of the report”

reporting-services,ssrs-2008
When i subscribe report with xls format it complete successfully but when i subscribe report with xlsx then above error occur. i am not understanding problem help me.. i am using sql server 2008 R2. An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering...

Unwanted page break in SSRS report

ssrs-2008
I have an RDL report built in Business Intelligence Studio 2008 and I am having an issue with an unwanted page break. I have a single dataset with a singletable with some summed data. I have added in a List and added two groups. I have even checked the page...

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...

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...

SSRS Expression To Remove Leading 0 In Date

datetime,ssrs-2008,expression
My report displays the date time as "Friday, May 08, 2015" but I'd like to remove the 0 in the date field if the value is a single digit. Should I use an expression to handle this? And if so, could I get some help on the expression? Thanks,...

How to Configure a Multi-value Parameter in SSRS to also not pass any values

variables,reporting-services,parameters,ssrs-2008
I am trying to create a parameter that filters on a certain field, but to also not work (for lack of a better term or be blank/NULL) if the user does not want to select a filter. The SSRS report shows the summary of an event. Some events have equipment...

Background Color Not Filling in Entire Row Based off Expression in SSRS

ssrs-2008,expression,visibility
I was hoping I could get some help on this issue. Got a report that displays data for events; of which we have two types: fixed and mobile. To fill in the row based off what type the event is, I used this expression: =IIF(Fields!OwnerType.Value = "Fixed", "LightSteelBlue", "#FFFFFF") But...

SSRS: Action on click tablix fields

reporting-services,ssrs-2008,bids
Given a tablix on a ssrs report is it possible to vahe the "Action" property of a cell (Text Box properties >>> Action) to change depending of the value in that field. To pe more explicit If the tablix's dataset return eg 5 rows I want a different action on...

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,...

LIKE operator in SSRS row visibility expression

reporting-services,textbox,ssrs-2008,visibility,like-operator
I have a text box within an rdl report which I want to suppress based on certain terms in my dataset (i.e. if the query returns a term which ends with the letter "L" then hide the text box). Within the textbox properties I have set visibility expression for Hidden...

Display Report Contents Where Column A Equal B in SSRS

ssrs-2008,ssrs-2012
From the image above, I want viewers of my SSRS report to see data where PaymentFound column is equal to 'N' without limiting it in my T-Sql query and without hiding any column in my report. How do I achieve this in SSRS?...

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...

How to create an interval in a matrix

reporting-services,ssrs-2008,mdx,ssrs-grouping
I am working with SSRS 2008, my source is a cube and I use this MDX query: SELECT NON EMPTY { [Measures].[Val] } ON COLUMNS, NON EMPTY { ([DimCl].[Cl].[Cl].ALLMEMBERS, [DDate].[Year].[Year].ALLMEMBERS ) } ON ROWS FROM [DW] I created a matrix with the following data 2014 2015 0 10 11 1...

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 - Returning the average where date is 2015

reporting-services,ssrs-2008,ssrs-2008-r2
I have been trying to figure this out for a while now and just couldn't find the answer anywhere. I have a report in SSRS with a column group assigned to "Year", this column expands depending on what parameter the user enters into StartYear. If the user enters "2013" the...

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?

Coloring a TextBox in SSRS

sql,sql-server,reporting-services,ssrs-2008,ssrs-tablix
I have a table in my report and want to color my Header which is a textbox. Coloring must be conditional and i am having problem in writing expression. right now i am using Switch(Fields!Value.Value="196","GREEN",Fields!Value.Value="197","GRAY",Fields!Value.Value="194","RED",Fields!Value.Value="195","RED",Fields!Value.Value="193","RED") and there are 4 ROWS in the table with following values 197 197 197 196...

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)...

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...

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)...

Referring to ReportItem properties in SSRS

reporting-services,ssrs-2008
In an SSRS report expression, is there any way to refer to the "Hidden" property of a ReportItem? More specifically: my SSRS report consists of a summary, with a subreport containing detail. I'd like to be able to stop the subreport running if it's hidden, as in this question. The...

Can I allow the user to specify the order of static columns in SSRS tablix?

sql-server,reporting-services,ssrs-2008
I have a report in SSRS 2008 (not R2) with a table of up to around 30 columns that are displayed dynamically based on an input parameter. I've been asked to allow the user to choose the order in which the columns are displayed. We have done something similar for...

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...

Summing Only Visible Rows in SSRS

ssrs-2008,aggregate,visibility,ssrs-tablix
I'm trying to sum only the visible rows for a report and I know the format is: =Sum( iif( <use the condition of the Visibility.Hidden expression>, 0, Fields!A.Value)) In my report, I've set row visbility to: =IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,False) Not exactly sure what I'm missing, but when I use...

Change font color for a row when the value is one specific value

formatting,ssrs-2008,bids
I'm trying to change the font color on complete row when a value. I found the question and answer for changing the font color on a particular cell on another post here. This was part of the other answer: =IIF(Fields!Registrations.Value <> Previous(Fields!Registrations.Value), "Black", "Blue") but it won't do what I...

Concatenating Row Values in SSRS?

sql-server-2008,ssrs-2008,concatenation
I'm trying to concatenate a particular record into one field to avoid multiple rows for the record. The issue is that a drive may contain multiple shifts in which each shift may be assigned a different vehicle. Screenshot below shows what is happening: Both records show the same drive, but...

SSRS report from XML data source / Object reference not set to an instance of an object

sql-server,reporting-services,ssrs-2008
I'm trying to do a SSRS report based from XML file with SQL Server / BIDS 2008. I have never tried this before, so most likely it's just something stupid that I have missed. I tried to do it based on these examples: https://technet.microsoft.com/en-us/library/aa964129%28v=sql.90%29.aspx My XML is really simple: <Customers>...

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...

How to change Parameter format from DD/MM/YYY HH:MM;SS to DD/MM/YYYY

sql,reporting-services,ssrs-2008,ssrs-2012
I have a parameter uploadedDate (Data type-Date/time) (Drop down Parameter where i can select a particular date of that records) which gets available values from query. My issue here is while i executing that query in sql its shows only date. But when i use that in parameter(UploadedDate) it giving...

Report is not loading

sql-server-2008,reporting-services,ssrs-2008,sql-server-2012-datatools,reportserver
I have created one report with 4 parameters. one of the parameters having greater than 1000 item values.I have following issues Reporting Services don't show data after selecting parameters Reporting services displays blank page Report is working fine in Visual Studio Preview mode, but not on Report Server web server...

Issue with datediff when used in iif in ssrs

reporting-services,ssrs-2008
I'm coming across strange behavior while evaluating expression in ssrs. =IIF(Fields!LeadcreatedOn_createdonValue.Value is nothing OR Fields!createdonValue.Value is nothing,0,DateDiff("d",Format(Fields!LeadcreatedOn_createdonValue.Value,"MM/dd/yyyy"),Format(Fields!createdonValue.Value,"MM/dd/yyyy"))) When both fields has date value datediff works fine and difference is displayed but if one of the fields is empty instead of showing 0 it results in #error. When I tried display...

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 2008/2012 - ADDING AGGREGATION FIELDS

sql,sql-server,ssrs-2008,ssrs-tablix,ssrs-2012
I'm attempting to add a field to an SSRS report based on 2 other displayed fields. I'm using a matrix report Field One is a Count of Account numbers the Second Field is an Order Amount My Attempt New_field=(Sum(Amount))/(Count(Account)) What is the best way to do this in SSRS. Because...

overlapping issues SSRS

reporting-services,ssrs-2008,ssrs-2008-r2,ssrs-2012
Every expression is left align, I don't know why some labels are overlap and have more space. see pic 2, label cancer within 5 years is overlap with expression. see pic 3, output for unresponsive state has more space than output 1 How do I fix those problems? ...

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...

SSRS. How to hide blank/empty column via expression?

reporting-services,ssrs-2008,expression,ssrs-2012
I need to hide column if all rows in column is empty (blank). In this case col3 should be hidden, because no values in column. col1 col2 col3 v1 v4 v2 v3 I'm using following expression on columns Hidden property: =IIF(Fields!Test5.Value = "",TRUE,FALSE) This expression working, but It hidding each...

Using a dropdown list to sort by dataset in SSRS 2008

sql-server,reporting-services,ssrs-2008
I am building an Audit History report for my companies application, but due to the requirements I have been given, I need to use multiple datasets. Is there a way to make a dropdown list that requires a selection to be made before the query is run, and that allows...

Hiding (or Displaying) Rows in SSRS Based off a Field Value

ssrs-2008,expression
I'd like to only display certain rows on my report using SSRS if the field value of EMID=3 or EMID=Null. Or if it would be easier, to hide rows where EMID in (1,2) I right + clicked the row -> Row Visibility -> Show or Hide Based on an Expression...

IIS 7.5 Error 500.19 but sporadically

asp.net,ssrs-2008,iis-7.5
I have Windows 2008 Sever R2, SQL Server 2008 with SSRS (not R2). I have the reportserver working, but sporadically it will give me this error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. I...

Filter report by date to show users registered this week through email in SSRS

sql-server,reporting-services,ssrs-2008,reporting,ssrs-2008-r2
I have a report with startDate and StopDate as parameters. I also configured smtp settings etc to send a report through email on specified time which is working fine. I am getting the stopDate from today() function but I dont know how to keep the startDate to Monday of the...

SSRS Use 1st Parameter (Multi choice) or 2nd Parameter (Text) for same SQL Parameter

reporting-services,parameters,ssrs-2008,multi-select,ssrs-2008-r2
I'm not sure if this is possible, but I would like to use 2x Report Parameters for the same SQL parameter. Currently I have the following in my WHERE clause which relates to a multi-select drop-down: and traderid in(@traderid) But I would like to have something along the lines of:...

Summing an SSRS column set

sql-server,reporting-services,ssrs-2008
I have a query which gathers Items from a database and generates a number of rows: SELECT ITEMID, SUM(dbo.CUSTINVOICETRANS.QTY) AS 'Quanity', SUM(LINEAMOUNTMST) AS 'Sales', COUNT(DISTINCT dbo.CUSTINVOICEJOUR.SALESID) AS 'Total Orders' INTO #tempItemRevenue FROM dbo.CUSTINVOICEJOUR INNER JOIN dbo.CUSTINVOICETRANS ON dbo.CUSTINVOICEJOUR.INVOICEID = dbo.CUSTINVOICETRANS.INVOICEID WHERE dbo.CUSTINVOICETRANS.DIMENSION2_ IN (@division) AND CONVERT(DATETIME, dbo.CUSTINVOICETRANS.INVOICEDATE, 101) BETWEEN @start...

How to open rdl Created with Visual Studio 2008, in Visual Studio 2012?

visual-studio,visual-studio-2012,reporting-services,ssrs-2008
I need to open an SSRS report that was created in Visual Studio 2008. I only have Visual Studio 2012, so I need to convert or upgrade the file. I followed the instructions at this site, but I still don't get what I need. How to edit SSRS 2008R2 Reports...

Report builder 3.0 cannot figure out how to make the correct expression

ssrs-2008
I want to show in the report builder a string with the values from different rows that belong to the same id separating them by , for example: id person= 1 , phone1 id person= 1 , phone2 So in the report builder I can show person phones 1 phone1...

SSRS 2008 add columns dynamically per id in a table.

sql-server-2008,dynamic,reporting-services,ssrs-2008,grouping
Here is an example of my dataset: ID Name Date DCMTest1 Planning 02-06-12 DCMTest1 Planning 01-09-13 DCMTest1 Planning 06-09-13 DCMTest2 Planning 03-08-11 DCMTest2 Planning 05-07-12 The result table has to add columns dynamically (the amount of columns is unknown). Here is an example of how I want the data in...

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 tablix Sorting not working on Date column

sorting,date,reporting-services,ssrs-2008,ssrs-tablix
I have a SSRS report one Stock#_______Description_____Colum1_____Colum2_____Colum3 ABC__________XYZ_____________4334________4354_______454 detail part Transaction#_______Date 1__________________yyyy/MM/dd } Need to be sorted 2__________________yyyy/MM/dd } this date column 3__________________yyyy/MM/dd } but always comes unsorted 4__________________yyyy/MM/dd } Note: (This is tablix) So one line for master and in detail part showing 4 last recent records. And this...

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...

Textbox data is cut off when exporting to Excel 2010 from SSRS 2008

excel,reporting-services,formatting,ssrs-2008,export-to-excel
I have an SSRS 2008 report that displays the textbox and it's content correctly in SSRS, but when I try to export it to Excel 2010 the data is cut off as seen below: http://imgur.com/49xLlRc I made sure that the CanGrow property for this textbox is set to True: http://imgur.com/MHxlhpq,paGR3aD...

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....

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]...

Summing lookups in SSRS

vb.net,oracle,reporting-services,ssrs-2008
I have an SSRS tablix that pulls data from several datasets resembling the following (changed to avoid explaining the exact context) : There is an employees dataset that gives the employee ID, the employee ID of their manager and the number of tasks they have completed e.g. Manager Employee Tasks...

Group tables and graphs in SSRS report

reporting-services,ssrs-2008
I have built a report with several tables and graphs and am looking to group the entire report by a specific field (agency reference #) with a page break between each agency reference # group. I would like for the output to be several pages long with the same report...

SSRS 2008 - Dynamic parameter works in Visual Studio, but has no available values on the Report Server

sql-server,visual-studio,sql-server-2008,reporting-services,ssrs-2008
The short version: My report has a param that sets the default of another param (both are dropdown, non-multiple-valued) using a dataset. This works as expected in Visual Studio, but on the Report Server the second param is blank (doesn't have any available values). The long version: I wrote a...

How to generate a monthly average of percentages with SSRS report

reporting-services,ssrs-2008
I currently have a column group set that gives me totals grouped by the month. At the bottom of that report I have a percentage rate that is generated by: Taking the total amount of calls with a status of answered and dividing them by all calls which is then...

Displaying Record Once in SSRS Table

ssrs-2008,expression
I've created a table from a procedure that will display a summary of all incentives from a given collection operation or recruiter in my report. But if the collection operation or recruiter has multiple incentives assigned to their drives during the time period, it will repeat the same collection operation...

Can SSRS create new columns instead of adding another row?

dynamic,ssrs-2008,grouping,ssrs-tablix
My report shows event level information but when the event has multiple records assigned, it creates additional rows in the report when I'd like for it to add additional columns instead. From my screenshot, you can see Drive ID 675276 (Autoo Owners Insurance) and Drive ID 681980 (Liberty Co. HS)...