I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format. I tried all expr...

I'm using Join(Lookupset) to find unique group values which returns a sequence number. This is my function: Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Val...

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 one of the column name, I need to display yesterday's date like - September 4,2014 I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM. How can ...

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

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 2432 2656 Line 3 2318 1622 2800 A 345 ...

I have a table in a SSRS report that is displaying only a group, not the table details. I want to find out the row number for the items that are being displayed so that I can use color banding. I t...

I have a report that allows Finance to print off multiple invoices at the same time. The problem I'm running into is that they want the Bill To information repeated on each page of the invoice. I ...

This is my report. Above row contains a parent row group and a child row group. I have done border formatting of the report . I simply right click each Text box and gives border accordingly. But...

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT AL...

I have an SSRS report which is failing to export to excel when the row count is greater than the Excel 2003 limit of 65536 The report already has a grouping level with a group footer. I have trie...

I have this data DateRecived JObNumber REcCnt 20130626 1234 1 20130627 1238 11 20130628 1240 2 20130629 1242 23 I applied the group by on dateRecieved in ssrs and get the output as DateRecive...

i am new to the SSRS and Have data as below RCnt Jobnumber NJCT JD pmt flag cnt1 cnt2 2 001008 0 PRESSURE SEAL PSI Y 0 0 2 2 001008 0 PRESSURE SEAL PSI Y 0 0 10 2 001008 0 PRESSURE SEAL PSI Y 0 0...

I'm using SSRS to create a report which shows a lot of transactions according to a trade date. I've made a group on the month and year called 'grpMonthYear'. Inside that group I've made a subgroup ...

I would like to check the RowCount of a filtered group from without the scope of the group. I particularly would like to know when the group is empty so that I can set the Hidden property on anot...

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), su...

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Ma...