Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vbhavanam
Starting Member
1 Post |
 Posted - 2008-04-10 : 17:55:27
|
| Hi,I have a huge report grouped by Branches, Each branch might have 10 - 20 or even more pages of data. Now i want to build a Table of Content on the first page which will have Branch Name and Page number, clicking on that Branch name should take to that particular branch page, This will also be exported to excel. How do i obtain page numbers? I'm using a table to show Table of Content and next i have list and a matrix within the list (i'm using list because if i use table i cant see full data when exported to excel). I tried using Bookmark, it works in report manager but when i incorporated in .NET (SOAP technology) book mark does not work, so i dont want to use bookmark id.Any help would be greatly appreciatedThanks |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-04-11 : 10:02:51
|
I'm pretty sure there is a better way to do this  ,as I am pretty week in .Net.But here is my suggestion.Assuming the report page numbers are never going to change.In your table of content you have a page number by the side of each branch name.Bold and Underline and change color of font to blue[make it look like a hyperlink] the page number [keep it as a static data][example :Page Number 1].This would allow report users to understand they need to click on the report page.On the static page number,Right Click and In navigation tab,use jump to report.And specify the reports that it would need to navigate to once user clicks on page number.sound like cheating..hopefully this is a little help. |
 |
|
|
|
|
|
Page numbers