reporting services - SSRS Creating Treeview -
so i'm having problems when trying make treeview group. have folder structure in database gives me path each node should have. problem recursive parent seems @ immediate parent child relationship opposed full structure of tree. problem have in case if still need tree, there no data representing specific folder. splitting folder structure use second last entry in array. public shared function parent(byval value string, byval delimiter string) string dim listarray() string listarray = split(value, delimiter) dim lastnonempty integer = -1 integer = 0 listarray.length - 1 if listarray(i) <> "" lastnonempty += 1 listarray(lastnonempty) = listarray(i) end if next redim preserve listarray(lastnonempty) dim retvalue string = "" if listarray.length - 2 > -1 retvalue = listarray(listarray.length - 2) else retvalue = listarray(listarray.length - 1) end if return retvalue end function lets have data in root\, have no data in roo