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:

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


i have simple table based on this:

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

=cstr(2 + (level()*10)) + "pt" looks requirement:

Comments
Post a Comment