sqlreporting-servicesssrs-2008repeat
SSRS remove duplicate row entries
I need to see all the notes but not repeat the name and account number. Please see the example below. I'm using SSRS report builder 2008.
This is how it currently looks:
Name|Account|Note John|123456 |note1 John|123456 |note2 John|123456 |note3 John|654321 |note1 John|654321 |note2 John|654321 |note3
I'd like it to look like this:
Name|Account|Note
John|123456 |note1
| |note2
| |note3
John|654321 |note1
| |note2
| |note3
Solution
Here you cna try by adding Row group on your tablix.
You need to add first Row group on Name and second row group on Account so it will be look like
Name|Account|Note
John|123456 |note1
| |note2
| |note3
John|654321 |note1
| |note2
| |note3
search for row group you will get result.
check below image
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?