Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-09-2018, 07:18 AM   #1
JMichaelM
Newly Registered User
 
Join Date: Aug 2016
Posts: 101
Thanks: 45
Thanked 1 Time in 1 Post
JMichaelM is on a distinguished road
Report with TOC/Hyperlinks

Very Happy Friday! I got some incredible support and guidance the past few weeks which was great in terms of motivation and helped lead me to very productive results. With that in mind, I am grateful and was able to create a very useful report containing about 6 reports all with charts etc. which comes out to about 40 pages in a pdf or so. What I'd like to do is create links at the beginning of the report which the reader/viewer can link to the specific report within the pdf.

Synopsis:
-Cover
-10 Reports seperated with page break when onto pdf


Potential Solution:

-Cover
-TOC with Hyperlinks to the beginning of each report in complete pdf.

My question is how I would tactically go about this in a way which is non-manual and automated?


Their may be a solution someone has already utilized which may save me considerable time or someone may have some experience on how to approach this solution.

Thank you in advance for your help.

JMichaelM is offline   Reply With Quote
Old 03-09-2018, 07:30 AM   #2
HimAgain
Newly Registered User
 
Join Date: Sep 2015
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
HimAgain is on a distinguished road
Re: Report with TOC/Hyperlinks

Found this on the net. Below is the link to the article along with a copy paste of the article. Hope this helps
from technet.microsoft.com/en-us/library/ms159823(v=sql.100).aspx



How to: Add a Bookmark to a Report (Reporting Services)
Add bookmarks and bookmark links to a report when you want to provide a customized table of contents or to provide customized internal navigation links in the report. Typically, you add bookmarks to locations in the report to which you want to direct users, such as to each table or chart or to the unique group values displayed in a table or matrix. You can create your own strings to use as bookmarks, or, for groups, you can set the bookmark to the group expression.

After you create bookmarks, you can add report items that the user can click to go to each bookmark. These items are typically text boxes or images.

For example, if your report displays a table grouped by color, you would add a bookmark based on the group expression to the group header. Then you would add a table with a single text box at the beginning of the report that displayed the color values, and set the bookmark link on that text box. When you click the color, the report jumps to the page that displays the group header row for that color.

You can add a bookmark to any report item and add a bookmark link to any item that has an Action property, for example, a text box, an image, or a calculated series in a chart. For more information, see the Action page topics in Report Designer F1 Help.

To add a bookmark
In Design view,select the text box, image, chart, or other report item to which you want to add a bookmark. The properties for the selected item appear in the Properties pane.

NoteNote
If y the Properties pane is not visible, click Properties Window on the View menu.

In the text box next to Bookmark, type a string that is the label for this bookmark. Alternatively, click the expression (fx) button to open the Expression dialog box to specify an expression that evaluates to a label. For a group, the expression you type should be the group expression.

NoteNote
The bookmark can be any string, but it must be unique in the report. If the bookmark is not unique, a link to the bookmark finds the first matching bookmark.

To add a bookmark link
In Design view, right-click the text box, image, chart, to which you want to add a link and then click Properties.

In The Properties dialog box for that report item, click Action.

Select Go to bookmark. An additional section appears in the dialog box for this option.

In the Select bookmark box, type or select a bookmark or an expression that evaluates to a bookmark.

Click OK.

To test the link, run the report and click the report item that you set this link on. For text boxes, it is helpful to change the color and effect if the text to indicate to the user that the text is a link. For example, change the color to blue and the effect to underline by setting the Font properties in the Text Box Properties dialog box.
HimAgain is offline   Reply With Quote
Old 03-09-2018, 07:34 AM   #3
JMichaelM
Newly Registered User
 
Join Date: Aug 2016
Posts: 101
Thanks: 45
Thanked 1 Time in 1 Post
JMichaelM is on a distinguished road
Re: Report with TOC/Hyperlinks

This to save a $400 Adobe Acrobat license. Thanks for the info.

JMichaelM is offline   Reply With Quote
Old 03-09-2018, 07:36 AM   #4
HimAgain
Newly Registered User
 
Join Date: Sep 2015
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
HimAgain is on a distinguished road
Re: Report with TOC/Hyperlinks

Glad i could help.
HimAgain is offline   Reply With Quote
Old 03-09-2018, 07:36 AM   #5
JMichaelM
Newly Registered User
 
Join Date: Aug 2016
Posts: 101
Thanks: 45
Thanked 1 Time in 1 Post
JMichaelM is on a distinguished road
Re: Report with TOC/Hyperlinks

Looks like it may be for SSRS
JMichaelM is offline   Reply With Quote
Old 03-09-2018, 07:55 AM   #6
HimAgain
Newly Registered User
 
Join Date: Sep 2015
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
HimAgain is on a distinguished road
Re: Report with TOC/Hyperlinks

DOh... sorry about that.
HimAgain is offline   Reply With Quote
Old 03-09-2018, 07:57 AM   #7
JMichaelM
Newly Registered User
 
Join Date: Aug 2016
Posts: 101
Thanks: 45
Thanked 1 Time in 1 Post
JMichaelM is on a distinguished road
Re: Report with TOC/Hyperlinks

No Worries. I actually have SSRS installed and wanted to start using it. Do you know if it is difficult?

JMichaelM is offline   Reply With Quote
Old 03-09-2018, 08:34 AM   #8
HimAgain
Newly Registered User
 
Join Date: Sep 2015
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
HimAgain is on a distinguished road
Re: Report with TOC/Hyperlinks

I have no clue. I just did a search for ms access report bookmarks and that was the first thing to pop up.
HimAgain is offline   Reply With Quote
Old 03-11-2018, 06:14 AM   #9
HimAgain
Newly Registered User
 
Join Date: Sep 2015
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
HimAgain is on a distinguished road
Re: Report with TOC/Hyperlinks

Ok How about this. For your TOC in the report header, make each link a button (make the button flat or what not if you want it to look just like text). Then make an on click event to set focus to the first control in each form you want to link to.

Code:
Private Sub rep_link_1_Click()
rep1_txt.SetFocus
End Sub
See if something like this can work for you.
HimAgain is offline   Reply With Quote
Old 03-11-2018, 09:21 AM   #10
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,177
Thanks: 83
Thanked 1,520 Times in 1,419 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: Report with TOC/Hyperlinks

Going back to the first post, AFAIK you have to purchase the full version of Acrobat to merge multiple PDF files into one file...and that is expensive.

I am not aware of any alternatives to Acrobat that can do this at a lower cost but its worth researching this yourself.

Whilst you could export the reports to Word, merge them and then convert to PDF...the Word version of your reports will almost certainly look awful.

Can you instead use multiple subreports to create one report containing all your info and then export as one PDF? Or is this what you already have? You could include a TOC of some kind as part of the overall report though I'm not sure how to automate that.

If not, I would do as I have done in the past and export all reports as separate PDFs prefixed by a number indicating the reading order, zip them and email with the zip file as attachment. This was largely automated and worked well. I haven't done this for a few years but if it looks useful, I can check how I used to do it

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PDF Report with clickable hyperlinks fat controller Reports 13 09-29-2016 01:32 AM
Question Report Broken Hyperlinks? sjd General 0 07-05-2012 09:54 AM
Report Hyperlinks jsic1210 Reports 6 06-28-2012 05:22 AM
Hyperlinks in report grego9 Forms 4 08-17-2009 04:34 AM
Hyperlinks on a report csou5555 Reports 2 02-24-2006 01:22 AM




All times are GMT -8. The time now is 07:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World