This is a migrated thread and some comments may be shown as answers.

"Back to top" hyperlink when using multiple groups

1 Answer 80 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
James
Top achievements
Rank 1
James asked on 12 Mar 2013, 05:52 PM
I have a telerik report (converted from Crystal Reports) which uses a dataset of user logon information.

Fields included are IP address, User Account, Time of Logon, Logon Success, etc.

There are two groupings currently.  The first grouping is by IP Address.  Then within that there is a group by User Account.

An example report would look like this:

192.168.1.1

            Admin
                        Admin        1/1/2001        Success
                        Admin        1/2/2001        Fail
           Total for this User: 2                                   [back to top link]*

            User52
                        User52        3/1/2001       Fail
                        User52        4/1/2001       Success
                        User52        4/1/2001       Success
            Total for this User: 3                                   [back to top link]*

Total for this IP Address: 5                                     [back to top link]


192.168.2.2
            Admin
                        Admin          5/1/2001       Success
            Total for this User: 1                                    [back to top link]*

Total for this IP Address: 1                                      [back to top link]

---------------------------------

The issue I'm encountering is the "back to top" hyperlink I have in the "User Account" footer (the ones with the astericks) are navigating to the first instance of that User Account value in the entire report.  I want the hyperlinks to navigate to the first instance of that User Account within the current User Account group.  The hyperlinks themselves are necessary for our clients as each IP address listed (and User Accounts within) may span multiple pages.

I have the "Action" on my "back to top" textbox set to "Navigate to Bookmark" and I've tried: 
a) setting the bookmark action to the actual "User Account" field (=Fields.[fld1]) from the drop-down list.
b) setting the "User Account" group (not header) bookmark ID to the actual "User Account" field (=Fields.[fld1]) and then setting the "Navigate to Bookmark" to the same.
c) setting the "User Account" group (not header) bookmark ID to "UserBookmark" and then setting the "Navigate to Bookmark" to "UserBookmark".

All three result in the same issue of it the link navigating to the first instance of that User Account within the report instead of the first instance of that User Account within the group..

The help says for adding bookmarks to a group: "Typically for a group, the expression you type should be the group expression".  If this is not what I tried in B) above, can someone please let me know what to do?

The help also mentions "The BookmarkId can be any string, but it must be unique in the report. If the BookmarkID is not unique, an action to the bookmark finds the first matching bookmark." - which I assume is what I am encountering.  I'm guessing it hasn't been an issue in most of my reports because they do not use secondary grouping where a secondary group header may exist within more than one primary group headers.

Any help would be appreciated. I'm still trying to learning telerik, but I keep running into things that were possible in Crystal but are proving difficult (or impossible) here.

Thanks,

James

1 Answer, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 14 Mar 2013, 03:43 PM
Hi James,

In the group header for the account group, you should put an item with the following bookmark ID:
= Fields.Account
and in the group footer, you should put the following navigateToBookmark action:
= Fields.Account
both expression will be evaluated to = First(Fields.Account) (since you do not specify an aggregate explicitly)

The scenario is analogical for the IP group.

Please find the attached report showing the expected "Back to Top" functionality with two report groups. 

Kind regards,
Elian
the Telerik team

Telerik Reporting Q1 2013 available for download with impressive new visualizations. Download today from your account.

Tags
General Discussions
Asked by
James
Top achievements
Rank 1
Answers by
Elian
Telerik team
Share this question
or