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 root\certificates other file root\certificates\some company. folder structure gets messed because doesn't register parent child of root certificates since no data defined under structure.
folderpath root\ root\blacklist\ root\certificates\some company\ root\reports\ root\something else\some company\
is there way can feed in treeview nodes individually, or can think of way parse of these , keep structure? appreciated. :)
Comments
Post a Comment