I have a tablix that has data for one day, and I need to have the same data at the bottom but in 3 different lines. I'd like to copy the main day table 3 times at the bottom, and then use different...

I have updated the SP for the attached dataset that the tablix is using. The refresh worked fine and I can see my new fields in the shared data set when I look in the Fields tab. My problem is the ...

I have a SSRS report one Stock#_______Description_____Colum1_____Colum2_____Colum3 ABC__________XYZ_____________4334________4354_______454 detail part Transaction#_______Date 1____________...

I'm trying to define interactive sorting in a tablix. The sorting should affect the row order. Attaching image of the tablix in order to explain what I'm trying to get: I already tried to defin...

I have a tablix box that has a division expression. When dividing by zero or nulls I get #Error displayed in my report. I tried to create an IIF statement and tested with static values. This verifi...

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)

enter image description hereTrying to use SSRS in Visual Studio 2019 Community. I am able to create a new "Report Server Project" Project in VS. However, when I try to "Add New Item&...

I'm exporting an SSRS Report to Excel and when the user tried to sort it for some column. They got the message "This operation requires the merged cells to be identically sized. How can I generat...

DISCLAIMER: All of this information is completely fake on the report for testing purposes. I have a report which contains a text box that is getting back a lot of data from a query. The issue is t...

Consider the following data source: declare @Test table (EmpId int, ProdId int, Sold int) insert @Test (EmpId, ProdId, Sold) values (1, 1, 1) insert @Test (EmpId, ProdId, Sold) values (1, 2, 2) in...

I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression f...

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a...

In my report I have 1 tablix with 1 row group and 1 column group. When I deployed, my report showed me the following error : Warning : The tablix 'Tablix1' has an incorrectly set FixedData prop...

I have markup text (HTML tags) in one of the SQLView\columns, which I have to show in a Tablix report as a formatted text in one column. Markup is for bold, italic, underline. I could enable the ...

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on ...

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy t...

I have a tablix in SQL REPORTS (SSRS) that has many grouped items. It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want ...

Below figure is my report. This tablix has 10 row from dataset. It's grouped by TOOL_CODE and TYPE for get count. At "Count" Column is use this expression .. = Count("Detials") "Detials" is ...

I need to change the Table Cell Background color to Yellow and Font color to Bold / Red for values which are less than 80. Cell Expression is =Fields!Mark.Value How to change the Cell Background ...

By default, csv takes the text box name as the csv header name for the columns. The text box does not allow a space. How do I make a different header than the text box for the csv? Is there a way...

I had a problem of couting sum of grouped rows in a tablix. I posted it on stackoverflow. There I found the detailed answer by a user. But the problem is now, he is asking me to add "Add Total" in ...

I currently have a Matrix within an SSRS report. Usually, the matrix will fix to a standard page in portrait mode, however there are cases where the length of the columns will exceed a page. Is the...

I have a report with a table in it. I need to change the dataset that this table uses. When I go the tablix properties and try to change the DataSetName, it automatically gets reverted back to the ...

I am generating an SSRS report whose results are displayed like so: I need to append similar query results (same exact query, one different parameter value) to the right of this data, so that on...

I'm trying to figure out if there is any way in Report Builder 3.0 to concatenate or merge 2 different "DataSet" objects which both have exactly the same column names into one set of data, fo...