Stack Overflow
Stack Overflow

Questions tagged [ssrs-grouping]

Microsofts SQL Server Reporting Services (SSRS) allows creation of reports that contain Tablix controls where data is grouped by fields or expressions in row and/or column groups. Use the ssrs-grouping tag for questions about how to use group properties to change report behaviour.

SSRS reports can contain tablix controls (lists, tables, and matrices) which can group data in row and/or column groups. Use this tag for questions specific to this grouping behavior.

412 questions
0
votes
1 answer

SSRS Column visibility based on drill down level

I want to achieve a drill down report where based on the drill level a certain column should show, otherwise be hidden dynamically (without republishing). These screens should help. 1. Design View https://i.stack.imgur.com/sd2SU.jpg 2. Preview -…
Lemon_land
  • 23
  • 1
  • 5
0
votes
1 answer

Error : Cannort create a connection to Data Source 'XYZ' in SSRS

I have deployed a SSRS report for the user.But while accessing the report from the report server user is getting the below error But I and some of the users are able to access the same report,Please suggest me.Do i need to add him in any…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

Formatting the legend in an SSRS chart with grouping

I've got a dataset of values that are based on keys and dates. For example, one date will have three different values with three different keys. So far as I know, the only way to get different series' based on keys is grouping. In addition, I want…
GGMG-he-him
  • 394
  • 1
  • 7
  • 26
0
votes
1 answer

SSRS 2008 Group On a Matrix Table

i am having trouble grouping a certain field in a matrix table under the column level . i need the field to be grouped instead of shown once on every row as a different entry https://i.stack.imgur.com/QrDyl.jpg edited.
user1711639
  • 13
  • 1
  • 4
0
votes
1 answer

SSRS Tables - Grouping Part Numbers without showing properties until list is dropped down

I was wondering if it is possible to have a SSRS table where I group by the part number and all preceding field's values will show after I click on the drop down? Currently I have a list grouped by part numbers and the parts requirements show on the…
ltsai
  • 757
  • 3
  • 8
  • 16
0
votes
1 answer

SSRS report Paramenter Refresh

I have a SSRS report, contains 'State' and 'County' as parameter. In a scenario, state->CA(California), selected and all the counties are selected in County filter, belongs to CA. Now User selects a few other states, the county filter is refreshed…
Varun
  • 426
  • 3
  • 7
  • 18
0
votes
1 answer

How to create group in SSRS 2005

i want to create my report(rdlc) like this in the picture.I am using reportdefiniton 2005.please help how to group it like this
user3662929
  • 9
  • 1
0
votes
1 answer

How can I force both tables to render in a single page with pagebreak set on "Id"?

I've been developing an SSRS report that contains two tables. The first "table" uses DataSet "A" & second "table" uses DataSet B. In both DataSet, an "Id" is common. My requirement was to group data on "Id" in both the tables. That I did. Two…
Aditya
  • 2,299
  • 5
  • 32
  • 54
0
votes
3 answers

Issue while exporting SSRS report into excel

i have 2 tables in a report one below the other,Each will have same number of fields .But when i export the report in to excel each report field is taking 2 columns in the excel and some of them taking only one excel column for one report…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

How to make some of the Column lines Bold in SSRS

I have 36 columns in a table report,I need to make bold lines for every 3 columns.I tried Border style Solid and Double but still i could not make the changes.What should be done to make the lines bold
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

SSRS Break after set amount of rows not behaving as expected

I am working on SSRS in Visual Studio 2012. I have a set of data that I need to break after every 16 rows. Using examples I found, I create a group on the details that groups on the following expression: =CInt(Ceiling(RowNumber(Nothing) / 16)) Then…
Marilee Garcia
  • 1
0
votes
1 answer

Need To Calculate Percentage Difference In ssrs with multiple row and column Grouping

I have row and column grouping. I need difference and percentage difference for each month as shown below: Example: march diff 2013 2014 Hyderabad 12 15 15-12=3 Like this…
user3581406
  • 1
  • 1
  • 1
0
votes
1 answer

SSRS - How to Split comma " , " seperated values in a cell to adjacent different column with same column header in SSRS

How could I Split comma " , " seperated values in a cell to get value into adjacent different column with same column header in SSRS I got a query table in SSRS report as follows ProjectNo. | ProjectName | Client | …
Dee Law
  • 78
  • 1
  • 6
0
votes
1 answer

How to replace nonNumeric value in Column value with 0 in SSRS

I have a Column which has the percentage values,i have a infinity symbol as one of value.But i need to replace all the non numeric values with 0's .How can i replace all non numeric values to …
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
0 answers

I am Getting Error in the expression in SSRS

Hi I have a An expression on one of the column in Tablix like =Iif(month(today)="5",…
SqlLearner
  • 763
  • 8
  • 23
  • 37
1 2 3
…
27 28