Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag for United States of America asked on

Adding a navigation list to report

i've used the navigation tab (table->properties) to make "quick links" to various sections of a report...

i'd like to do something similar...
i'd like the navigation pane to show a list of items based on fields!items.value
i tried adding the field to the navigation tab, and it correctly prints out the first item in the report... however, i want to see a complete list of items in the report.

can this be done, and if so, how?
ex.bmp
DB Reporting ToolsMicrosoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
zephyr_hex (Megan)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tone' Shelby

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Tone' Shelby

Also;
You can add links that allow users to open Web pages or other reports, or jump to another location within the same report. Reporting Services supports three types of links: Bookmark links - jump to other areas within the report.
Drillthrough Report links - jump to other reports.
Hyperlinks - jump to Web pages.
Adding Links to a Report (How To Links contained:
http://msdn.microsoft.com/en-us/library/ms159088.aspx

 
jgv

Looking at the screenshot you should be able to see both items in the document map. Are the item numbers in the same table or is that 2 different tables?
zephyr_hex (Megan)

ASKER
the items are in the same table...

maybe i didn't do the settings on the navigation tab right?
i'm attaching what i have below


tshel... i was able to get what i have so far using the document map.  my question is how to get all of the items to show.  it's only showing the first item on the report... and not the next item.  my topmost Group is ItemNumber.
nav.bmp
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
jgv

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Tone' Shelby

thanks igv much appreciated. Yes that would have been where I would have directed you too asker...

Good luck with your navigation ...
zephyr_hex (Megan)

ASKER
yup, that worked
zephyr_hex (Megan)

ASKER
tshel had the link, and jgv had the explanation of what i needed to do using the info from the link given.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.