Creating bookmark structure in report

[Michael Hilgers]

Hi Everyone,

i'm trying to solve the following "problem":

I have a database view which returns, lets say, 10 rows with data. One of the fields returned by the view contains a folder path string.

2 folders have a folder path like "RootFolder\Subfolder1"
3 have "RootFolder\Subfolder1\SubSubFolder1"
1 has "RootFolder\Subfolder2"
4 have " "RootFolder\Subfolder3"

So my target is to get the following bookmark tree:

RootFolder
|_________Subfolder1
                   |________SubSubFolder1
|_________Subfolder2
|_________Subfolder3


But currently i'm getting the following bookmark tree generated by the report engine:

RootFolder\Subfolder1
RootFolder\Subfolder1\SubSubFolder
RootFolder\Subfolder2
RootFolder\Subfolder3

I sorted the data by the folder field, so the "structure" is correct, but the tree is not nested. How can i created a nested bookmarkt tree out of folder path strings? Is that possible?

Regards,
Michael

[Massimiliano Bassili]

It is not clear whether you use the built-in document map support or you try to mimic this in the report directly. If the first, then here is what the docs (http://www.telerik.com/help/reporting/designing-reports-document-map.html) say:
"    To form hierarchical structure of the document map, you may set the DocumentMapText property of the report groups, the CrossTab/Table groups, the Detail section and the Report (useful for SubReports). For example nested groups will create nested nodes in the tree. Each of the produced nodes will navigate to the most appropriate page and location in the rendered report. For example bookmark of a report group will navigate to the group header (or first detail inside the group if header is not visible)."

Cheers!

[Michael Hilgers]

Hello Massimiliano,

thanks for you reply. But i'm afraid i could not point out whats my problem ;)

I think i cannot use the build-in document map generation because the data i want to display are not hierarchical, only the content of the field "folderPath" contains a logical hierarchy. And this is what i wana have in the document map.

I've created a group which groupes on the field "folderPath" and has this field as the DocumentMapText too. So i get the Document Map, but not nested (because the report engine doesn't know how to nest the data).

So the question is: is there a way to tell the report how to group these trings to a nested document map?

Regards,
Michael

[Steve]

Hello Michael,

As far as we understand, basically you want to create a group hierarchy for each of the folders, but you cannot accomplish this out of a string i.e. there is no out of the box solution. What we can suggest is creating an User Function with two parameters - the folder path and the nested level. In that user function you would be able to separate the nested levels so you can use the result for group expression. However note that the nested level should be known e.g. 3 folders deep. Then you can create Calculated Fields that utilize the user function for the different levels and create the group hierarchy correctly in the report.

Kind regards,
Steve
the Telerik team

[Michael Hilgers]

Hi Steve,

this was my idea too, but i don't know the levels ;) It can be 1 or can be 7, this is dynamic. And as far as i understood this is just not possible in reporting engines (not only Telerik) because the detail section is always only in the deepest group and not in every group.

If there were a detail section in every group it would be easier because all unneeded subgroups could be set invisible and the detail data is shown on the correct level. But i fear there is no solution for this problem or are there still more ideas?

Best Regards,
Michael

[Michael Hilgers]

Okay, now we've decided with our customer to use a fixed folder structure.

So far my user function for extraction the correct "level" text from the folderString works and i can create the DocumentMap structre i want.

But there are still some entrys in the DocumentMap tree generated by Telerik and i don't know how to remove them because they are not wanted in my case.

In the attachment of this post there is a picture of the created DocumentMap strucure. The entrys marked with a red arrow are the entrys generated by telerik. How can i remove them or set them invisible? They are not an output of my user function. If i remove the DocumentMapText property of my groups, ONLY the entrys marked with red arrow are displayed in the DocumentMap.

Any ideas?

Michael

[Michael Hilgers]

Got it! Was still a error on my side. Somewhere where i didn't expect it was another DocumentMapText Property set ;)