reporting services - SSRS Multi Level List -


i trying set list multiple levels. having troubles setting data , wondering if provide suggestions.

my list of data:

| part # | previous part # | ---------------------------- part1 sub-part1         part1 sub-sub-part1     sub-part1 part2 sub-part2         part2 part3 part4 part5 sub-part5         part5 

what looking list below:

part1   sub-part1      sub-sub-part1 part2   sub-part2 part3 part4 part5   sub-part5 

what getting in ssrs exact copy of list of data. part# shows multiple times each assembly.

how set data in order achieve result described above?

thanks!

assuming ssrs 2008 or above, can use hierarchy groups achieve this.

some sample data:

enter image description here

as per msdn article, set group based on part, , set recursive parent parentpart:

enter image description here

enter image description here

i have simple table based on this:

enter image description here

to padding, set part textbox left padding value expression-based:

enter image description here

=cstr(2 + (level()*10)) + "pt" 

looks requirement:

enter image description here


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

thorough guide for profiling racket code -